Data Analyst Road Map

Road Map to Data Analyst 🚀

This roadmap is crafted to guide someone with 3 months to becoming a proficient data analyst 📊✨

💹 Excel (1 & 2 Week)

Excel is fundamental to begin with, requiring at least a week to become familiar with its interface and shortcuts. Additionally, I’m attaching a useful project that covers essential Excel topics.

Important Formulae that will be frequently used in day-to-day Excel work 📊🔑

  • SUM
  • MEAN
  • AVERAGE
  • MEDIAN
  • SUMPRODUCT
  • CONCATENATE
  • VLOOKUP
  • INDEX
  • MATCH
  • IF
  • COUNTIFS
  • SUMIFS
  • IFNA/IFERROR

Data Visualization and Analysis Tools

Charts, Filters, Sorts, Slicers, Pivot (Tables and Charts)

Key Points and Notes are available in linked page : Excel

YouTube link :


📊 Statistics and Maths ( 1 Week)

Parallelly plan with the Excel

Concepts that are important to know

Basic Math:

  • Arithmetic
  • Weighted average
  • Cumulative sum
  • Percentile

Basic Statistics

  • Mean
  • Median
  • Mode
  • Standard deviation
  • Normal distribution

Key Points and Notes are available in linked page : Stats and Maths

To learn more about Statistics please refer to the attached link : https://www.simplilearn.com/tutorials/statistics-tutorial/probability-density-function


Core Skills

Core skills for a Data Analyst include proficiency in SQL, familiarity with BI tools tailored to specific needs, and competence in Python, particularly focusing on essential libraries like Pandas and NumPy.

SQL (3,4,5 Weeks)

SQL (Structured Query Language) is an essential tool for data analysts. It is designed for managing and manipulating relational databases, allowing you to retrieve, update, and analyze data efficiently.

Basic Queries

  • SELECT,
  • WHERE
  • DISTINCT
  • LIKE
  • BETWEEN
  • ORDER BY
  • LIMIT
  • GROUP BY
  • HAVING CLAUSE
  • INSERT
  • UPDATE
  • ALTER
  • IMPORT
  • Data types

Advance Queries

  • Date time function
  • Window function
  • Sub query
  • Case statement
  • CTE
  • query optimisation

JOINS

  • Inner
  • Outer
  • Left
  • Right

Understanding the order in which SQL queries are executed is crucial for writing efficient and correct SQL statements. The execution order of a SQL query follows a specific sequence of operations, which is summarized here : SQL Commands and Query Execution Order

Key Points and Notes are available in below linked page : SQL

To learn more about SQL please refer to :https://www.w3schools.com/sql


PowerBI (or) Tableau (6,7,8 Weeks)

PowerBI (Udemy Course) : https://www.udemy.com/course/powerbi-complete-introduction/?couponCode=24T6MT62024

Tableau (Udemy Course) : https://www.udemy.com/course/tableau10/?couponCode=24T6MT62024


Python (9, 10, 11 Weeks)

Topics in Python:

  • Variables
  • Data types
  • Lists
  • Tuples
  • Dictionaries
  • Sets
  • Conditional expressions
  • Modules
  • Functions,
  • Operators
  • if statements
  • Loops
  • classes and objects

Python libraries:

Pandas: read/write csv, excel and JSON files, work with dataframe, data manipulation and analysis- Group by, Concatenate, Merge Matplotlib: creating static, animated, and interactive visualizations in Python

Key Points and Notes are available in below linked page : Python


Some useful Project Links that can be added to Linkedln or Resume


Interview Questions

SQL Interview Questions

Scroll to Top