Power BI Live: KPI Tracker for Health Groups
Update metrics directly in SQL Spreads
Below is a live interactive Power BI KPI dashboard for group hospital management of bed, patient and staff weekly values. Random data was generated using a normal distribution adjusted for winter increases of patient levels, but can be created and updated with SQL Spreads for Excel.
Click the “Regions” mini bar-chart to filter the hospital grid and KPI cards. Patterns to be verified with the line charts (hover over them for hospital names and values) and metrics grid. The grid icons show KPI target icons (green ticks and red crosses) for issues – additional orange flags or similar could be added to show warning levels too, eg. approaching 85% occupancy. Drill-through by right-clicking any hospital name for a new screen with further detail and background values. KPI’s are recalculated by the Week slider which can show ranges or individual weeks (eg. last period).
Drill-through is enabled by right-clicking any hospital name, showing a new screen with further detail and background values for that selection. But most information can be quickly gained from this overview screen, so not much fiddling by management users is required and comparisons are easier.
- Update metrics directly in SQL Spreads
- Cross filtering Power BI for easy re-grouping
- KPI target icons for individual period or date ranges
- Drill-through detail and silhouette averages
Some Basic Analysis
The winter curve can be easily seen on the “Bed Occupancy” multi line chart even with the random noise. Spikes can still be seen though, especially if above the target line of 85%. Hovering mouse over (on the live one linked) reveals the sources for further investigation.
An inverse relationship can be seen on “Staff to Patients” below it, showing the 25% KPI target is breached during summer. That’s because the staffing levels remain fairly static throughout the year, as can be seen on the “Total Staff to Patients” in top right chart. This could be the basis for less permanent staff to be recruited over winter.
We love building data solutions for organisations who can make the most of their potential.
Power BI KPI Tracker for hospital group management, fully updateable with SQL Spreads Excel add-in.
