Har Ghar Puja - Revenue & Inventory Dashboard

The Situation

A live analytics engagement with Har Ghar Puja, a D2C puja essentials brand - no unified view across their two channels, Blinkit and their own website, making inventory allocation decisions largely guesswork.

What I Found

Blinkit dominated - 84% of total revenue, 4,468 orders versus the website's 500. But the website wasn't irrelevant. It surfaced a different kind of buyer: higher AOV, fewer orders, more considered purchases. Five website-only SKUs - including Rakhi Box sets and Sambrani Havan Cup - were generating Rs 90,737 in revenue with no Blinkit listing. Those were straightforward expansion candidates. The inventory picture told a different story: 22 SKUs had more than 60 days of coverage on Blinkit, indicating overstock risk sitting quietly in dark stores. Without a unified view, neither finding was visible - the brand was optimising each channel in isolation and missing decisions that only appeared when both were in the same frame.

What I Built

A Power BI dashboard with three views: channel performance comparison, SKU-level profitability across both channels, and inventory ageing with DIO by product. The so-what was built in - the assortment opportunity table directly flagged the five Website-to-Blinkit listing candidates with their revenue and average order value. The inventory ageing view flagged the 22 overstock SKUs with coverage beyond 60 days. The output wasn't a dashboard to monitor - it was a decision surface.

Reflection