START

—-→ Learn Excel / Google Sheets (Formulas, Pivot Tables, Charts) ——> Learn SQL (Queries, Joins, Aggregations, Window Functions) ——> Learn Python for Data (Pandas, NumPy, Matplotlib, Seaborn) ——> Learn Visualization Tools (Power BI, Tableau) ——> Learn Statistics & EDA (Descriptive Stats, Correlation, Hypothesis Testing) ——> Advanced Topics (Big Data, Cloud, ML Basics) ——> Work on Real-Time Projects (Dashboards, Case Studies, Business Insights) ——> Build Resume + GitHub + Portfolio ——> Apply to Jobs → Target ?+ LPA

Phase 1 – Foundations + Excel + SQL (Day 1–10)

Goal: Learn fundamentals of data analytics, Excel, and SQL.

Day 1–2:

Introduction to Data Analytics: What & Why

Role of a Data Analyst

Types of Analytics: Descriptive, Diagnostic, Predictive, Prescriptive

Basic Math & Statistics: Mean, Median, Mode, Variance, Standard Deviation, Correlation

Day 3–4 (Excel Basics):

Formulas: SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, INDEX, MATCH

Conditional Formatting

Cell Formatting, Data Types

Day 5–6 (Advanced Excel):

Pivot Tables & Charts: Bar, Line, Pie, Scatter

Slicers & Filters