Har Ghar Puja — Revenue & Inventory Dashboard

The Insight

Har Ghar Puja, a D2C puja essentials brand, struggled to understand channel performance across Blinkit and their website. Without unified analytics, inventory allocation decisions were guesswork, leading to stockouts on high-performing channels and excess on underperforming ones.

My Approach

• ▸Built unified data pipeline connecting Blinkit and website sales data
• ▸Designed comparative analytics framework for channel performance
• ▸Created inventory optimization model based on channel-specific demand patterns

What Was Built

• ▸Power BI dashboard comparing Blinkit vs Website performance
• ▸Real-time inventory tracking with channel-specific allocation recommendations
• ▸Revenue analytics with SKU-level profitability insights

The Outcome

• ✓Unified visibility across channels enabling data-driven inventory decisions
• ✓Clear framework for channel-specific marketing and inventory allocation

Reflection