Custom Dashboard for Business: Build, Buy or Use Free Tools

A custom dashboard for business puts the few numbers you act on in one live view, so nobody spends a morning pulling them together. Most businesses already have the numbers. They are just scattered across accounting software, a point of sale, a CRM and a few spreadsheets. This guide covers when free tools are enough, when a built dashboard is worth paying for, and what each costs in South Africa today.

A custom dashboard for business starts with decisions

The trap is a beautiful screen full of numbers nobody acts on. A useful dashboard starts from the other end: which decisions do you make, and which number would change your mind? Five numbers you act on beat fifty you ignore.

What a business dashboard costs in South Africa

Approach	Price	Best for
A spreadsheet connected to your data	Nothing extra	A quick first view of a few simple numbers
Google Data Studio (formerly Looker Studio)	Free for creators and viewers; Pro US$9 per user per project a month	Google products, spreadsheets and ad accounts
Microsoft Power BI	Free account; Pro US$14 a user a month (about R228); Premium Per User US$24	Excel and Microsoft 365 businesses
Dashboards built into your tools	Included in your plan	Xero scorecards and dashboards, Shopify reports, HubSpot reporting
A dashboard built for you	From R8,000 (focused build) or R80,000 (full system) on Zaiq's published prices	Data spread across systems the free tools cannot reach

Dollar prices converted at US$1 = R16.32, before VAT. Power BI prices are per user a month, paid yearly, and Pro is included in Microsoft 365 E5. The last row is one studio's published starting price, not a market average.

Before paying for anything, check what your current software already shows. On its South African plans, Xero’s Standard tier adds customisable performance dashboards and financial health scorecards, Shopify’s plans include more than 200 real-time reports, and HubSpot’s free CRM has a reporting dashboard.

Power BI vs Looker Studio (now Data Studio)

Google has renamed Looker Studio back to Data Studio, and the old addresses redirect to it. It is free for people who create and view reports, and it connects easily to Google products, spreadsheets and many other sources through built-in and partner connectors. The paid Pro tier adds team content management and support, at US$9 per user per project a month.

Power BI suits businesses that run on Excel and Microsoft 365. There is a free account, Pro costs US$14 a user a month paid yearly (about R228 before VAT), and Pro is included in Microsoft 365 E5. If your team shares reports widely, check which licence each viewer needs before you roll it out.

KPI dashboard: what to put on it

For example, a Bloemfontein plumbing firm might need only four numbers: jobs booked for the next seven days, invoices overdue, cash in the bank and enquiries this week versus last. Each one drives a decision: book more work, chase payment, delay a purchase or push marketing. Anything that does not change what the owner does next stays off the screen.

Build or off-the-shelf?

The honest default is off-the-shelf first. Pay to build only when one of these is true:

• Your data is trapped. It lives in systems the standard tools cannot connect to, so something has to pull it out reliably.
• The logic is specific. You need live calculations, blended numbers or rules the standard tools cannot express.
• People log into it. A dashboard that customers or staff use as a product is an app, not a report, and it is built like one.

If you do need one built, get a fixed quote for a written scope. As one reference point, Zaiq’s published prices start from R8,000 for a focused build and from R80,000 for a full system.

Keep customer data safe on a dashboard

Dashboards often show customer names, spending or contact details, which makes them personal information under POPIA. Section 19 requires reasonable measures to protect it. In practice, that means giving each person access only to what they need, avoiding public share links for anything with customer details, and removing access when someone leaves.

Where dashboards go wrong

• Too many numbers. A cluttered dashboard gets ignored. Cut to what drives a decision.
• Manual updates. If someone has to refresh it by hand, it goes stale and dies. Connect the data so it updates itself.
• Pretty over useful. Decoration is not insight. The biggest number should be the most important.
• No alert. A dashboard you have to remember to check is half a tool. Add alerts for numbers that need action.

Better inputs make better dashboards: automated invoicing keeps what is owed current, and lead follow-up automation records where enquiries come from.