How Is a Dashboard Built — Simple or Comprehensive?
How to build a business dashboard has two extremes: “show everything” and “no need at all”. Both are wrong — a dashboard is necessary, but it must be small enough to be looked at. 📊
Short answer: one page, three numbers, one direction arrow. A dashboard nobody looks at is worse than a table nobody keeps — because it creates the illusion that measurement is happening.
Below: the two-layer structure, the rules of the main page, the second page, tool choice and why dashboards get abandoned. 🗂️
Why two layers?
How to build a business dashboard is answered with two pages.
Main page: decision
Three numbers, this month, last month, direction. Nothing else. This page gets read in ten minutes a week and answers one question: did the direction change? If not, close it. 📋
Second page: diagnosis
The supporting numbers looked at for the “why” when a direction changes: enquiries by channel, conversion by page, job value by service. Opened only when a direction changes, not every week. 🔬
Why separate pages?
Because fourteen numbers on the same screen make the three invisible. The eye goes to the brightest chart, not the most important number.
What are the rules of the main page?
Five rules, none flexible.
Five rules
1) No more than three numbers. 2) Next to each, last month and a single arrow. 3) No charts; a number and an arrow suffice. 4) Filled on the first of the month, unchanged during the week. 5) The number’s source is written: panel or accounting. The fifth rule closes the “which is right” argument from the start — hierarchy in the why-numbers-don’t-match article. 📏
How is the second page built?
A drawer opened when needed.
The breakdown logic
Each main number breaks down along one dimension on the second page: enquiries by channel, conversion by page, cost by service. When a direction changes, the relevant breakdown gets looked at and the cause usually shows in a single row. 🧩
Which tool?
The answer is simpler than assumed.
A spreadsheet is enough
In most small and mid-sized businesses the main page is a spreadsheet: three rows, four columns. Automated dashboard tools can be valuable for the second page — but the main page should be filled by hand. Whoever fills it by hand has looked at the number; a number that flows automatically passes unseen. ✍️
Why do dashboards get abandoned?
The reasons repeat.
Three abandonment causes
One: too many numbers — unread, postponed, forgotten. Two: no looking rhythm — “we’ll look when we have time” is never looking. Three: the number isn’t tied to a decision — if there’s nothing to do after looking, nobody looks. All three are design faults, not discipline faults. All questions on the data and measurement consulting page. 🚫
📝 Field Notes
A business had a forty-indicator automated dashboard that hadn’t been opened in six months. We put a three-row table on top, by hand. In the first week the owner said “is it really this simple”. In the third week one number’s arrow turned down, the second page was opened, the cause was in one channel, the budget moved the same day. Forty indicators said nothing for six months; three numbers produced a decision in three weeks. 📊
📖 Quick Glossary
Main page: the decision page holding three numbers and direction arrows. Breakdown: splitting a number by channel, page or service. Threshold: the movement limit within which the arrow counts as flat. Direction arrow: whether the number is up, down or flat against last month.
⚡ Quick Summary
One page, three numbers, one direction arrow. 📊 Two layers: main page decision, second page diagnosis. Five rules, not flexible. A spreadsheet is enough; the main page is filled by hand. Abandonment causes: too many numbers, no rhythm, not tied to a decision.
🎯 Next Step
Let’s build your main page together: three rows, four columns, one session: the quote page. Scope on the consulting page. 🗂️
Frequently Asked Questions
Sık Sorulan Sorular
Up, down or flat — and flat is tied to a threshold: movement within five percent is flat. A dashboard reacting to every small wobble makes you decide on noise. The threshold is written down. ↔️
Enough to find the cause, no more. The second page is also one page; if a third page has started opening, the dashboard isn’t comprehensive, it’s about to be abandoned. 📄
After three months kept by hand. By then it’s clear which number is actually used, and only that gets automated. Automation from the start also automates the number nobody will use. The setup order sits in the starting article. ⚙️
Not on the main page; charts please the eye but don’t decide. On the second page, one line chart to see the trend is enough. The main page is read, the second page examined.
Each team member gets the single number that belongs to their own work: closing rate for the salesperson, cost for the ad manager. Giving everyone all three numbers dilutes ownership. One number, one owner.
The main page monthly; the weekly look tracks the direction of the monthly number. A number updated weekly makes you react to noise. In small volumes even monthly can be narrow; a two-month average is healthier.
Source: Looker Studio — help center