Practice
Labs
Real SQLite and pandas in your browser, on Meridian's data. Each solved exercise earns 20 XP. Pick an exercise below, or open the SQL workspace or Python workspace directly.
Level 0 · The basics · SQL & Python 101
6 solved
Week 1 · The Bullseye · Nobody trusts the number
8 solved
Week 2 · The Canvas · Define it before you compute it
13 solved
- SQL
- Won value by account (JOIN + GROUP BY)core
- Won value by repcore
- conversion_rate by regioncore
- Where are we losing deals?core
- Two conversion rates, one query (CTE)core
- The funnel from the history logcore
- Stage-to-stage conversion (self-join on a CTE)advanced
- Average days in each stage (LEAD window)advanced
- Created-month cohortscore
Week 3 · Activation · The pipeline says success
6 solved
- SQL
- Uniqueness: duplicate transactionscore
- Consistency: CRM stage vs. latest historyadvanced
- Completeness: closed deals without a close datecore
- Timeliness: how stale is each pipeline?core
- Failed runs and time to recoveradvanced
- Row-count anomaly vs. trailing average (window frame)advanced
- Python
- Coming in the next pass.
Week 4 · Launch · Ship it where they already are
3 solved
- SQL
- Weekly active viewerscore
- Adoption by rolecore
- Legacy vs. new dashboard, month over month (LAG)advanced
- Python
- Coming in the next pass.
Week 5 · Proof · Conversion fell and everyone has a theory
4 solved
Week 6 · Beyond · One number, three meanings
4 solved