Certified
Self-directed project
Business Analytics Sprint
Data Science · August 2026
84/ 100
A ProoV case study · educational project, not employment
Built an end-to-end profit-paradox analysis that framed the problem with hypotheses and a KPI driver map, audited the data for quality issues, and answered the regional SQL task with correct margin logic. The work then connected root-cause analysis and forecasting into a board-level narrative with prioritized levers and an executive verdict.
Graded against
- Problem Framing & Hypotheses10%
- Data Analysis & SQL30%
- Root-Cause & Forecasting25%
- Dashboard & Visualization15%
- Executive Communication & Strategy20%
Passed · pass mark 60/100
What stood out6
- Identified the key data audit issues, including a missing revenue value and a duplicate row, and flagged the specific rows.
- Used the correct margin formula in SQL: (revenue − cost) / revenue, with grouping by region and a join to bring in discount context.
- Prioritized the main profit drivers in a sensible order: raw-material inflation first, then logistics inefficiency, then discounting.
- Built a coherent forecast scenario with explicit levers and quantified projected profit and margin recovery.
- Structured Hypothesis Formation
- Leakage-Free KPI Mapping
The work I submitted16 tasks
8 tasks · 2.0k characters · 8 written answers · 159 words
- Hypothesis Sheet477 characters
- KPI Driver Map174 characters
- Data Audit100 characters
- Week1 Update475 characters
- Sql Region Join311 characters
- Dashboard58 characters
- Root Causes158 characters
- Forecast274 characters
- Hypothesis Sheet47 words
- KPI Driver Map1 word
- Data Audit4 words
- Week1 Update73 words
- Sql Region Join22 words
- Dashboard1 word
- 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.