How to build an MD dashboard for a ₹50 Cr business — what to track, and what to ignore.

Most MD dashboards we inherit look the same: 40 charts, 3 pivot tables, a traffic-light scorecard, and a WhatsApp message from the CFO saying 'ignore last month's receivables, the data is off.' The problem isn't the data. It's the design philosophy — someone tried to put everything in front of the MD so they would 'have visibility'. The result is that nothing gets acted on.

The principle: an MD dashboard is a decision surface, not a report.

Reports look backward. Dashboards should tell you what to do today. Every metric on your dashboard should pass this test: if this number moves 10% in either direction, does it change what I do this week? If the answer is no, remove it.

The 6 numbers that belong on every ₹50 Cr MD dashboard

What to ignore (that most dashboards include)

• Website traffic — your marketing team's job, not yours
• Employee headcount by department — HR metric, not MD metric
• Individual invoice details — that's for your accounts team
• Social media engagement — remove it immediately
• Any chart that hasn't been looked at in the last 2 weeks

The 3-tier structure that works

Structure your dashboard in three tiers. Tier 1 is the '60-second scan' — 4–6 headline numbers visible above the fold with no scrolling. Red/amber/green status only. Tier 2 is the 'drill-down layer' — click into any Tier 1 number and see the breakdown by division, product, or team. Tier 3 is the 'anomaly report' — a daily email at 7:30 AM that flags anything that moved more than 15% from the prior period.

How to connect the data sources

For a ₹50 Cr business, your data typically lives in 3–5 places: Tally or Zoho Books (financials), your ERP or Excel (operations), your CRM or pipeline tracker (sales), your bank portal (cash), and WhatsApp or email threads (escalations). The goal is to pull these into a single read layer — Power BI, Google Looker Studio, or a custom Next.js dashboard — with automated daily refreshes.

The implementation sequence

1. 01
   Identify your 6 headline metrics (use the list above as a starting point)
2. 02
   Find which system each metric lives in today
3. 03
   Build API connectors or scheduled exports for each source
4. 04
   Create the Tier 1 view first — 6 KPI cards, nothing else
5. 05
   Spend 2 weeks using it daily before adding anything
6. 06
   Add Tier 2 drill-downs only for the metric you look at most