Self-directed project
Business Analytics Sprint
Data Science · October 2026
A ProoV case study · educational project, not employment
Built an end-to-end profit investigation that framed the problem with a hypothesis sheet and KPI map, validated the data, and solved the core SQL analyses using the correct margin logic. Identified the main profit drags as raw-material inflation, logistics, and discounting, then translated those findings into a credible recovery forecast and a prioritized executive recommendation set focused on discount governance, utilisation, and input-cost control.
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 a strong hypothesis sheet that anticipated input-cost inflation, discounting, mix shift, and logistics before analysis began
- Solved both open-ended SQL tasks with the correct aggregation, join, and margin formula
- Built a coherent Pareto-style root-cause ranking that matches the case narrative: raw materials, logistics, and discounting
- Turned the analysis into a board-ready recommendation set with clear sequencing and ROI awareness
- Structured Hypothesis Formation
- Leakage-Free Root-Cause Analysis
The work I submitted20 tasks
12 tasks · 8.2k characters · 8 written answers · 268 words
- KPI Driver Map174 characters
- Week1 Update584 characters
- Sql Category Profit299 characters
- Sql Region Join318 characters
- Dashboard49 characters
- Root Causes158 characters
- Forecast276 characters
- Recommendations1.5k characters
- Boardroom Deck849 characters
- Hypothesis Sheet1.9k characters
- Stakeholder Qa2.1k characters
- Data Audit100 characters
- KPI Driver Map1 word
- Week1 Update85 words
- Sql Category Profit17 words
- Sql Region Join24 words
- Dashboard1 word
- Root Causes5 words
- Forecast6 words
- Recommendations129 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.