QROCKETLAB
โ† Back to MissionsPrice Elasticity: Maximizing revenue without losing customers

P-006

Price Elasticity: Maximizing revenue without losing customers

A comprehensive commercial diagnostic parsing BigBasketโ€™s multi-category product catalog. This project engineers an automated data pipeline to audit price distributions, evaluate discount elasticity, correlate consumer...

Pillar: propulsion ยท Status: published

Economic Gravity

Balancing promotional markdowns against margin health is a fundamental price elasticity challenge. Reckless, untargeted discounting degrades brand equity and creates a race to the bottom, whereas data-validated pricing models capture maximum consumer surplus. This mission serves the Propulsion pillar by providing the analytical foundation necessary to accelerate volume growth and maximize top-line revenue without triggering margin bleeding.

Flight Plan

  • โ†’Ingest and structure a raw e-commerce catalog consisting of 27
  • โ†’555 unique product records.
  • โ†’Build a data-preprocessing pipeline to handle missing entries and engineer a distinct "Discount Percentage" metric.
  • โ†’Execute univariate and bivariate exploratory data analysis (EDA) to map price spreads and customer rating behavior.
  • โ†’Analyze cross-category performance to isolate anomalies where high markdowns fail to yield organic velocity.
  • โ†’Construct a clean
  • โ†’modular project architecture for reproducible script execution.
  • โ†’Synthesize data trends into targeted inventory procurement and discount optimization frameworks.

Standard Equipment

  • โ†’Python 3
  • โ†’Pandas & NumPy (Data Processing & Feature Engineering)
  • โ†’Matplotlib & Seaborn (Statistical Data Visualization)
  • โ†’Power BI (Interactive Executive Dashboarding)

Analysis

Core Project Architecture


bigbasket-data-analysis/

โ”œโ”€โ”€ data/           # Processed and engineered data targets

โ”‚   โ””โ”€โ”€ bigbasket_cleaned.csv

โ”œโ”€โ”€ scripts/        # Modular Python infrastructure for data jobs

โ”‚   โ”œโ”€โ”€ data_preprocessing.py

โ”‚   โ””โ”€โ”€ eda_analysis.py

โ”œโ”€โ”€ docs/           # Analytical artifacts

visualization exports

and dashboards

โ””โ”€โ”€ README.md


Catalog Diagnostics & Data Trends

1. Pricing and Rating Distributions

A deep dive into inventory pricing reveals a heavy concentration targeting budget-conscious consumers

balanced by exceptionally stable satisfaction scores.

| Metric Evaluated | Empirical Findings | Strategic Business Insight |

| --- | --- | --- |

| Price Distribution | Most products are priced **under โ‚น1

000**. Sale values are heavily right-skewed. | The core inventory successfully anchors the mass-market demographic. However

clear whitespace exists for premium product-line extensions. |

| Average Rating | Overall platform rating sits at 3.99/5.0

with a dense concentration at 4.0+ or higher. | Products consistently hit quality benchmarks

establishing a strong trust baseline crucial for driving recurring customer retention. |

2. Discount Strategy vs. Category Performance

Analyzing allocation metrics reveals a massive disparity in how discounts are deployed across different business categories.

| Product Category | Total Stock Count | Average Applied Discount | Operational & Strategic Note |

| --- | --- | --- | --- |

| Beauty & Hygiene | 7

867 units (Largest) | Moderate | This represents the platform's flagship volume footprint; priorities must center on strict inventory velocity and rotation. |

| **Kitchen

Garden & Pets** | Scaled Segment | 22.2% (Highest Platform Markdown) | Critical Friction Point: Deep cuts indicate aggressive clearance maneuvers or heavy competitive pricing pressure. |


Business Applications & Strategic Rollout

1. Elasticity-Based Markdown Planning

BigBasket must transition away from sweeping categorical discounts. Markdowns should be surgically concentrated on high-rating

high-margin items to stimulate demand volumes without destroying brand equity or sacrificing net profitability.

2. Category Procurement Corrections

Launch an internal operational audit of the *Kitchen

Garden & Pets* segment. The business must identify if the 22.2% markdown rate stems from over-purchasing or supply chain inefficiencies

then realign procurement volumes to prevent margin erosion.

3. Price-Point Anchoring

Leverage the sale price distribution model to engineer highly competitive pricing tiers for fast-moving consumer goods (FMCG) sitting below the **โ‚น1

000 threshold**

capturing price-sensitive customer segments.

4. High-Value Inventory Prioritization

Dynamically cross-reference velocity rates with user ratings. Ensure that products maintaining a 4.0+ score are prioritized in fulfillment centers to mitigate out-of-stock financial penalties on high-reputation lines.