BI dashboards that owners read: what to measure first

The owner wants to see the business on one screen. Someone builds a dashboard with 30 charts in Power BI. Everyone admires it in the review meeting. Three weeks later, the owner is back to calling the accounts manager for the sales figure, because the dashboard showed a number that did not match Tally and nobody could explain why.

Where to start

Pick five to eight measures that drive decisions you make every week. Write down exactly how each is calculated and which system it comes from. Build those first, check them against the numbers your team already trusts, and only then add more. The BI tool, whether Power BI, Zoho Analytics, Metabase or Looker Studio, matters much less than these steps.

Start with decisions, not data

For each number you want to see, ask what you will do differently when it moves. If the answer is nothing, it does not belong on the first dashboard.

For a typical Indian manufacturer or distributor, a first set often looks like this:

• Sales this month against target, by region or salesperson. You decide where to push.
• Receivables overdue beyond 60 or 90 days, by customer. You decide whom to call and whom to stop supplying.
• Cash position and next 30 days of payables. You decide what to pay and when.
• Gross margin by product group. You decide pricing and which products to promote.
• Stock value and slow moving stock. You decide what to stop buying and what to clear.
• Order book or pending dispatch. You decide on production and capacity.

A services firm would swap stock for utilisation and unbilled work. A retailer would add sales per store and sell through. The principle is the same.

Write the definitions down

Most dashboard arguments are about definitions. "Sales" might mean orders booked, invoices raised, invoices net of returns or cash collected. Each is legitimate. Each gives a different number.

For every measure, agree in one line:

1. What it means, in plain words.
2. Which system and which field it comes from.
3. What is included and excluded, such as GST, returns, inter-branch transfers or samples.
4. When it is refreshed.

Get the CFO or accounts head to sign this off. When a number looks wrong later, you check the definition first.

Get the data plumbing right

Owners stop reading dashboards when the numbers are wrong once or twice. Before building charts:

• Pull from the systems of record, such as Tally, your ERP, CRM and bank statements.
• For Tally, use a connector or scheduled export into a small database, so reports never slow down the accounts team.
• Reconcile the dashboard figures to the books for at least one closed month. If sales on the dashboard and sales in the trial balance differ, find out why before going further.
• Show the last refresh time on every page.

Design for a phone at 8 am

Many owners will check the numbers on a phone, often before reaching the office. Design for that.

• One screen, a handful of numbers, each compared with last month or the same month last year.
• Use colour only where something needs attention.
• Drill down available, but not required to understand the headline.
• A short WhatsApp or email summary each morning with the same numbers and a link, for those who will never open the app.

Choosing a tool

• Power BI suits businesses on Microsoft 365 and has a large pool of people who know it.
• Zoho Analytics fits naturally if you already use Zoho Books or Zoho CRM.
• Metabase and Apache Superset are open source options that work well with a proper database underneath.
• Looker Studio is free and quick for simple reporting, especially from Google Sheets and Google Ads.

Any of these will do the job for a first dashboard. Licence costs per user can add up for large teams, so check pricing for your actual number of viewers.

What to add later

Once the first dashboard is trusted and used, add a second layer for department heads: sales funnel for the sales head, production efficiency for the plant head, collection performance for accounts. Each with its own short list of measures and its own definitions. Resist the urge to put everything on the owner's screen. The value of a good owner's dashboard is what it leaves out.