Self-directed project
Business Analytics Sprint
Data Science · July 2026
A ProoV case study · educational project, not employment
Built an end-to-end profit investigation that framed hypotheses, audited the data, solved the core SQL analyses, and translated the findings into an executive storyline. The work correctly surfaced category and regional margin patterns, prioritized the main profit drivers with a Pareto lens, and packaged the case into board-level recommendations and a concise executive verdict.
Graded against
- Problem Framing & Hypotheses10%
- Data Analysis & SQL30%
- Root-Cause & Forecasting25%
- Dashboard & Visualization15%
- Executive Communication & Strategy20%
Passed · pass mark 60/100
What stood out6
- Wrote a correct category margin query using the required (revenue − cost) / revenue formula and grouped by category cleanly.
- Built the regional join query with the discount field and preserved the margin calculation logic.
- Identified the likely profit drivers in a prioritized way, with raw-material inflation, logistics, and discounting ranked by impact.
- Communicated the paradox clearly in business terms, tying revenue growth, profit decline, and margin collapse into one storyline.
- Leakage-Free Analytical Framing
- Correct SQL Aggregation and Join Logic
The work I submitted18 tasks
10 tasks · 3.5k characters · 8 written answers · 237 words
- Hypothesis Sheet612 characters
- KPI Driver Map174 characters
- Data Audit100 characters
- Week1 Update664 characters
- Sql Category Profit318 characters
- Sql Region Join331 characters
- Dashboard58 characters
- Root Causes158 characters
- Boardroom Deck636 characters
- Teach Back477 characters
- Hypothesis Sheet73 words
- KPI Driver Map1 word
- Data Audit4 words
- Week1 Update101 words
- Sql Category Profit24 words
- Sql Region Join28 words
- Dashboard1 word
- Root Causes5 words
Summarised on purpose — the submitted code and writing stay private so this page cannot be reused as an answer key. The full submission sits behind the verified certificate.