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 combined structural problem framing, correct SQL analysis, root-cause ranking, and a recovery forecast. The work identified raw-material inflation, logistics inefficiency, and discounting as the main profit drags, then translated those findings into a board-ready recommendation set focused on margin repair and profitable 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
- Computed category margin correctly as (revenue − cost) / revenue and ordered results by margin
- Used a join to bring in regional discount data and preserved the margin calculation logic
- Identified the three dominant profit drags as raw-material inflation, logistics inefficiency, and heavy discounting
- Produced a concise executive summary that translated analysis into a prioritized recovery plan
- Leakage-Free Profit Driver Analysis
- Correct SQL Aggregation and Join Logic
The work I submitted19 tasks
11 tasks · 9.2k characters · 8 written answers · 396 words
- Sql Category Profit336 characters
- Sql Region Join425 characters
- Dashboard58 characters
- Root Causes158 characters
- Forecast273 characters
- AI Reflection366 characters
- Recommendations1.3k characters
- Stakeholder Qa1.2k characters
- Executive Summary1.8k characters
- Bosch Real Case Study2.4k characters
- Teach Back939 characters
- Sql Category Profit26 words
- Sql Region Join34 words
- Dashboard1 word
- Root Causes5 words
- Forecast6 words
- AI Reflection42 words
- Recommendations127 words
- Stakeholder Qa155 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.