Start with the question, not the chart
A good dashboard answers specific questions: how much did we sell this week? Which orders are late? Which item is about to run out? If you do not know what decision a number leads to, leave it off. Five clear cards are more useful than twenty charts nobody looks at.
Reports worth starting with
- Total sales or orders by day, week and month.
- The overdue list: what has not been delivered or paid yet.
- Best and weakest: items, branches or employees.
- This period compared with the one before it.
- Alerts: low stock or an approaching date.
The steps
- 1Make date and category columns consistent
A report by month or branch fails when the same branch is spelled two ways.
- 2Choose the display
A big number for a total, a line for a trend over time, bars to compare items.
- 3Add filters
Period, branch and employee are usually enough.
- 4Decide who sees what
The owner sees profit; an employee sees only their own numbers.