📅 3-Month Data Analytics Learning Roadmap

Month 1: Excel & Data Foundations

Week 1: Excel Basics & Productivity

• Excel interface, formatting, shortcuts

• Formulas (SUM, AVERAGE, MIN, MAX, COUNT, IF)

• Sorting, filtering, conditional formatting

• Case Study: Sales Data Cleaning

Week 2: Advanced Excel for Analytics

• VLOOKUP, HLOOKUP, INDEX + MATCH, XLOOKUP

• Text, Date & Time functions

• Data validation (drop-downs)

• Case Study: HR Employee Database

Week 3: PivotTables & Dashboards

• PivotTables, PivotCharts

• Slicers, Timelines

• What-if Analysis, Solver

• Dashboard Design Principles

• Project: Build a Sales Dashboard in Excel

Week 4: Statistics Basics

• Mean, Median, Mode, Variance, Std Dev

• Probability distributions

• Correlation vs. Causation

• Hypothesis testing (t-test basics)

• Assignment: Analyze a survey dataset in Excel

Month 2: SQL & Data Visualization (Power BI/Tableau)

Week 5: SQL Fundamentals

• Databases & SQL basics

• SELECT, WHERE, ORDER BY

• GROUP BY, HAVING

• Case Study: Customer Orders Dataset

Week 6: Intermediate SQL

• Joins (INNER, LEFT, RIGHT, FULL)

• Subqueries & Common Table Expressions (CTEs)

• Window functions (ROW_NUMBER, RANK, PARTITION BY)

• Project: Build insights on E-commerce database

Week 7: Power BI/Tableau Basics

• Importing & transforming data

• Data modeling (relationships, hierarchies)

• Visualizations (charts, maps, KPIs)

• Case Study: Sales & Profit Report

Week 8: Advanced Dashboards

• Drill-through, filters, slicers

• Bookmarks & storytelling

• Publishing dashboards to cloud

• Project: Interactive Business Dashboard

Month 3: Python for Analytics & Capstone Projects

Week 9: Python Basics for Analytics

• Python setup & Jupyter Notebook

• Variables, data types, loops, functions

• Libraries: NumPy (arrays, math ops)

• Case Study: Numerical Analysis with NumPy

Week 10: Pandas & Data Visualization

• Pandas DataFrames: cleaning & wrangling

• Handling missing values, duplicates

• Visualization with Matplotlib & Seaborn

• Assignment: Exploratory Data Analysis on Sales Dataset

Week 11: Applied Analytics Projects

• HR Analytics: Attrition Analysis (Excel + SQL)

• Finance Analytics: Budget vs. Actual Dashboard (Power BI)

• Marketing Analytics: Campaign Performance (Python + Pandas)

Week 12: Capstone + Career Prep

• Capstone Project: End-to-End Analytics Solution (SQL + Python + BI)

• Resume building with project portfolio

• Mock interview Q&A

• Certification preparation (Google/Microsoft/Tableau)