Self-directed project
Business Analytics Sprint
Data Science · August 2026
A ProoV case study · educational project, not employment
Built an end-to-end profit-paradox analysis: framed the business problem with a KPI driver map and data audit, wrote correct SQL to compare category and regional margins, and isolated the main profit drivers through a structured root-cause view. Also translated the findings into an executive narrative and recovery scenario focused on margin repair without sacrificing 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 as (revenue − cost) / revenue and used GROUP BY with ordered comparison across categories.
- Joined regional discount data to margin analysis and tied the weakest margin region to the highest discounting pattern.
- Built a clear profit-bridge narrative that prioritised raw-material inflation, logistics inefficiency, and discounting as the main causes.
- Translated the analysis into stakeholder-facing language that distinguished profitable growth from unprofitable volume.
- Structured Problem Framing
- Leakage-Free SQL Aggregation
The work I submitted19 tasks
11 tasks · 10.0k characters · 8 written answers · 356 words
- KPI Driver Map168 characters
- Data Audit100 characters
- Week1 Update825 characters
- Sql Category Profit318 characters
- Sql Region Join331 characters
- Root Causes158 characters
- Forecast278 characters
- Stakeholder Qa1.5k characters
- Executive Summary3.0k characters
- Bosch Real Case Study2.4k characters
- Teach Back940 characters
- KPI Driver Map1 word
- Data Audit4 words
- Week1 Update116 words
- Sql Category Profit24 words
- Sql Region Join28 words
- Root Causes5 words
- Forecast6 words
- Stakeholder Qa172 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.