Track
📈 Data Analyst & Analytics Interview
Everything a data-analyst loop tests: writing correct SQL under pressure (joins, aggregation, window functions, CTEs), star schemas and dbt, statistics and A/B testing, defining and diagnosing product metrics, structuring open-ended business cases, communicating with dashboards, and wrangling data in pandas. Built to make you fluent, not just familiar.
Readiness0%
Lessons0/16
Cards mastered0/27
Focused study120 min
Roadmap
7 modules1
SQL
2
Modeling
3
Stats
4
Metrics
5
Case
6
Viz & BI
7
pandas
Modules
clear 60% to unlock the next🗄MODULE 01
SQL for Analysts
Joins, aggregation, window functions, CTEs and the query patterns interviews live on.
0%
🧱MODULE 02 · 🔒
Data Modeling & the Modern Stack
Star schemas, facts & dimensions, dbt tests and the semantic layer — the analytics-engineering round.
🔒 clear more of the previous module
🎲MODULE 03 · 🔒
Statistics & Experimentation
Descriptive stats, distributions, hypothesis testing, and A/B tests done right.
🔒 clear more of the previous module
🧭MODULE 04 · 🔒
Product & Business Metrics
Defining metrics, funnels, retention, and diagnosing 'why did X drop.'
🔒 clear more of the previous module
🧩MODULE 05 · 🔒
The Analytics Case Interview
A repeatable structure for open-ended business and data cases.
🔒 clear more of the previous module
📊MODULE 06 · 🔒
Data Visualization & BI
Chart choice, dashboard design, and storytelling with Tableau / Power BI.
🔒 clear more of the previous module
🐍MODULE 07 · 🔒
Python / pandas for Analysis
Clean, group, and join real data — the analyst's second language.
🔒 clear more of the previous module