Auto Dash

From conversation to a live, AI-assisted dashboard, in days.

Built from what you say, answered in plain English by an embedded assistant, and changed on demand as your questions change. Sales, margin, trade spend, and service, on the one screen your team opens every morning.

  1. 1
    Faster turnaroundFrom the first conversation to a working sales and margin cockpit in days, not quarters.
  2. 2
    A wireframe in 2 to 3 daysLook, feel, filters and colours on sample data, before any build spend.
  3. 3
    A closed loop with AIWhat you say in the room is recorded, becomes the brief, and reaches the leadership view as it lands.
  4. 4
    An assistant built into the screenAsk in plain English about brands, channels, margin or trade spend. It reads the screen and the data underneath.
  5. 5
    No BI licence dependencyNo per seat Power BI or Tableau. Any view, embedded anywhere, with each user seeing only their slice.
  6. 6
    Safety and securityHosted on infrastructure you choose, with a signed data agreement, no training on your data, and clear protocols on our side.
← Back to the full build
Net sales (12 mo)
Rs 3523 Cr
11 brands
Volume
298 KT
tonnes shipped, full year
Gross margin
28.4% | 10.7% contribution
Rs 377 Cr contribution
Trade spend
10.2%
share of net sales
Sales vs plan
+0.1%
net sales against plan
Fill rate
95.1%
8 green · 1 amber · 2 red
Brand heatmap 11 brands · colour is health · click any tile to drill in
Commercial and supply layer

Sales vs plan, worst first

BrandSales vs planGross margin
Surya Edible Oils-3.9%12.3%
Sparkle Home Care-2.9%29.4%
Aanand Atta-1.6%19.0%
Komal Personal Care-0.9%44.0%
Namkeen Nagar-0.1%34.3%
Chai Junction+0.2%38.1%
Tashan Biscuits+3.8%33.3%
Pavitra Spices+4.0%35.9%
Zing Beverages+4.9%41.0%
Frostbite Foods+7.1%29.6%
Honeybee Naturals+7.4%38.8%
Net sales for the 12 months, against the plan for the same period.

Trade spend vs plan

BrandActualPlanGap
Komal Personal Care15.9%16.0%-0.1%
Zing Beverages15.4%15.5%-0.1%
Frostbite Foods13.9%14.0%-0.1%
Honeybee Naturals13.3%13.5%-0.2%
Sparkle Home Care13.2%13.0%+0.2%
Tashan Biscuits12.2%12.5%-0.3%
Namkeen Nagar12.0%12.0%+0.0%
Chai Junction11.1%11.0%+0.1%
Pavitra Spices9.0%9.0%+0.0%
Aanand Atta6.6%6.5%+0.1%
Surya Edible Oils4.9%5.0%-0.1%
Trade spend as a share of net sales. Gap is actual minus the planned rate.

Service and inventory

BrandFill rateInv. days
Surya Edible Oils90.7%30
Frostbite Foods91.7%65
Honeybee Naturals94.6%55
Komal Personal Care95.0%47
Pavitra Spices95.2%46
Chai Junction95.5%42
Sparkle Home Care95.8%50
Tashan Biscuits96.3%43
Namkeen Nagar97.0%44
Zing Beverages97.3%37
Aanand Atta97.6%29
Fill rate is orders served in full and on time. Below 92 percent is flagged.
Sales and margin shape

Net sales vs plan, by category

Staples
Rs 1338 Cr / plan Rs 1376 Cr
Foods
Rs 952 Cr / plan Rs 927 Cr
Home and Personal
Rs 528 Cr / plan Rs 537 Cr
Beverages
Rs 513 Cr / plan Rs 501 Cr
Frozen and Dairy
Rs 191 Cr / plan Rs 179 Cr
Blue is actual, grey is plan. Net sales, last 12 months.

Net sales by channel

Rs 3550 CrNET SALES, 12 MO
GTGeneral TradeRs 2019 Cr · 57%
MTModern TradeRs 750 Cr · 21%
QCQuick Commerce and E-commerceRs 414 Cr · 12%
INSTInstitutional and HoReCaRs 283 Cr · 8%
EXPExportsRs 84 Cr · 2%

Net sales and contribution trend

All brands, recomputed when you filter. Toggle months or quarters below.
Data health the reconciliation layer, built in
Data issues to fix
12
Brands flagged (risk)
3
Rows reconciled
8,010
Checks run
7
2 channel split below brand total1 missing submission1 service below threshold1 inventory days outlier1 margin step-down1 trade spend over plan1 payables timing1 wastage spike1 duplicate channel row1 price master stale1 draft not final
BrandExceptionPeriodSeverity
BR003Channel split below brand total2025-10-31High
BR007Channel split below brand total2025-11-30High
BR009Missing submission2024-02-29High
BR005Service below threshold2026-02-28High
BR005Inventory days outlier2026-01-31Medium
BR002Margin step-down2026-03-31Medium
Separates a data problem (fix it) from a genuine business risk (escalate it). Computed live from the five source files, exportable with the specific figures.

How this gets built

From the first conversation to a living dashboard. Click a step to see what actually happens.

  1. 1
    Discovery callWe listen and capture
  2. 2
    Instant wireframeTwo to three days
  3. 3
    Wireframe reviewThey react, we capture
  4. 4
    The full buildPhased to go live
  5. 5
    Change on demandA continuous loop, in days
Step 1 · Input

The discovery call

A working session with the people who own the numbers and the people who use the screen.

We sit with the commercial, finance, and supply teams and we listen. The recording becomes the specification. No long requirements document, the conversation is the brief.

In the room

  • Rakesh, CFO (margin has to be clean and reconciled)
  • Meera, Commercial Head (channels and sales versus plan)
  • Sundar, Supply Chain (fill rate and inventory)

What they actually said

"By the time it is all in one sheet it is the tenth working day."Meera, Commercial Head
"Net sales are growing but margin keeps slipping and nobody can say whether it is mix, input cost, or trade spend."Rakesh, CFO

What we captured

  • One morning cockpit with a red, amber, green view across every brand
  • Net sales, volume, gross margin, contribution, trade spend, all against plan
  • Fill rate and inventory, with a flag when service drops below 92 percent
  • A data health layer so the numbers can be trusted

And where the data lives

From the same conversation we map every source the numbers come from: the distributor system, the field app, the retailer portals, the e-commerce export, and how it all reconciles. That map is the data architecture.

See the data architecture →Output: the first wireframe, in 2 to 3 days
Step 2 · Output

The instant wireframe

Built in 2 to 3 working days, straight from the transcript

The transcript is the brief. We turn it into a clickable picture of the cockpit, on sample data, so you see your own asks rendered before a rupee of build is spent. That removes the loop of build, reject, rebuild that stalls reporting projects.

What the wireframe shows

  • The headline strip the CFO asked for
  • The red, amber, green brand heatmap
  • The commercial and supply layer, channel mix, and the data health tile
Step 3 · Input

The wireframe review

A screen share walkthrough, every reaction captured

We walk them through the wireframe and capture every reaction. That second transcript becomes the build list, eleven precise changes.

The change list

  • 1 Contribution shown right next to gross margin
  • 2 Heatmap tile shows sales versus plan, not just the value
  • 3 Fill rate drives the red, amber, green colour
  • 4 Trade spend versus the planned rate as its own view
  • 5 One contribution definition used everywhere
  • 6 Every brand on the heatmap clickable through to its own page
  • 7 Net sales by channel on a single tile
  • 8 Days of inventory and working capital by brand
  • 9 Data health exceptions list, exportable with the figures
  • 10 Net sales and contribution trend over the last four quarters
  • 11 Hosting and data location agreed in writing
✓ Wireframe approved, build authorised
Step 4 · Output

The full build

Phased to go live · sample data, real feeds swapped in as access clears

The change list becomes the live cockpit. The numbers are governed, every figure is a door into the detail, and you ask questions in plain English.

What landed

  • Governed numbers: one contribution definition everywhere, tied to what is on screen
  • Filter by category or region and the whole cockpit recomputes
  • A built-in data health layer
  • Cleo, an assistant that answers over the full data in plain English
  • Testing ready about a week, after data access and the source systems are confirmed
  • Sign off on real numbers
  • Go live
A brand drill down →
Step 5 · The loop

Change on demand

A continuous loop, in days

You are never done. When something needs to change, you do not file a ticket and wait a quarter. You talk, we capture it, and we apply it, in days.

For example

"Add quick commerce as its own line in the channel mix, and let fill rate drive the brand colour."A later request, live the same week

You say it, we make the change, it is live. The dashboard keeps up with the conversation.