Community Care Benchmarking

image38

Service Summary

The KPI Insight Community Care Performance Benchmarking has been developed after seeing a need by organisations to be able to compare and contrast their operations and services to those of other organisations facing the same challenges within the industry.  Not only is financial performance benchmarked, but also efficiencies, outcomes, well-being, cost-per-hour and demand throughput for staff and clients to assist organisations to achieve financial sustainability and best care quality.

KPI Insight Output

Anytime, anywhere access to a suite of interactive and dynamic Microsoft Power BI dashboards comparing your business to the industry average collated from other Community Care service providers across Australia.


With multiple benchmarked KPI measures and slicers, including:

  • staff productivity
  • staff turnover
  • visits per day
  • hospitalisation rates
  • missed visit rates by month
  • day of week
  • hour per day
  • by funding (CHSP, HCP, NDIS, DVA)
  • program (home help, personal care, respite, etc.)
  • staff job class
  • staff status

There are hundreds of permutations available.


Data refresh is every two months, with refreshed dashboards providing responsive and insightful service.

Your Input

KPI Insight will work with you to create your automated de-identified (no names, titles, locations) data collection and file transfer.  A standard data schema/template will be provided.  The scheduled files are automatically uploaded to your provided secure Microsoft OneDrive folder thereafter.  No further time or maintenance is required. 

Register your interest in joining Benchmarking

Community Care Benchmarking

How much do poor KPI efficiencies cost you p.a. and how much do good KPI efficiencies save you p.a., benchmarked against the Community Care industry.


Let KPI Insight show you your organisation's benchmarked KPIs and help you discover more savings.

Business Intelligence

image39

Service Summary

Unite your disparate database silos into one ‘single source of truth’ database bringing all levels of the business an understanding, accountability and control into their own business performance stories.  Anywhere, anytime interactive and dynamic dashboards are then designed to provide more answers to more questions, but requiring less clicks.  Constructed to unite the business using one language of evidence-based data therein initiating culture change with clearer communication to better decision-making options. 

KPI Insight Output

Anytime, anywhere access to a suite of interactive and dynamic Microsoft Power BI (or other) dashboards, drillable by business ‘areas of responsibility’ from Board to individual to what, where, how and when.  A view to hundreds of key performance indicator (KPI) permutations and a view to the few primary KPIs underpinning your business performance.


KPIs including:

  • staff productivity
  • staff turnover
  • visits per day
  • durations per visit
  • scheduled visit punctuality
  • staff per customer ratios
  • overtime usage
  • hospitalisation rates
  • contractor usage
  • missed visit rates by month/day of week
  • hour per day by funding program
  • location
  • team
  • job class
  • job status
  • from Board to individual


The data refreshes every night, dashboards are instantly as up-to-date as the last refresh, providing the business clarity and transparency into each chapter of the Business Performance Story.

Your Input

Remote Desktop Connection to a Beta (test) PC/server.  All builds on your server, securely behind your firewall.  Feedback and wish lists are encouraged.  No further input required.

Workforce Planning Model (WPM)

image40

Service Summary

Using past data and scheduled data to proactively match the appropriate staff member to a customer at the right place and time.  The WPM will provide schedulers, days/weeks in advance, a clear understanding of customer demand levels, staff rostered on, the over/under supply gaps, appropriate staff availability, casual numbers at the ready and predicts future staff numbers required for recruiting purposes.

KPI Insight Output

Anytime, anywhere access to a suite of interactive and dynamic Microsoft Power BI (or other) drillable dashboards .


Dashboards display:

  • customer demand
  • staff supply and availability
  • location
  • shift
  • team
  • round by upcoming day of week
  • hour per day by funding
  • program
  • job class
  • and more!


Includes predictions of staff supply numbers required three, six and twelve months in advance to support recruitment plans.  Incorporates some accompanying BI KPIs to ensure the available staff member is the right staff member for that customer and the business.


Data refreshes every night and dashboards are as up-to-date as the last refresh providing the business clarity and transparency into the gaps between demand and supply.

Your Input

Remote Desktop Connection to a Beta (test) PC/server.  All builds on your server, securely behind your firewall.  Feedback and wish lists are encouraged.  No further input required.  

Predictive Analytics

image41

Service Summary

Offset costly risk burdens or seize growth opportunities using your data to formulate a criterion to predict what, who, when and where.  Predict, for example, staff workers compensation injuries, in patient readmission frequent flyers, customer exits, student attendance, staff resignations, sales quotas and so on.  KPI Insight will unite your database silos, collate, correlate and formulate a predictive criterion.  The criteria then enable a business intervention strategy to offset/seize.  Both new data and intervention data are refreshed back into the predictive model producing a better criterion and cost/benefit ‘return on investment’ (ROI) of each intervention strategy.  Actual predictive savings/growth increases over time.

KPI Insight Output

Anytime, anywhere access to a suite of interactive and dynamic Microsoft Power BI (or other) dashboards drillable by business ‘areas of responsibility’ displaying a weighted level of opportunity/risks.


Each dashboard provides transparency into areas with greater proportions of ‘very high’ opportunity/risk, drillable down to individuals with ‘very high, high, medium and low’ opportunity/risk.  Predictive criterion self-updates with new data from nightly refreshes.  Fine tune the ‘right’ intervention strategy with an accompanying intervention ROI dashboard.

Your Input

Remote Desktop Connection to a Beta (test) PC/server.  All builds on your server, securely behind your firewall.  Feedback and wish lists are encouraged. No further input required.

Ad-Hoc Analytics

image42

Service Summary

The answers you seek are in your data.  Mining your data will provide answers to questions not yet realised.  Realised answers identify the gaps in current data.  Gaps that can best inform your future system architectures.


“All truths are easy to understand once they are discovered; the point is to discover them.”

Galileo Galilei

KPI Insight Output

From interactive and dynamic Microsoft Power BI (or other) dashboards to flat reports, KPI Insight will transform your data into a consumable story tailored to your business to support decision making with evidence, not anecdotal hunches.

Your Input

A starting question, a desire to know why and after that, it's just data accessibility.