Self-directed project
Business Analytics Sprint
Data Science · August 2026
A ProoV case study · educational project, not employment
Built an end-to-end profit investigation that framed hypotheses, mapped KPI drivers, and audited the data before analysis. Solved the core SQL tasks with correct aggregation and margin logic, identified the weakest-margin region and largest category, and translated the findings into a board-ready narrative with prioritized actions on logistics, discount control, and raw-material hedging.
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 margin as (revenue − cost) / revenue in both SQL tasks and ordered results by margin to surface the weakest performers
- Mapped all eight KPI drivers accurately in the KPI driver map, showing strong pre-analysis structure
- Identified Asia Pacific as the weakest-margin region and Mobility as the largest category, aligning the pivots with the business story
- Validated AI output by explicitly checking the profit formula and spotting a revenue/profit labeling error
- Structural Hypothesis Framing
- Leakage-Free SQL and Margin Analysis
The work I submitted16 tasks
8 tasks · 6.5k characters · 8 written answers · 601 words
- Hypothesis Sheet2.7k characters
- KPI Driver Map174 characters
- Sql Category Profit299 characters
- Sql Region Join431 characters
- AI Reflection256 characters
- Boardroom Deck625 characters
- Executive Summary996 characters
- Bosch Real Case Study1.1k characters
- Hypothesis Sheet175 words
- KPI Driver Map1 word
- Sql Category Profit23 words
- Sql Region Join34 words
- AI Reflection34 words
- Boardroom Deck45 words
- Executive Summary135 words
- Bosch Real Case Study154 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.