Case Studies
Learn SQL case studies with practical examples and guided drills on dbSyntax.
Start with Case Study PromptsCase Study Prompts
Use these prompts to simulate senior analytics interviews. Rules: state assumptions explicitly define success metrics include one risk and m...
Case Study: Ecommerce KPI Regression
Case: A stakeholder claims average order value (AOV) regressed in April: "the dashboard shows it down versus March." Your task: verify or re...
Case Study: Insurance Loss Ratio
Case: Build reporting for written premium, earned premium, and incurred claims by product and month. This case tests grain control and denom...
Case Study: SaaS Retention Analysis
Case: The board saw net revenue retention (NRR) dip below 100% twice in the last twelve months and wants to know what happened. You have one...