Self-directed project
Business Analytics Sprint
Data Science · July 2026
A ProoV case study · educational project, not employment
Built an end-to-end profitability investigation that framed hypotheses, audited the data, wrote the core SQL analyses, and traced the margin collapse to raw-material inflation, logistics inefficiency, and discounting pressure. Delivered an executive-ready recommendation set and board narrative that prioritized high-impact, low-effort actions to restore margins while preserving growth.
Graded against
- Problem Framing & Hypotheses10%
- Data Analysis & SQL30%
- Root-Cause & Forecasting25%
- Dashboard & Visualization15%
- Executive Communication & Strategy20%
Passed · pass mark 60/100
What stood out6
- Correctly computed category margin from revenue and cost and ordered categories by margin
- Identified the key root causes as raw-material inflation, logistics inefficiency, and discounting, then carried that story through to the forecast and recommendations
- Produced a boardroom deck narrative that cleanly links the profit paradox, causes, forecast, and action plan
- Validated AI output explicitly by describing how to check SQL logic, calculations, and assumptions before trusting results
- Structured Hypothesis Formation
- Leakage-Free Business Diagnosis
The work I submitted20 tasks
12 tasks · 5.5k characters · 8 written answers · 252 words
- Hypothesis Sheet961 characters
- KPI Driver Map174 characters
- Data Audit100 characters
- Sql Category Profit294 characters
- Sql Region Join346 characters
- Root Causes158 characters
- Forecast278 characters
- Recommendations916 characters
- Stakeholder Qa504 characters
- AI Reflection506 characters
- Boardroom Deck805 characters
- Week1 Update487 characters
- Hypothesis Sheet107 words
- KPI Driver Map1 word
- Data Audit4 words
- Sql Category Profit23 words
- Sql Region Join26 words
- Root Causes5 words
- Forecast6 words
- Recommendations80 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.