SQL for Business Intelligence
Dimensional thinking for reporting: star schemas, slowly changing dimensions, KPI definitions, funnels, retention and lifetime value, data-quality checks and BI-ready datasets. The capstones build a dashboard-ready reporting dataset and a SaaS retention analysis.
1. Tracks
- 01SQL Foundations10 lessons
- 02Retrieving and Filtering Data14 lessons
- 03Aggregation and Business Reporting13 lessons
- 04Joining Tables15 lessons
- 05Subqueries and Advanced Filtering12 lessons
- 06Intermediate and Advanced Analytics14 lessons
- 07Data Cleaning and Transformation13 lessons
- 11SQL for Data Analytics and Business Intelligence11 lessons
2. Capstone projects
- Business-intelligence reporting datasetValidate a star schema, respect slowly changing dimensions and the fiscal calendar, and ship a dashboard-ready view with funnel and marketing KPIs.
- SaaS MRR, churn and retention analysisRebuild Mizan Cloud's MRR from subscription history, decompose its growth, and find out who churns, when and why.