Certified
Self-directed project
Business Analytics Sprint
Data Science · July 2026
84/ 100
A ProoV case study · educational project, not employment
Built an end-to-end profit investigation that framed the margin paradox, audited the data, wrote correct SQL for category and regional margin analysis, and traced the decline to raw-material inflation, logistics inefficiency, and discounting. The work culminated in a prioritized recovery plan and an executive-style verdict focused on profitable growth and ROI.
Graded against
- Problem Framing & Hypotheses10%
- Data Analysis & SQL30%
- Root-Cause & Forecasting25%
- Dashboard & Visualization15%
- Executive Communication & Strategy20%
Passed · pass mark 60/100
What stood out6
- Computed category margin correctly as (revenue − cost) / revenue and grouped by category without obvious leakage or aggregation errors
- Used a proper join to bring in regional discount data and compared margins across regions
- Identified the main profit drivers in the right order: raw-material inflation, logistics inefficiency, then discounting
- Produced a prioritized recommendation set that distinguishes high-impact, lower-effort actions from longer-horizon fixes
- Leakage-Free KPI Framing
- Correct SQL Aggregation and Join Logic
The work I submitted19 tasks
11 tasks · 4.8k characters · 8 written answers · 207 words
- KPI Driver Map168 characters
- Data Audit100 characters
- Week1 Update476 characters
- Sql Category Profit303 characters
- Sql Region Join324 characters
- Root Causes158 characters
- Forecast277 characters
- Stakeholder Qa504 characters
- Recommendations1.0k characters
- Executive Summary763 characters
- Bosch Real Case Study670 characters
- KPI Driver Map1 word
- Data Audit4 words
- Week1 Update67 words
- Sql Category Profit25 words
- Sql Region Join28 words
- Root Causes5 words
- Forecast6 words
- Stakeholder Qa71 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.