Data and insights

The problem

• Data sits in several systems that don't agree, and every report starts with a spreadsheet reconciliation.
• Dashboards exist, but nobody trusts them, so decisions are still made on gut feel.
• Cost-centre managers get reports they can't use, so finance answers the same questions every month.
• Supplier invoices are paid on totals, so nobody can see whether prices and volumes match the contract.
• A system change is coming, and nobody is confident the history, or the revenue, will survive it.
• Reporting depends on one analyst, and it stops when they are away.

Four ways in

Dashboards and reporting people use

• Board and committee dashboards that give a clear, timely view of financial performance.
• A finance analysis and reporting tool for every cost-centre manager, so budget holders can see and own their numbers.
• Project and operational reporting that gives managers more reliable information, faster.
• Payroll compliance dashboards that keep pay monitored once a review is done. See Industrial and compliance review.
• Built in Power BI or Qlik Sense, or in the platform you already use, with definitions everyone can read.

Revenue and billing analytics

• Medicare Benefits Schedule (MBS) billing analytics (Australia): billing analysed by specialty and item, so genuine anomalies stand out from rule changes.
• Revenue reconciliations: activity, charges, claims, funder remittances, cash and the general ledger reconciled, so variances show up as exceptions to work through rather than surprises at year end. See Health revenue assurance.
• Private practice and special-purpose fund reporting: activity, revenue and distributions analysed and reported, so the people who rely on the funds get transparent, reliable information.
• Funding claims analytics (New Zealand): Accident Compensation Corporation (ACC), General Medical Services (GMS) and immunisation activity matched against what was claimed and paid, using Nova IT's Datasimple platform. See Revenue maximisation on novaconsulting.co.nz.

Spend, invoice and procurement analytics

• Line-level invoice analysis: supplier invoice data extracted automatically, line by line, then analysed for price, volume and compliance with the contract.
• Spend dashboards that total spend per item, flag cost increases and variances, and show the best-value suppliers, built on the line-level data captured by Bill Simple. See Bill Simple on novait.co.nz.
• Group-wide analysis: where a group owns several organisations or companies, their spend and finance data are brought together and analysed as one, comparing what each pays for the same goods and services.

Data migration and system change

Nova's staff have supported organisations through system changes like these:

• Data migration and analysis for a national finance system implementation, including report building, system advice and troubleshooting through go-live.
• Selecting, designing and implementing finance and payroll systems, and training staff to use them.
• Reconciling historical data after a migration, to prove it matches the old system.
• Checking revenue after go-live, so items that quietly stop billing are found early. Read Revenue leakage after a system go-live.

How Nova works with data

1. Start with the decisionWhat the reporting must support, and who will use it, agreed first.
2. Understand the dataSource systems, definitions and quality issues mapped and documented.
3. Build the modelA data model that reconciles to source, with definitions everyone can read.
4. Build the reportsDashboards and reports that are clear to the people using them, not just the people who built them.
5. ValidateEvery number tested back to source before anyone relies on it.
6. Hand overYour team trained and the model documented, so you aren't dependent on Nova. Ongoing support is optional.

Tools

Health information is handled under the Privacy Act 1988 in Australia and the Health Information Privacy Code 2020 in New Zealand. Nova's in-house AI models can run onshore in Australia, matched to your data classification and policies.

Work Nova has done

Case studies are anonymised and published with each client's agreement.

Frequently asked questions