Self-directed project
Business Analytics Sprint
Data Science · August 2026
A ProoV case study · educational project, not employment
Built an end-to-end profit-paradox analysis: framed hypotheses and a KPI driver map, audited the data for issues, wrote correct SQL to compute category and regional margins, and used pivot/root-cause analysis to isolate the main profit drains. Delivered a boardroom-ready narrative with a forecast, prioritized recommendations, and an executive verdict grounded in the numbers.
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 the category margin query with the correct formula: (revenue − cost) / revenue, grouped by category and ordered by margin.
- Joined regional discount data correctly and preserved the regional margin comparison needed to identify Asia Pacific as the weakest region.
- Built a coherent profit-bridge narrative that isolated raw-material inflation, logistics inefficiency, and discounting as the dominant drivers.
- Converted the analysis into a board-ready recommendation stack with impact estimates and prioritization.
- Leakage-Free Structural Hypothesis Building
- Correct SQL Aggregation and Join Logic
The work I submitted20 tasks
12 tasks · 6.0k characters · 8 written answers · 251 words
- Hypothesis Sheet822 characters
- KPI Driver Map171 characters
- Data Audit100 characters
- Week1 Update562 characters
- Sql Category Profit303 characters
- Sql Region Join418 characters
- Root Causes158 characters
- Forecast279 characters
- AI Reflection490 characters
- Recommendations1.1k characters
- Boardroom Deck833 characters
- Stakeholder Qa797 characters
- Hypothesis Sheet96 words
- KPI Driver Map1 word
- Data Audit4 words
- Week1 Update79 words
- Sql Category Profit24 words
- Sql Region Join36 words
- Root Causes5 words
- Forecast6 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.