IGInsightGrow

Portfolio · Case Studies

Hours saved. Rupees recovered. Decisions unlocked.

Executive dashboards, BI automation and AI workflows — built for Indian MSMEs and startups. Every case study below is written the way founders think: problem, solution, and the business impact that mattered.

1,200+

Hours automated

₹85L+

Value unlocked (illustrative)

12

Projects delivered

4

Industries served

Illustrative projects reflect real, common challenges in each industry. Client case studies with named results are added as engagements are completed.

Retail DistributionIllustrative Project

From 5-Hour Manual Reconciliation to Real-Time Clarity

80% less reporting time · ₹4.2L recovered every month

Retail Distribution

● LIVE

Reconciled

₹1.82Cr

▲ 8.4% WoW

Anomalies

12

▼ 41% WoW

Cities live

4

All in sync

Trend · last 14 days

+24.6%

By segment

Business Problem

Daily sales reconciliation across multiple cities took hours of manual Excel work every morning. Stock and margin issues were caught a day late, and there was no visibility into which SKUs or territories were quietly leaking profit.

Solution

An automated SQL reconciliation engine pulling data from multiple city-level sales feeds, connected to a live Power BI dashboard with automated alerts for stock-outs and margin anomalies, plus a weekly automated email summary for leadership.

Tools Used

SQLPower BIDAXPython (automation & email)

Results

80%

Reduction in reporting time

₹4.2L

Potential monthly margin recovered

30%

Fewer stockouts in 3 months

24/7

Real-time visibility

This is the kind of transformation I bring to distribution businesses — real client case studies coming soon.

ManufacturingIllustrative Project

Turning Shop-Floor Data Into Same-Day Decisions

38% faster cycle time · 98% SLA adherence

Manufacturing

● LIVE

Cycle time

3.4h

▼ 38%

SLA met

98%

▲ 12 pts

Cost/unit

₹212

▼ 9%

Trend · last 14 days

+24.6%

By segment

ServicesIllustrative Project

Making Every Client Engagement Visibly Profitable

Project margin up 22% · Zero surprise write-offs

Services

● LIVE

Forecast acc.

92%

▲ 6 pts

Stockouts

3

▼ 62%

WC freed

₹22L

cumulative

Trend · last 14 days

+24.6%

By segment

E-commerceIllustrative Project

One Dashboard for Ads, Orders and True ROAS

4.8x ROAS · CAC cut by 27%

E-commerce

● LIVE

ROAS

4.8x

▲ 1.6x

CAC

₹184

▼ 27%

AOV

₹1,240

▲ 18%

Trend · last 14 days

+24.6%

By segment

2-Step Fast Track

Tell me your business type — get the right dashboard playbook first.

Takes 10 seconds. Your details pre-fill the consult so we skip the basics and go straight to where your profit is leaking.

Want results like this for your business?