Phase 1: Advanced Statistics & Excel (Weeks 1–3)
Goal: Strengthen analytics foundations for real-world applications.
- Week 1: Advanced Descriptive & Inferential Statistics (correlation, ANOVA, chi-square).
- Week 2: Regression Models (linear, multiple regression, diagnostics).
- Week 3: Excel Advanced Functions (XLOOKUP, INDEX/MATCH, nested formulas, what-if analysis).
Phase 2: Excel Dashboards & SQL Mastery (Weeks 4–6)
Goal: Build stronger analytical workflows with Excel & SQL.
- Week 4: Pivot Tables, Charts & Advanced Excel Dashboards.
- Week 5: SQL Core Queries (joins, grouping, aggregations).
- Week 6: Advanced SQL (subqueries, CTEs, window functions, optimization).
Mini-project: Extract & analyze business data with SQL + Excel integration.
Phase 3: Business Intelligence with Power BI (Weeks 7–8)
Goal: Develop professional BI dashboards for decision-making.
- Week 7: Power BI Essentials (data import, cleaning, modeling).
- Week 8: DAX Functions, Advanced Visualizations & KPI Dashboards.
- Mini-project: Create an executive dashboard for a business case (e.g., sales performance).
Phase 4: Python for Data Analysis (Weeks 9–12)
Goal: Introduce automation and programming into analytics.
- Week 9: Python Basics (syntax, data types, loops, functions).
- Week 10: Data Wrangling with Pandas & NumPy.
- Week 11: Exploratory Data Analysis (EDA) with Matplotlib & Seaborn.
- Week 12: Automating Analysis with Python (data cleaning pipelines, reusable scripts).
- Mini-project: Analyze a dataset end-to-end using Python (e.g., customer churn analysis).
Phase 5: Storytelling & Integration (Weeks 13–14)
Goal: Communicate insights clearly and effectively.
- Week 13: Data Storytelling Principles (audience-focused insights, framing decisions).
- Week 14: PowerPoint for Analysts (designing professional business reports).
Phase 6: Capstone Project & Career Prep (Weeks 15–16)
Goal: Apply all skills in a real-world scenario.
- Week 15: Capstone Development – Integrate Excel, SQL, Power BI & Python in one workflow.
- Week 16: Capstone Presentation – Deliver findings with BI dashboards + storytelling presentation.
