Intermediate
SQL for Business Analysis: Portfolio Project
Create a complete SQL portfolio project using fictional customers, orders and refunds. Resolve duplicate ingestion records, preserve grain across joins, calculate trading measures and compare monthly results with window functions. Deliver a reproducible report that distinguishes evidence from speculation.
2h 42m 9 lessons Intermediate level
Pro membership
Unlock this course and 50+ others
One membership at £4 a month opens every lesson, quiz and certificate on Skillora. Cancel anytime.
- Every paid course in the library unlocked
- Quizzes and verifiable completion certificates
- Career pathways matched to the courses
- Cancel any time — access runs to the end of your billing period
Course content
Module 1: Frame and clean the business data
Define a metric contract, audit staging duplicates and build grain-safe joins.
- Define the decision, grain and metric contract18 min
- Audit duplicates and build deterministic clean views18 min
- Join without losing customers or multiplying revenue18 min
Module 2: Build and reconcile trading measures
Calculate explicit KPIs, date-based cohorts and customer measures with traceable SQL.
- Aggregate KPIs with explicit denominators18 min
- Use dates to distinguish cohort trading from cash timing18 min
- Structure analysis with CTEs and reconciliation gates18 min
Module 3: Compare, communicate and submit
Apply windows, develop bounded findings and deliver a self-assessed reproducible project.
- Apply windows for comparisons without changing row grain18 min
- Turn query outputs into bounded business findings18 min
- Assemble and self-assess the portfolio project18 min