Roshika Gnan

Create your portfolio with ProoV
ProoV
DE Verified work portfolio

ProoV Portfolio

Roshika Gnan

Not decided · Self-taught

View the ProoV leaderboard

Projects

Certified

Self-directed project

Business Analytics Sprint

Data Science · July 2026

78/ 100

A ProoV case study · educational project, not employment

Built a clear end-to-end profit-paradox analysis: framed the margin collapse with a hypothesis sheet and KPI driver map, audited the data for issues, and translated the findings into a concise executive narrative. The work connects the profit decline to raw-material inflation, logistics inefficiency, and discounting, then prioritises actions by impact and governance risk.

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 core paradox with concrete numbers: revenue up 17% while operating profit fell 55%, and tracked the margin collapse from 13.4% to 5.2%.
  • Built a complete KPI driver map with all 8 placements correct, showing strong understanding of price, cost, and volume levers.
  • Produced a coherent Pareto-style root-cause ranking that prioritised raw-material inflation, then logistics inefficiency, then discounting.
  • Communicated the business story clearly in the stakeholder Q&A and executive summary, explicitly tying growth in Asia to margin erosion and recommending ROI-aware actions.
  • Structured Hypothesis Framing
  • KPI Driver Mapping
The work I submitted20 tasks

12 tasks · 8.4k characters · 8 written answers · 406 words

  • Hypothesis Sheet1.3k characters
  • KPI Driver Map174 characters
  • Data Audit100 characters
  • Week1 Update1.2k characters
  • Sql Category Profit296 characters
  • Sql Region Join376 characters
  • Root Causes158 characters
  • Forecast280 characters
  • Recommendations1.0k characters
  • Stakeholder Qa964 characters
  • Executive Summary1.1k characters
  • Bosch Real Case Study1.5k characters
  • Hypothesis Sheet160 words
  • KPI Driver Map1 word
  • Data Audit4 words
  • Week1 Update164 words
  • Sql Category Profit26 words
  • Sql Region Join40 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.

Verified certificateTamper-proof · issued by ProoV
1Project completed
1Verified certificate
78Average score
Create your portfolio with ProoV