Avdhesh Johri — Portfolio

Projects

Certified

Self-directed project

Business Analytics Sprint

Data Science · July 2026

72/ 100

A ProoV case study · educational project, not employment

Built a structured profitability investigation end to end: framed testable hypotheses, mapped KPI drivers correctly, and quantified the margin collapse behind the revenue/profit paradox. The work then translated analysis into action with a prioritised recovery plan, stakeholder-ready messaging, and explicit validation of AI-generated conclusions against source logic.

Graded against

Problem Framing & Hypotheses10%
Data Analysis & SQL30%
Root-Cause & Forecasting25%
Dashboard & Visualization15%
Executive Communication & Strategy20%

Passed · pass mark 60/100

What stood out6

Framed three plausible causes up front and tied each to a testable business signal.
Mapped all eight KPI drivers correctly, showing clear separation of price, cost, and unit levers.
Identified the profit paradox with concrete numbers: revenue +17% while profit fell 55% and margin dropped from 13.4% to 5.2%.
Prioritised actions in a business-aware way, focusing first on logistics, raw-material costs, and discount governance.
Structural Hypothesis Framing
KPI Driver Mapping

The work I submitted19 tasks

11 tasks · 5.3k characters · 8 written answers · 397 words

Hypothesis Sheet949 characters
KPI Driver Map174 characters
Week1 Update482 characters
Sql Category Profit310 characters
Sql Region Join359 characters
Dashboard47 characters
AI Reflection370 characters
Recommendations1.0k characters
Stakeholder Qa548 characters
Bosch Real Case Study701 characters
Teach Back358 characters
Hypothesis Sheet113 words
KPI Driver Map1 word
Week1 Update61 words
Sql Category Profit32 words
Sql Region Join41 words
Dashboard1 word
AI Reflection51 words
Recommendations97 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 & Sponsorships — The FC Barcelona Case

Data Science · July 2026

88/ 100

A ProoV case study · educational project, not employment

Built a data-backed sponsorship case study for FC Barcelona: calculated revenue mix, segmented fans by region, matched sponsor objectives to the right commercial strategy, and evaluated campaign KPIs against target. Delivered a clear renewal recommendation for ElectraX that balanced strong awareness and traffic results against a specific content-reach shortfall, showing practical commercial judgment and honest reporting.

Graded against

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

Passed · pass mark 55/100

What stood out6

Correctly identified commercial revenue as the stream the club can directly scale
Computed the revenue mix accurately and translated it into a clear share-of-total view
Flagged content reach as the true laggard KPI while still reporting the stronger metrics honestly
Recommended a value-based renewal for ElectraX while explicitly tying the decision to measured outcomes and caveats
Leakage-Free Commercial Analysis
Honest KPI Evaluation

The work I submitted16 tasks

8 tasks · 9.0k characters · Python · 8 written answers · 791 words

Revenue MixPython · 1.3k characters
Revenue Mix Compute340 characters
Fan SegmentationPython · 1.0k characters
Negotiation Simulator486 characters
Inbox Responses1.4k characters
KPI ScorecardPython · 1.1k characters
Mid Season Performance Summary1.1k characters
Final Recommendation2.3k characters
Revenue Mix101 words
Revenue Mix Compute46 words
Fan Segmentation53 words
Negotiation Simulator64 words
Inbox Responses160 words
KPI Scorecard83 words
Mid Season Performance Summary132 words
Final Recommendation152 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

Introduction to Tokenized Real-World Assets

Product · July 2026

84/ 100

A ProoV case study · educational project, not employment

Built a clear beginner-friendly explanation of tokenized real-world assets and made a sensible first product recommendation: a tokenized Treasury fund. The submission shows the candidate can explain the token as a claim on assets held by a custodian, distinguish yield-bearing Treasury exposure from a bare stablecoin, and identify redemption risk in plain language.

Graded against

Product choice & reasoning40%
Grasp of the basics35%
Risk awareness25%

Passed · pass mark 55/100

What stood out6

Chose a tokenized Treasury fund as the sensible first product and explained the choice in everyday language
Described the token as a claim on real Treasury assets held and managed by a fund, not as the asset itself
Named redemption delay/restriction as a real risk and connected it to the product’s exit mechanics
Leakage-Free Concept Mapping
Plain-Language Financial Explanation
Risk-Aware Product Selection

The work I submitted12 tasks

6 tasks · 2.3k characters · 6 written answers · 231 words

Coat Check94 characters
Tokenization Demo344 characters
Product Sort349 characters
Depeg Sim330 characters
Risk Match347 characters
First Recommendation838 characters
Coat Check1 word
Tokenization Demo32 words
Product Sort17 words
Depeg Sim29 words
Risk Match24 words
First Recommendation128 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