Simple Data Visualisation for Small Business

Here's a test. Look at a table of twelve monthly sales figures and tell me which month was the worst. You'll find it, but you'll have to read every number and hold the lowest one in your head while you check the rest. Now look at a bar chart of the same figures. You see the short bar instantly, before you've consciously read anything.

That gap is the whole case for data visualisation. Your visual system processes length, position and colour in parallel, without effort. Reading numbers is serial: one at a time, in order. A good chart moves the work from the slow part of your brain to the fast part.

For a small business, that matters because nobody has time to study a report. The owner glances at numbers between a client call and a supplier meeting. If the answer isn't obvious in that glance, it's effectively not there.

Why small businesses drown in data

It's not that you have too much data. It's that it arrives from too many places, in too many formats, with nobody deciding which bits matter. The accounting package has one set of reports, the point-of-sale system another, the website analytics a third, and each one offers dozens of figures by default.

The result is predictable: reports nobody reads, decisions made on gut feel anyway, and the occasional nasty surprise that was sitting in the numbers for months. Visualisation helps, but only after you've done the step most people skip.

Step 1: pick the five numbers that matter

Before any chart, decide which handful of figures actually tell you how the business is going. For most small businesses it's something like:

• Revenue, compared with the same period last year.
• Gross margin, because revenue without margin is vanity.
• Cash position and money owed to you.
• One sales pipeline number: quotes sent, enquiries, or bookings.
• One operational number specific to your work: jobs completed, average turnaround, utilisation, stock turns.

An accounting practice might track billable hours and work in progress. A real estate agency might track listings and days on market. The point is choosing on purpose. Five numbers you look at every week beat fifty you never open.

Step 2: match the chart to the question

Most bad charts aren't ugly. They answer a different question from the one being asked. A rough guide:

• "How is this changing over time?" Line chart. Months along the bottom, the value up the side. Trends and seasonal patterns jump out.
• "Which is biggest?" Bar chart, sorted from largest to smallest. Sales by product, revenue by customer, jobs by technician.
• "How does this year compare with last year?" Two lines on the same chart, or paired bars.
• "Are we on target?" A single number with the target beside it, coloured green or red. Sometimes the best chart is no chart.
• "What makes up the whole?" A stacked bar usually works better than a pie.

About pies. Research on how people read charts, going back to work by Cleveland and McGill in the 1980s, found we judge position along a common scale much more accurately than we judge angles or areas. That's why two similar pie slices are hard to compare while two bars side by side are easy. Pies are fine for "this is about half". For anything more precise, use bars.

Step 3: strip out everything that isn't the answer

Default chart settings add a lot of decoration. Most of it gets in the way:

• Start bar charts at zero. A bar chart whose axis starts at 90 makes a 2% difference look like a 50% difference. Line charts can zoom in; bars can't, because the bar's length is the message.
• Drop the 3D effects. They distort the very lengths you're trying to compare.
• Use colour to point, not to decorate. Grey for everything, one strong colour for the thing you want people to notice: this month, the underperforming product, the line that crossed the target.
• Write the conclusion as the title. Not "Monthly revenue 2026" but "Revenue down 8% since July". People will read the title even if they ignore the chart.
• Label lines directly instead of making people match colours to a legend.

Step 4: use the tools you already own

You don't need an expensive business intelligence platform to start. In order of effort:

Excel

Still the workhorse, and better than most people use it. Format your data as a table (Ctrl + T) so charts grow automatically as rows are added. Use PivotCharts to summarise thousands of transactions by month or category in seconds. Add conditional formatting to colour cells that miss a target, and sparklines for tiny trend lines next to each row. With a Microsoft 365 Copilot licence, Copilot in Excel can suggest charts and summaries in plain English, provided your data is in a clean table.

The reports already in your systems

Accounting packages, CRMs and point-of-sale systems all have built-in dashboards. Before building anything, check whether the chart you want already exists. Often it does, three menus deep.

Power BI

When your numbers live in several systems and you want them on one screen that updates itself, Power BI is the next step. Power BI Desktop is free to download and build in. Sharing reports with colleagues needs paid licensing, and connecting several systems takes setup work, so it suits businesses that have outgrown spreadsheets rather than ones just starting out.

Step 5: build a one-page dashboard

Put your five numbers on a single page or screen: a line chart for the revenue trend, a target indicator for margin, a sorted bar chart for top customers, and so on. The test is the glance: can someone understand how the business is going in under thirty seconds?

Then make it a habit. A dashboard checked every Monday morning is a management tool. A dashboard that's checked whenever someone remembers is an expensive screensaver.

Dashboards are wonderful, and, uh... worth a moment's suspicion. Once a number is on a screen, people start managing the number rather than the thing it measures. Track "tickets closed" and watch tickets get closed whether or not the problem was fixed. Pick numbers that are hard to game, and talk about what's behind them, not just whether they went up.

The unglamorous part: clean data and safe data

A chart is only as good as the data under it. If customer names are typed three different ways, your top customer will be split into three middling ones. Agree on consistent entry (one customer list, standard categories, dates in a proper date format) and the charts mostly take care of themselves.

Dashboards also concentrate sensitive information in one place: revenue, margins, salaries, sometimes customer details. Store them in Microsoft 365 with proper permissions rather than emailing spreadsheets around, and make sure they're covered by your backups. If you're unsure where your business data actually lives, our guide to choosing cloud storage for a small business is a good place to start.

Data collection often starts with a form, too; our guide to Microsoft Forms surveys covers getting responses into Excel ready to chart.

Frequently asked questions

What is data visualisation in business?

It's presenting business numbers as charts, graphs and dashboards so patterns and problems can be seen at a glance instead of read row by row. Done well, it shows trends, comparisons and progress against targets quickly enough to support everyday decisions.

What is the best data visualisation tool for a small business?

Start with Excel, which most businesses already have: tables, PivotCharts and conditional formatting cover a lot. Use the built-in dashboards in your accounting or sales software, and move to Power BI when you need several systems combined in one self-updating report.

Which chart should I use?

Use a line chart for change over time, a sorted bar chart to compare categories, a single number against a target for performance, and a stacked bar to show parts of a whole. Avoid 3D charts, and start bar chart axes at zero.

Is Power BI free?

Power BI Desktop is free to download and use for building reports. Sharing reports and dashboards with other people in your organisation requires paid Power BI licensing.

Local IT and cyber security support across NSW

Chewing IT runs managed IT and cyber security for small and mid-sized businesses from our Wyong and Hornsby offices, covering the Central Coast, Newcastle, Lake Macquarie and Hornsby.

Got the data but not the answers? Talk to us about pulling your numbers into reports your team will actually read.