Self-directed project
Business Analytics Sprint
Data Science · September 2026
A ProoV case study · educational project, not employment
Built an end-to-end profitability investigation that framed the paradox structurally, audited the data for issues, and used SQL to isolate margin differences by category and region. Connected the analysis to a Pareto-style root-cause story, a recovery forecast, and a prioritised executive recommendation set focused on discount discipline, logistics efficiency, and input-cost mitigation.
Graded against
- Problem Framing & Hypotheses10%
- Data Analysis & SQL30%
- Root-Cause & Forecasting25%
- Dashboard & Visualization15%
- Executive Communication & Strategy20%
Passed · pass mark 60/100
What stood out6
- Built a sensible hypothesis set around raw-material inflation, discounting, and logistics rather than guessing a single cause
- Wrote the category margin query with the correct margin formula and grouped by category as required
- Used a join to connect regional margin with discount data and interpreted Asia as a margin-pressure area
- Produced a forecast and recommendation stack that ties actions back to the identified profit drivers
- Structural Problem Framing
- Leakage-Free Analytical Reasoning
The work I submitted20 tasks
12 tasks · 9.0k characters · 8 written answers · 269 words
- Hypothesis Sheet535 characters
- Data Audit100 characters
- Week1 Update689 characters
- Sql Category Profit338 characters
- Sql Region Join331 characters
- Dashboard58 characters
- Forecast281 characters
- AI Reflection426 characters
- Recommendations1.2k characters
- Stakeholder Qa1.1k characters
- Executive Summary1.3k characters
- Bosch Real Case Study2.6k characters
- Hypothesis Sheet53 words
- Data Audit4 words
- Week1 Update93 words
- Sql Category Profit26 words
- Sql Region Join28 words
- Dashboard1 word
- Forecast6 words
- AI Reflection58 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.