Data Analysis
What you get
Drill-through per indicator: A dedicated detail page for each indicator, reached from its summary tile, with a breadcrumb-style return to where you were.
The maths in the open: The calculation method is published with the result, and documented calculation logic is a contracted deliverable rather than hidden vendor logic.
Input-variable time series: The history of every component of the formula, not only the ratio, so cause is visible alongside effect.
Drill-down across all hierarchies: Analysis by budget submission, asset class, type and sub-type, customer or income category, ward and period, with cumulative views and monthly movements.
Spatial analysis as a peer of tabular: Interactive maps with pan, radius and lasso selection, ward scorecards and parcel-level pop-ups where spatial data is in scope.
Key benefits
Traceable from raw source to indicator: Every figure can be followed back through transformation and calculation to its origin — which is what makes it defensible under audit or oversight scrutiny.
Investigation in minutes rather than weeks: No extract request, no manual reconciliation, no waiting for the next reporting cycle.
Only vetted numbers are published: Transformed data is reconciled against source and released through a structured approval workflow, with version control maintaining historical integrity.
Findings travel: Exports to Excel, Word, PowerPoint, PDF, CSV and shapefile mean the analysis moves straight into your Section 71 in-year reporting under the Municipal Finance Management Act (MFMA), your Service Delivery and Budget Implementation Plan (SDBIP) reporting and your council packs.
Additional information
Why did this number move — and can I prove it?
An official sees a figure they do not like. To find out why, they request an extract from finance, wait, reconcile it by hand against a report built on a different basis, and by the time the cause is understood the reporting period has closed. Static spreadsheets cannot be interrogated; they can only be rebuilt.
Drill-through collapses that into one click. Selecting any indicator opens a dedicated analysis page showing the calculation method, the last reported value, the year-on-year change, the indicator’s own history and — the part that matters most — the time series of every input variable in the formula. If the collection rate has fallen, you can see on the same axis whether billing rose or receipts dropped.
Filters are global and persist as you move between views, so an analyst can set a period, a service or a ward once and carry it through the whole investigation. Every finding exports to Excel, Word, PowerPoint, PDF or CSV, because the answer usually has to end up in a report to council.
Book a demo
Tell us about your project and our team will get back to you within one business day.