Data Analytics Professional Track (SQL, Power BI & Tableau)
Become a job-ready data analyst end to end: query and shape data with SQL, model and visualise it in Power BI with DAX, and build executive dashboards and stories in Tableau. Every module mirrors a real analyst workflow — from a messy source table to a decision-ready dashboard a stakeholder actually uses.
What You'll Learn
What's Included
Interactive learning path with AI-generated lessons read aloud by your personal tutor
Step-by-step lab instructions with AI guidance — run in your own IDE or sandbox.
AI interviewer asks tailored questions, gives real-time feedback and a score report
MCQ questions (theory, practical, code) to test your knowledge and earn a badge
Compete head-to-head against AI on real production problems — judged on correctness, performance, scalability, code quality, and edge cases
Course Syllabus
Module 1: SQL for Data Analysts
- •Relational model, tables, keys & the analyst's mental model
- •SELECT, WHERE, ORDER BY, LIMIT on real datasets
- •Aggregations with GROUP BY and HAVING
- •INNER / LEFT / RIGHT / FULL joins across fact and dimension tables
- •Subqueries, CTEs and readable multi-step queries
Module 2: Advanced SQL & Data Prep
- •Window functions: ROW_NUMBER, RANK, LAG/LEAD, running totals
- •Date/time functions and cohort bucketing
- •CASE logic, pivoting and conditional aggregation
- •Cleaning: NULL handling, deduplication, type casting
- •Building an analysis-ready table from raw source data
Module 3: Power BI & Data Modelling
- •Power Query (M): connect, transform, and clean sources
- •Star schema: fact vs dimension tables and relationships
- •DAX fundamentals: calculated columns vs measures
- •Core DAX: CALCULATE, FILTER, time-intelligence (YTD, MoM)
- •Interactive reports, slicers, drill-through and bookmarks
Module 4: Tableau & Visual Analytics
- •Connecting data, dimensions vs measures, and marks
- •Calculated fields, parameters and sets
- •Level of Detail (LOD) expressions: FIXED, INCLUDE, EXCLUDE
- •Dashboards, actions, and guided story points
- •Choosing the right chart and avoiding chart junk
Module 5: Analytics in the Real World
- •KPI and metric definition with stakeholders
- •Funnel, cohort and retention analysis
- •Row-level security and governed sharing
- •Scheduled refresh, data freshness and performance tuning
- •Capstone: end-to-end sales & revenue analytics dashboard
You're all set
Everything in this course is unlocked.
Continue Learning →