Self-directed project
Business Analytics Sprint
Data Science · July 2026
A ProoV case study · educational project, not employment
Built a clear end-to-end profit-paradox analysis: framed the margin collapse with a hypothesis sheet and KPI driver map, audited the data for issues, and translated the findings into a concise executive narrative. The work connects the profit decline to raw-material inflation, logistics inefficiency, and discounting, then prioritises actions by impact and governance risk.
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 operating profit fell 55%, and tracked the margin collapse from 13.4% to 5.2%.
- Built a complete KPI driver map with all 8 placements correct, showing strong understanding of price, cost, and volume levers.
- Produced a coherent Pareto-style root-cause ranking that prioritised raw-material inflation, then logistics inefficiency, then discounting.
- Communicated the business story clearly in the stakeholder Q&A and executive summary, explicitly tying growth in Asia to margin erosion and recommending ROI-aware actions.
- Structured Hypothesis Framing
- KPI Driver Mapping
The work I submitted20 tasks
12 tasks · 8.4k characters · 8 written answers · 406 words
- Hypothesis Sheet1.3k characters
- KPI Driver Map174 characters
- Data Audit100 characters
- Week1 Update1.2k characters
- Sql Category Profit296 characters
- Sql Region Join376 characters
- Root Causes158 characters
- Forecast280 characters
- Recommendations1.0k characters
- Stakeholder Qa964 characters
- Executive Summary1.1k characters
- Bosch Real Case Study1.5k characters
- Hypothesis Sheet160 words
- KPI Driver Map1 word
- Data Audit4 words
- Week1 Update164 words
- Sql Category Profit26 words
- Sql Region Join40 words
- Root Causes5 words
- Forecast6 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.