🔹 Phase 1: Excel Mastery (2-3 Weeks)
📌 Goal: Build a strong foundation in data handling & analysis using Excel.
📖 Chapters & Topics:
✅ Basic Functions: SUM, AVERAGE, COUNT, CONCATENATE
✅ Data Cleaning: Remove duplicates, TRIM, PROPER, TEXT functions
✅ Logical Functions: IF, AND, OR, IFERROR
✅ Lookup & Reference: VLOOKUP, HLOOKUP, INDEX-MATCH
✅ Pivot Tables & Pivot Charts: Summarizing large datasets
✅ Data Validation & Conditional Formatting
✅ Power Query: Automate data cleaning & transformations
✅ Basic Data Visualization: Charts & Graphs
📌 Recommended Course:
🎥 Excel for Data Analysis - Coursera
📌 Practice: Work on real datasets (e.g., Sales or HR data).
🔹 Phase 2: SQL for Data Analysis (3-4 Weeks)
📌 Goal: Learn how to query and manipulate data in databases.
📖 Chapters & Topics:
✅ SQL Basics: SELECT, WHERE, ORDER BY, DISTINCT
✅ Filtering & Aggregations: GROUP BY, HAVING, COUNT, SUM, AVG
✅ Joins & Relationships: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
✅ Subqueries & CTEs: Common Table Expressions
✅ Window Functions: ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG
✅ Data Cleaning in SQL: Handling NULL values, String Functions, Date Functions
✅ Indexes & Performance Optimization
✅ Case Study: Build a complete Sales Data Analysis in SQL
📌 Recommended Course:
🎥 SQL for Data Science – Udacity
📌 Practice:
● Work on Kaggle datasets
● Solve SQL challenges on LeetCode
🔹 Phase 3: Power BI / Tableau for Data Visualization (3-4 Weeks)
📌 Goal: Learn how to create interactive dashboards & reports.
📖 Chapters & Topics:
✅ Connecting Data Sources (Excel, SQL, APIs)
✅ Data Cleaning & Transformation (Power Query)
✅ Creating Basic Visuals: Bar, Line, Pie, Maps
✅ Filters & Slicers: Interactive dashboard elements
✅ DAX (Data Analysis Expressions): Calculated Columns, Measures, SUMX, CALCULATE
✅ Creating Relationships & Data Modeling
✅ Building a Sales Dashboard
📌 Recommended Course:
🎥 Power BI Fundamentals - Udemy
📌 Practice:
● Create a Power BI dashboard using your SQL queries.
🔹 Phase 4: Python for Data Analysis (4-6 Weeks)
📌 Goal: Master Python for data cleaning, analysis & visualization.
📖 Chapters & Topics:
✅ Python Basics: Variables, Loops, Functions
✅ Data Manipulation with Pandas: DataFrames, Filtering, Aggregations
✅ Data Cleaning: Handling Missing Data, Duplicates, String Operations
✅ Exploratory Data Analysis (EDA):
● Matplotlib & Seaborn: Data Visualization
● NumPy: Numerical Computation
✅
● Scipy & Statsmodels: Basic Statistics
Advanced Analysis: GroupBy, Pivot Tables, Multi-Indexing
✅ Automating Reports with Python
✅ Case Study: Sales Forecasting using Python
📌 Recommended Course:
🎥 Python for Data Science – Coursera
📌 Practice:
● Work on real datasets from Kaggle
● Try Jupyter Notebook for hands-on coding
🔹 Phase 5: End-to-End Data Analytics Project (2-3 Weeks)
📌 Goal: Apply all your skills (Excel, SQL, Power BI, Python) in a real-world scenario.
Project Idea: Amazon Sales Analysis
1️⃣ Extract data from a database (SQL)
2️⃣ Clean & analyze data (Excel, SQL, Python)
3️⃣ Build a visualization dashboard (Power BI)
4️⃣ Generate insights & recommendations
📌 Example Dataset:
🔗 Amazon Sales Data – Kaggle
🔹 Phase 6: Resume, Portfolio & Job Applications (2-3 Weeks)
📌 Goal: Build a portfolio, update your resume, and start applying!
📖 Steps:
✅ Upload your projects on GitHub & Tableau Public
✅ Create a strong LinkedIn profile
✅ Practice SQL & Python interview questions
✅ Apply for 50+ Data Analyst jobs on LinkedIn, Indeed, Glassdoor
📌 Where to Apply?
● 🔹 LinkedIn Jobs
● 🔹 Indeed
● 🔹 Glassdoor
📌 Interview Preparation:
● SQL Challenges: LeetCode SQL
● Data Analyst Case Studies: Maven Analytics
📌 Final Roadmap Summary (Total ~5 Months)
Phase Skill Duration
1 Excel 2-3 Weeks
2 SQL 3-4 Weeks
3 Power BI 3-4 Weeks
4 Python 4-6 Weeks
5 Project 2-3 Weeks
6 Portfolio & Job Hunt 2-3 Weeks
