Overview
Go from raw data to decision-ready insights. Learn Excel for quick analysis, SQL for reliable data access, and Power BI/Tableau for storytelling dashboards. Use AI copilots for cleaning, summarizing, and speeding up workflows. Finish with two real business case dashboards you can present in interviews.
Weekly Schedule
Sat • Live class + demo
2–3 hrs — Concepts & patterns
Sun • Guided lab / critique
2 hrs — Hands-on datasets
Weekdays • Project work (async)
3–5 hrs — Dashboard progress
Syllabus (6–8 Weeks)
- W1: Excel for Analysis — formulas, pivot tables, cleaning
- W2: SQL Fundamentals — SELECT/JOIN/AGG, filters, CTEs
- W3: BI Basics — Power BI/Tableau setup, model & visuals
- W4: Data Modeling — relationships, DAX/calculations, measures
- W5: Python Basics (Optional) — pandas, cleaning, EDA
- W6: Storytelling — KPIs, layouts, drilldowns, publishing
- W7: Automation & AI — Power Query, AI copilots, summaries
- W8: Capstone & Review — business case, presentation
Fast-Track: Skip Python week and extend BI/DAX practice; add mock stakeholder review.
Benefits You’ll Get
- 2 real dashboards (portfolio-ready)
- KPI design & business storytelling
- AI-accelerated workflows (clean, summarize, visualize)
- Mentor feedback & presentation coaching
Total Course
Data Analytics — 6–8 weeks • 2 Dashboards • Interview-ready