Navtej Pawan

Create your portfolio with ProoV
ProoV
DE Verified work portfolio

ProoV Portfolio

Navtej Pawan

Computer Science and Information Technology · REVA University

LinkedIn
View the ProoV leaderboard

Projects

Certified

Self-directed project

Business & Sponsorships — The FC Barcelona Case

Data Science · August 2026

84/ 100

A ProoV case study · educational project, not employment

Built an end-to-end commercial sponsorship case for FC Barcelona: calculated the revenue mix, identified commercial revenue as the controllable growth lever, segmented fans by region, assembled a full €3.2M sponsorship package, and summarized campaign performance against targets. The final recommendation was data-backed and appropriately caveated, showing a practical grasp of sponsorship strategy and KPI-based decision-making.

Graded against

  • Business reasoning & decision quality35%
  • Correct use of data25%
  • Frameworks applied20%
  • Communication & structure20%

Passed · pass mark 55/100

What stood out6
  • Correctly calculated the revenue mix and identified commercial revenue as the stream the club can directly scale
  • Used the fan segmentation output to justify targeting Asia-Pacific based on size and engagement
  • Produced a balanced final memo that tied together segmentation, pricing, negotiation, and KPI results with explicit caveats
  • Leakage-Free Commercial Segmentation
  • Framework-Based Sponsorship Valuation
  • KPI Tracking and Performance Interpretation
The work I submitted18 tasks

10 tasks · 9.3k characters · Python · 8 written answers · 624 words

  • Revenue MixPython · 1.3k characters
  • Revenue Mix Compute324 characters
  • Fan SegmentationPython · 1.0k characters
  • Fan Segmentation Note473 characters
  • Package Builder505 characters
  • Negotiation Simulator487 characters
  • Inbox Responses1.1k characters
  • KPI ScorecardPython · 1.1k characters
  • Mid Season Performance Summary1.1k characters
  • Final Recommendation2.0k characters
  • Revenue Mix101 words
  • Revenue Mix Compute45 words
  • Fan Segmentation53 words
  • Fan Segmentation Note74 words
  • Package Builder44 words
  • Negotiation Simulator69 words
  • Inbox Responses155 words
  • KPI Scorecard83 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
Certified

Self-directed project

Business Analytics Sprint

Data Science · July 2026

86/ 100

A ProoV case study · educational project, not employment

Built an end-to-end profit-diagnosis analysis: framed hypotheses and KPI drivers, wrote correct SQL for category and regional margin analysis, isolated the main profit drags through a Pareto-style root-cause ranking, and translated the findings into a recovery forecast and executive recommendations. The work shows solid analytical rigor and clear business communication grounded in the case 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
  • Used the correct margin formula in both SQL tasks: (revenue - cost) / revenue
  • Correctly identified Mobility as the largest category and Asia Pacific as the weakest-margin region
  • Ranked root causes in a sensible Pareto order, led by raw-material inflation
  • Produced a forecast that translated operational levers into projected profit and margin
  • Structured Hypothesis Formation
  • Leakage-Free Business Diagnosis
The work I submitted18 tasks

10 tasks · 4.7k characters · 8 written answers · 341 words

  • Hypothesis Sheet741 characters
  • KPI Driver Map174 characters
  • Sql Category Profit272 characters
  • Sql Region Join353 characters
  • Root Causes158 characters
  • Forecast279 characters
  • Stakeholder Qa575 characters
  • Executive Summary812 characters
  • Bosch Real Case Study831 characters
  • Teach Back461 characters
  • Hypothesis Sheet95 words
  • KPI Driver Map1 word
  • Sql Category Profit17 words
  • Sql Region Join28 words
  • Root Causes5 words
  • Forecast6 words
  • Stakeholder Qa78 words
  • Executive Summary111 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
2Projects completed
2Verified certificates
85Average score
Create your portfolio with ProoV