Data · Beginner
SQL Analytics for Operations
Window functions, cohort views, and inventory KPIs from warehouse schemas.
Overview
Query realistic star schemas derived from anonymized operational data—focused on metrics operations teams actually track.
Features
- Complex joins without Cartesian surprises
- Window functions for rolling stock levels
- Cohort retention for subscription SKUs
- Explain plans and index trade-offs
- dbt-style layering introduction
- Dashboard handoff to BI tools
- Data quality assertions in SQL
Outcomes
- Author twelve production-style queries
- Document assumptions in a metrics dictionary
- Present one executive KPI view
Reviews
"Rolling inventory query finally clicked with the window function lab."
FAQ
Database?
PostgreSQL 15 in Docker. Syntax notes for BigQuery provided as appendix.
Excel?
Export and import covered briefly; analysis stays in SQL.
Not included?
Machine learning model training is out of scope.