Finance and the board
Management accounts, cash flow and budget against actual, refreshed from the ledger, whether that runs on Sage, Pastel, Xero, SAP Business One or Microsoft Dynamics 365 Business Central. See what an ERP system is.
What is business intelligence? BI platforms and Power BI explained
Last reviewed: September 2026
Business intelligence (BI) is the practice of bringing an organisation's data together, checking it and turning it into reports and dashboards that people use to make decisions. A business intelligence platform, such as Microsoft Power BI, does that work. Arke Technologies designs and builds BI for South African organisations from Johannesburg.
Insights
What is business intelligence? BI platforms and Power BI explained
Last reviewed: September 2026, 16 min read
Business intelligence (BI) is the practice of bringing an organisation's data together, checking it and turning it into reports and dashboards that people use to make decisions. A business intelligence platform, such as Microsoft Power BI, does that work. Arke Technologies designs and builds BI for South African organisations from Johannesburg.
Last reviewed: September 2026, 16 min read
On this page
What is business intelligence?
Business intelligence is the set of processes and technology that turns raw records, such as invoices, meter readings, learner marks and service tickets, into information people can act on. The business intelligence definition covers three things working together: the data, drawn from the systems an organisation already runs; the model, the agreed rules for what each figure means; and the presentation, the reports, dashboards and alerts people read.
What is business intelligence in business terms? It is the difference between waiting until the tenth working day for a month-end pack stitched together from spreadsheets, and the same figures refreshed overnight, reconciled to the ledger and open in the executive meeting. BI answers "what happened, where and why": which region sold less, which debtors slipped past 90 days, which school's attendance fell.
Business intelligence is usually shortened to BI. Whatever it is called, every BI system must pass one test: do the board, the auditors and the operations manager all accept the numbers on the screen?
Where business intelligence pays off
Sales and customers
Pipeline, conversion and customer profitability drawn from the CRM and the invoicing system together. See what CRM is.
Municipalities
Revenue and collections reporting that reconciles billing, metering and property-valuation records and lists the exceptions, the basis of municipal revenue enhancement.
Departments and public entities
Performance against the annual performance plan and expenditure reporting, with the audit trail that PFMA reporting expects (municipalities report under the MFMA). See IT for the public sector.
Schools and colleges
Enrolment, attendance and results dashboards built from SA-SAMS exports and learning platforms, with learner data protected under POPIA. See IT for schools and education.
ESG and sustainability
Our ESGnet platform collects environmental, social and governance performance data and reports it in line with GRI and SASB, for ESG officers and investor-facing sustainability reporting.
What a business intelligence platform costs
The cost of a business intelligence platform has three parts: licences, the build and the upkeep. Licences are the most visible; the build, and especially the data work inside it, is usually the largest.
Licences. Power BI Desktop is free. Publishing and sharing reports needs a Power BI Pro or Premium Per User licence for each person who creates or views them, or a Fabric capacity licence, which at larger sizes lets staff view reports without individual licences. Power BI Pro is included in Microsoft 365 E5, so check what you already hold. South African subscriptions are billed in rand, and Microsoft adjusts local prices from time to time; see Microsoft 365 plans and costs.- Data work. Connecting and cleaning the sources takes most of the hours; one old database full of duplicate customers can cost more than several modern cloud systems.
- Report build. The number of reports, their complexity and the security they need, such as row-level rules by region or school.
- Platform consumption. A warehouse on Fabric, BigQuery or Azure is billed by capacity, storage or query volume.
- Upkeep. Source systems change and refreshes fail, so budget each year for monitoring, fixes and new reports.
For market context, published hourly rates for IT project work in South Africa run from about R550 to R750 ex VAT (matnet.co.za, September 2026). We quote BI work per project, in phases, after a scoping session, and support it afterwards under an SLA. For the cost of ongoing support, see managed IT services cost in South Africa.
How to choose a business intelligence platform
- Start from your stack. Microsoft 365 points to Power BI and Fabric, Google Cloud to BigQuery with Looker, and a large SAP estate to SAP's own tools.
- Count creators and viewers. Per-user licences suit a few hundred people; capacity licences suit thousands of readers.
- Check where the data must live. POPIA, your records policy and sector rules decide whether data may leave South Africa or your own servers.
- Test the connectors. Confirm the tool reads your accounting, billing, HR and line-of-business systems before you buy.
- Plan the skills and the exit. Someone must maintain the model after the build, and the warehouse and definitions should stay in forms you own, so reports can move to another tool.
If you are also choosing who builds it, our guide on how to choose an IT company in South Africa covers the questions to ask.
Why BI projects fail, and how we prevent it
- Several versions of the truth. Each department keeps its own spreadsheet and its own definition of revenue. We agree one definition per measure, record it in a data dictionary and build it once, in the model.
- Dirty source data. Duplicate customers, missing account numbers and inconsistent codes. We profile the data first, report the exceptions and agree fixes at the source with each system's owner, not in the dashboard.
- Dashboards nobody opens. Reports built before anyone asked which decision they serve. We start from the decisions and the people who make them, and retire reports that go unused.
- Personal information on display. A dashboard can expose learner, patient or customer records to the wrong audience. We apply row-level security, keep personal information out of reports that do not need it and log access, in line with POPIA compliance and the controls in our guide to what cyber security is.
- Refreshes that fail quietly. A gateway on someone's laptop, or a changed password, stops the data unnoticed. We run gateways on managed servers and set alerts for failed refreshes.
- Knowledge in one person's head. The analyst who built the model leaves. We document the model, sources and refresh schedule, and hand that documentation to you.
Related services
Related guides
- What is an ERP system? A buyer's guide
- What is CRM? Customer relationship management explained
- Microsoft 365 plans for organisations, and what they really cost to run
- How much do managed IT services cost in South Africa?
- How to choose an IT company in South Africa
- What is cyber security? A guide for South African organisations