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 started with structured hypotheses and a data audit, then validated the core drivers with SQL, pivot analysis, and a Pareto-style root-cause ranking. The work culminated in a boardroom-ready recommendation set and executive summary that linked discount discipline, logistics efficiency, and raw-material cost control to a credible recovery path.
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 structurally sound hypothesis set around raw materials, logistics, and discounting before analysis
- Computed category margin with the correct revenue-minus-cost logic and grouped by category
- Used a joined regional query to connect margin with discount behavior
- Translated the analysis into a prioritized boardroom narrative with clear growth-versus-profit framing
- Leakage-Free Problem Framing
- Correct SQL Aggregation and Join Logic
The work I submitted20 tasks
12 tasks · 4.8k characters · 8 written answers · 248 words
- Hypothesis Sheet890 characters
- KPI Driver Map174 characters
- Data Audit100 characters
- Week1 Update648 characters
- Sql Category Profit297 characters
- Sql Region Join367 characters
- Dashboard58 characters
- Root Causes158 characters
- Forecast274 characters
- AI Reflection205 characters
- Recommendations964 characters
- Boardroom Deck651 characters
- Hypothesis Sheet98 words
- KPI Driver Map1 word
- Data Audit4 words
- Week1 Update93 words
- Sql Category Profit19 words
- Sql Region Join27 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.