Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

I want one dashboard that shows my business numbers in one place

Short answer

A dashboard is only as good as the numbers behind it. The work is deciding what each number means, pulling data from every tool on a schedule, cleaning it, and keeping it reconciled with the source. Agree five to ten figures and their definitions first. Screens come last.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • I log in to four tools to understand how the business is doing.
  • My monthly numbers come from copying into a spreadsheet.
  • Two people give me different totals for the same thing.
  • I only find out about a problem after the month closes.
  • I do not know which of my numbers I can trust.

Why does this happen?

  1. Data sits in separate tools

    Sales, accounting, ads, stock and support each hold a piece. None shows the whole, and each calls things by different names.

  2. Numbers have no agreed definition

    Is revenue before or after refunds, tax or discounts? Is a customer someone who ordered or someone who signed up? Without answers the dashboard shows a figure nobody trusts.

  3. Connections break quietly

    Each tool's connection can expire or hit limits. The dashboard then shows old numbers without any sign.

  4. Time and currency differ

    Tools use different time zones, calendars and rounding. Daily figures then do not match from tool to tool.

  5. The dashboard is built top down

    Starting from charts instead of questions produces a pretty page that answers nothing the owner asks.

What can I do about it today?

  1. Write down the questions you ask each weekFor example: what did I sell, who owes me money, what is running low. These decide the dashboard.
  2. Pick five to ten figuresWrite one sentence per figure saying exactly what it counts.
  3. List where each figure comes fromName the tool and the report or export you use today.
  4. Keep one checkNote one figure from the source and its value today, to test the dashboard against it.
  5. Decide who looks at it and how oftenDaily, weekly or monthly changes how fresh the data needs to be.

When should I bring someone in?

  • Data must be combined from three or more tools.
  • The figures drive pricing, hiring or loans.
  • You have tried a ready-made dashboard tool and the numbers disagree.

How do I handle it?

  1. Agree definitions in writingEach figure has a one-line definition you approve before any chart.
  2. Pull data on a schedule into one storeData from each tool goes into one database with the time of each load recorded.
  3. Reconcile against the sourceEach dashboard figure is compared with the tool it came from, and differences are explained.
  4. Show freshness on the pageThe dashboard displays when each source last loaded, so stale data is visible.
  5. Alert on failuresA failed load sends a notice to a shared address.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Do I need a data warehouse?

Not at small scale. A single database that loads from your tools is often enough. It becomes useful when data grows or sources multiply.

Can I use a ready-made tool instead?

Often yes for one or two sources. A custom build tends to pay off when sources are many or the rules are specific.

How current can the numbers be?

As current as each tool's connection allows. Some provide changes immediately, others only on a schedule.

Who maintains it?

Someone must watch the loads and fix a connection when a tool changes. Name that person at the start.

How was this page made?

I drafted this page with AI assistance. It is general guidance for business owners, not advice for your own system. Found a mistake? Tell me.

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.