Portfolio

Real businesses. Real numbers.

Every case study below is written the way founders think — problem, solution, and the business impact that mattered.

Retail Distribution · Power BI · SQL

80% faster reporting for a multi-city distributor

Business problem

Daily sales reconciliation across 4 cities took 5 hours of manual Excel work. Decisions were always a day late and stock errors were routine.

Solution

Automated SQL reconciliation engine plus a live Power BI dashboard with alerts for stock and margin anomalies.

Tools

SQLPower BIPythonExcel

80%

Reporting time saved

₹4.2L

Recovered per month

4 hrs

Daily hours freed

What we learned

“Reconciliation isn't a data problem — it's a decision-speed problem. Solving it changed how the owner ran mornings.”

Retail Chain · Power BI · AI Forecasting

Business problem

A 7-store retail chain lost sales every weekend due to stockouts of fast-movers and had cash blocked in dead stock.

Solution

Built a demand forecast in Python using 3 years of POS data. Piped into a Power BI reorder dashboard reviewed weekly.

Tools

PythonPower BIExcel

-62%

Stockouts

+18%

Weekend sales

₹22L

Working capital freed

What we learned

“AI doesn't need to be complex. A good forecast on clean data beats a fancy model on messy data — every time.”

Your project could be next

Book a free strategy call and I'll show you what's possible with the data you already have.