Self-directed project
Business Analytics Sprint
Data Science · August 2026
A ProoV case study · educational project, not employment
Built an end-to-end profitability investigation that framed the problem with hypotheses and a KPI driver map, audited the data for issues, and wrote correct SQL to calculate category margins. The analysis connected margin erosion to pricing, input-cost, and logistics pressures, then turned those findings into a quantified recovery forecast, prioritized recommendations, and a concise boardroom narrative.
Graded against
- Problem Framing & Hypotheses10%
- Data Analysis & SQL30%
- Root-Cause & Forecasting25%
- Dashboard & Visualization15%
- Executive Communication & Strategy20%
Passed · pass mark 60/100
What stood out6
- Identified the core paradox with concrete numbers: revenue up 17% while profit fell 55%, and margin dropped from 13.4% to 5.2%.
- Built a correct category-profit SQL query using SUM(revenue), SUM(cost), and the proper margin formula.
- Produced a credible recovery scenario with named levers and quantified impact, including logistics, raw-material hedging, and discount discipline.
- Prioritized recommendations with effort/impact logic and translated the analysis into boardroom-ready headlines.
- Structured Hypothesis Formation
- Leakage-Free KPI and Data Audit Thinking
The work I submitted18 tasks
10 tasks · 4.2k characters · 8 written answers · 229 words
- Hypothesis Sheet690 characters
- KPI Driver Map174 characters
- Data Audit100 characters
- Week1 Update476 characters
- Sql Category Profit318 characters
- Dashboard58 characters
- Forecast280 characters
- Recommendations694 characters
- Boardroom Deck578 characters
- Bosch Real Case Study834 characters
- Hypothesis Sheet76 words
- KPI Driver Map1 word
- Data Audit4 words
- Week1 Update63 words
- Sql Category Profit24 words
- Dashboard1 word
- Forecast6 words
- Recommendations54 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.