Skip to main content
dbSyntax
Home CoursePracticeReferenceModelingInterview Prep
Start
  • SQL Practice Tracks
Skill Drills
  • SQL Core 10-Exercise Track
  • SQL foundations: three drills
  • Join fundamentals: five drills
  • GROUP BY: five drills
  • CASE WHEN: five drills
  • Date functions: six drills
  • Window functions: five drills
  • Subqueries & set operations: five drills
  • Joins and aggregation: three drills
  • Event funnels: four drills
Real-World Data Cleaning
  • Real-World Data Cleaning
  • Meet the Messy Data
  • Text & categories: five drills
  • Dates & types — five drills
  • Capstone: clean & reconcile
Timed Tracks
  • Timed Tracks Overview
  • 10-Minute Foundations Sprint
  • 20-Minute Joins and KPI Sprint
  • 30-Minute Business Case Sprint
Insurance Analytics
  • Insurance Track Overview
  • Insurance Star Schema
  • Meet the Insurance Dataset
  • Data Quality Audit
  • Insurance Graded Drills (Easy → Hard)
  • Insurance KPI Assignments
  • Loss Ratio Trends & Claims Aging
  • Insurance Case Study Capstone
E-commerce Analytics
  • eCommerce Track Overview
  • eCommerce Star Schema
  • Meet the E-commerce Dataset
  • Data Quality Audit
  • eCommerce Graded Drills (Easy → Hard)
  • eCommerce KPI Assignments
  • RFM Customer Segmentation
  • Conversion Funnel Analysis
  • eCommerce Case Study Capstone
SaaS Analytics
  • SaaS Analytics Track
  • SaaS Star Schema
  • Meet the SaaS Dataset
  • SaaS Graded Drills (Easy → Hard)
  • SaaS KPI Assignments
  • SaaS Case Study Capstone
Home / Practice / SaaS Analytics

SaaS Analytics

Learn SQL saas analytics with practical examples and guided drills on dbSyntax.

Start with SaaS Analytics Track

SaaS Analytics Track

This track is designed to feel like real SaaS analytics work, not isolated SQL snippets. You will practice: MRR and ARR reporting from an ac...

SaaS Star Schema

This track uses a simplified B2B SaaS model. New to dimensional modeling? Read Star Schema Basics first; it explains facts, dimensions, and ...

Meet the SaaS Dataset

Before computing any KPI, spend ten minutes getting a feel for the data. This page is guided exploration: nothing is graded. Run each query,...

SaaS Graded Drills (Easy → Hard)

These drills build subscription-metrics fluency in increasing difficulty. All dates are fixed: the dataset runs 2023-06 through 2024-05, and...

SaaS KPI Assignments

Assignments mirror the monthly reporting pack a SaaS finance team actually ships. Metrics focus: net revenue retention (NRR) by month gross ...

SaaS Case Study Capstone

Case brief: The board meets next week. The CEO wants two artifacts from you: a month-by-month MRR bridge for the full reporting window (2023...

dbSyntax Write and Run SQL in Your Browser
CoursePracticeReferenceModelingInterview PrepPrivacyTerms
© 2026 dbSyntax.