Real-World Data Mysteries

Each project simulates real business scenarios with production-ready code patterns

Education

Education Analytics

Intermediate

Analyze school performance, Ofsted ratings, Progress 8, disadvantaged pupil gaps, and attendance metrics. Build accountability dashboards for school improvement.

  • Progress 8 & Attainment 8 metrics
  • Ofsted performance analysis
  • Persistent absence tracking
  • Disadvantaged pupil gaps
Fintech

Fintech Analytics

Advanced

Build a payment platform analytics pipeline with Faster Payments, BACS, CHAPS, and card networks. Revenue, FCA compliance, and FinCrime detection (AML, fraud, sanctions).

  • Payment rails (FPS, BACS, CHAPS)
  • Revenue analytics
  • FinCrime & AML detection
  • FCA compliance dashboards
Retail

Café Chain Analytics

Intermediate

Analyze coffee shop sales, product performance, and store metrics. Build comprehensive retail analytics with inventory, sales trends, and customer insights.

  • Store performance metrics
  • Product mix analysis
  • Sales forecasting
  • Inventory optimization
Energy

Energy Smart: IoT Analytics

Intermediate

Process smart meter readings and optimize energy consumption. Build IoT data pipelines with real-time monitoring and predictive analytics for energy management.

  • Smart meter data processing
  • Energy consumption analytics
  • Rate plan optimization
  • Usage forecasting

Your Learning Journey

Progressive difficulty to build your expertise step by step

1

Foundation Projects

Start with Hello dbt to understand core concepts, then progress to basic transformations.

2

Business Analytics

Apply your skills to real business scenarios like payment processing and retail analytics.

3

Advanced Techniques

Master complex patterns including incremental models, macros, and performance optimization.

Ready to Build Real Data Models?

Start with our beginner-friendly projects and work your way up

Data Model Lineage

×