Self-directed project
Business Analytics Sprint
Data Science · August 2026
A ProoV case study · educational project, not employment
Built a solid profit-paradox analysis end to end: answered the core SQL tasks correctly, surfaced the key regional and category margin patterns, and isolated the main profit drains through a clear Pareto-style ranking. The final executive summary tied the numbers to practical actions, showing strong business framing and concise stakeholder communication.
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 with the correct formula and grouped results by category
- Used a join to bring in regional discount data and compared regional margins
- Identified the three largest profit drags in the right order: raw-material inflation, logistics inefficiency, and discounting
- Translated the analysis into a concise executive verdict with quantified impact and prioritized actions
- Leakage-Free Business Diagnosis
- Correct SQL Aggregation and Join Logic
The work I submitted14 tasks
7 tasks · 3.5k characters · 7 written answers · 398 words
- Sql Category Profit291 characters
- Sql Region Join375 characters
- Root Causes158 characters
- Forecast277 characters
- Executive Summary940 characters
- Bosch Real Case Study947 characters
- Teach Back522 characters
- Sql Category Profit23 words
- Sql Region Join31 words
- Root Causes5 words
- Forecast6 words
- Executive Summary120 words
- Bosch Real Case Study136 words
- Teach Back77 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.