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