"Find the story inside the numbers — and make sure people who need to act on it actually understand it."
Every company runs on data. Most of it sits in spreadsheets and dashboards that nobody fully understands. Data analysts make sense of it — cleaning, querying, visualizing, and turning it into recommendations that drive decisions. This program puts you inside a real analytics team working on a real business dataset. You won't be doing demo exercises — you'll be building something a real stakeholder could actually use.
✓ Join the team, review the raw dataset, understand the business questions
✓ Own your assigned data cleaning module — handle nulls, duplicates, inconsistencies
✓ Write SQL queries for your module — extract, aggregate, join and filter data
✓ Run exploratory analysis — find trends, outliers and correlations
✓ Build your section of the team dashboard in Power BI or Tableau
✓ Calculate and track the KPIs assigned to your module
✓ Write your section of the final insight report — findings, recommendations
✓ Present to the team — mentor reviews, signs off, dashboard goes to portfolio
✓ Data analysis fundamentals and the analyst workflow
✓ Advanced Excel — formulas, pivot tables, charts
✓ SQL from scratch — queries, joins, aggregations
✓ Data cleaning — nulls, duplicates, inconsistencies
✓ Exploratory data analysis — trends, outliers, correlations
✓ Business metrics and KPIs — what to measure and why
✓ Data visualization principles — the right chart for the right question
✓ Interactive dashboards in Power BI and Tableau
✓ Python for analysis — Pandas, NumPy, Matplotlib
✓ Report writing for non-technical stakeholders
The dataset is intentionally raw and messy. The business questions are ambiguous. Your teammates depend on your module being accurate. That dependency, that real-world messiness, that final presentation to a mentor — that's the experience that makes the difference on a resume.