Self-directed project
Business Analytics Sprint
Data Science · July 2026
A ProoV case study · educational project, not employment
Built an end-to-end profit investigation that framed hypotheses, audited the data, and answered two open-ended SQL questions with correct aggregation and join logic. The analysis isolated raw-material inflation, logistics inefficiency, and discounting as the main profit drivers, then translated those findings into a quantified recovery forecast and board-level recommendations.
Graded against
- Problem Framing & Hypotheses10%
- Data Analysis & SQL30%
- Root-Cause & Forecasting25%
- Dashboard & Visualization15%
- Executive Communication & Strategy20%
Passed · pass mark 60/100
What stood out6
- Wrote both open-ended SQL queries with correct aggregation, join logic, and margin formula
- Correctly identified the key profit drivers as raw-material inflation, logistics inefficiency, and discounting
- Built a credible recovery scenario with quantified levers and a projected margin improvement
- Used the Bosch case study and stakeholder Q&A to connect analysis to executive decision-making
- Structured Hypothesis Framing
- Leakage-Free SQL Aggregation and Join Logic
The work I submitted20 tasks
12 tasks · 4.9k characters · 8 written answers · 192 words
- Hypothesis Sheet524 characters
- KPI Driver Map174 characters
- Data Audit100 characters
- Week1 Update491 characters
- Sql Category Profit292 characters
- Sql Region Join413 characters
- Dashboard58 characters
- Root Causes158 characters
- Forecast278 characters
- Boardroom Deck809 characters
- Stakeholder Qa690 characters
- Bosch Real Case Study940 characters
- Hypothesis Sheet56 words
- KPI Driver Map1 word
- Data Audit4 words
- Week1 Update73 words
- Sql Category Profit21 words
- Sql Region Join31 words
- Dashboard1 word
- Root Causes5 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.