04 Case Study

Pricing Strategy
Optimization

Segmented the product catalog by price elasticity to understand which products could sustain price increases and which were price-sensitive. The data-driven pricing recommendations led to a 12% revenue increase without significant volume loss.

Python Excel
12%
Revenue Increase
Achieved
👤

Role

Data Analyst

🛠️

Tools

Python, Excel

📅

Timeline

4 Weeks

🎯

Outcome

12% Revenue Increase

Pricing Decisions Were Based on Gut Feel

The company's pricing strategy had evolved organically over the years — a mix of competitor matching, cost-plus margins, and "what feels right." There was no systematic understanding of how price changes affected demand for different product categories.

Leadership wanted to increase revenue but feared that raising prices would drive away customers. Without data on price sensitivity, every pricing decision was a gamble.

Elasticity-Based Price Segmentation

I built a structured analysis framework to quantify price sensitivity across the product catalog:

  • Historical Analysis: Collected 2 years of sales data including price changes, promotional periods, and volume fluctuations using Python.
  • Elasticity Modeling: Calculated price elasticity of demand for each product category, measuring how volume responded to past price changes.
  • Product Segmentation: Grouped products into three tiers — inelastic (can sustain increases), moderately elastic (requires careful adjustment), and highly elastic (price-sensitive).
  • Recommendation Engine: Built an Excel model that simulated revenue impact of various pricing scenarios, allowing leadership to compare options before committing.

35% of Products Were Significantly Underpriced

The analysis revealed that over a third of the product catalog had very low price elasticity — meaning customers would continue buying at higher prices. These products had been priced conservatively despite strong demand.

Conversely, a smaller segment of highly elastic products was being priced aggressively, causing unnecessary volume loss. The optimal strategy wasn't uniform price increases — it was targeted adjustments based on each product's sensitivity profile.

Analysis Walkthrough

A step-by-step overview of the pricing analysis methodology and results.

Video walkthrough coming soon

Key Results

Measurable outcomes from the pricing optimization initiative

💰
12%
Revenue increase achieved through targeted pricing adjustments
📦
35%
Of products identified as significantly underpriced
📊
3
Distinct pricing tiers created based on elasticity analysis
First Project

Sales Performance Analysis

Identified why regional sales varied — product mix, not market size, explained 70% of variance.

View Case Study →
Back to All Projects