Phase 1: Foundations (Weeks 1–3)
Goal: Build statistical and analytical foundations.
- Week 1: Introduction to Data & Analytics + Basic Statistics (mean, median, variance, probability basics).
- Week 2: Descriptive & Inferential Statistics (correlation, hypothesis testing, confidence intervals).
- Week 3: Regression Basics + Applied Statistics Lab (mini-project: analyze a small dataset & summarize findings).
Phase 2: Excel Mastery (Weeks 4–5)
Goal: Master spreadsheets for analysis.
- Week 4: Excel Advanced Functions (VLOOKUP/XLOOKUP, IF statements, conditional formatting).
- Week 5: Pivot Tables, Charts & Dashboard Design (mini-project: sales dashboard with KPI tracking).
Phase 3: SQL & Database Management (Weeks 6–7)
Goal: Learn to query and manage business data.
- Week 6: SQL Basics (SELECT, WHERE, ORDER BY, filtering, aggregations).
- Week 7: Advanced SQL (joins, subqueries, case statements, database design concepts).
Mini-project: Query a sample business database to extract insights (e.g., customer segmentation).
Phase 4: Business Intelligence with Power BI (Weeks 8–10)
Goal: Turn raw data into powerful insights.
- Week 8: Power BI Basics (importing data, cleaning, and modeling).
- Week 9: DAX Functions & Relationships + Advanced Visualizations.
- Week 10: BI Dashboard Development (mini-project: build an interactive business dashboard).
Phase 5: Communication & Storytelling (Weeks 11–12)
Goal: Learn to present insights effectively.
- Week 11: Data Storytelling Principles (framing insights for business decisions).
- Week 12: Microsoft PowerPoint for Analysts (designing professional reports & executive summaries).
Phase 6: Integration & Capstone Project (Weeks 13–14)
Goal: Apply everything in a real-world scenario.
- Week 13: Capstone Prep – Integrate SQL, Excel, and Power BI for a case study (e.g., retail sales, customer churn, or financial performance).
- Week 14: Capstone Presentation – Deliver findings using Power BI dashboards + PowerPoint storytelling.
