Streamlined Manual "Word + Excel" Reporting
Automated in Power BI:
Now Fast & Accurate
75% Reduction in Monthly Board Reporting
Shortened from 4-weeks to just 1 week!
Prioritization and Experience
Enabled more focus on patient care and safety
Established in 1906 with a single not-for-profit hospital, today Mater delivers care and compassion for the sick and needy across an extensive and growing network of 12 hospitals and health centres, as well as education programs and a world-class research institute. Continually striving for excellence, Mater’s Clinical Governance team implemented Power ON to streamline monthly reporting to management and the Board and allow for the unique ability to add commentary within Power BI – turning KPIs from “just a number” into the story of the patient.
The Clinical Governance team works with all areas of the business to ensure the highest standard of patient safety across Mater hospitals. A key element of its work involves monthly report creation for hospital management and the Board.
Reporting involved data collection across 12 hospital sites and nine regional groups, culminating in 100s of KPIs and associated comments that had to be manually updated every month. Mater used Power BI for collaborative analysis, but Power BI’s limitation of not supporting commentary forced many manual steps to achieve a final monthly report.
The initial data collection, as in many organizations, relied heavily on Excel spreadsheets. Participants then recorded figures into a central repository. Data was further aggregated and manipulated in Excel, where charts were added. The final report was built in Microsoft Word to allow for the critical KPI commentary to be added.
The Importance of Comments in Power BI
Behind the actual numbers in KPIs, lies each patient’s story. Commentary associated with each KPI provides context to management and the Board to ensure focus and that choices are made for the betterment of patients. Commentary can highlight successful initiatives to be expanded upon or draw focus to areas in need of improvements. Commentary is critical and a valuable tool in helping achieve Mater’s goal of delivering the highest standard of patient safety on a consistent basis. The monthly report creation process was time-consuming and required considerable coordination and oversight. Growing client demand and data volumes was stretching the existing manual process to the limit. Mater knew there had to be a better way and set out to find one.
10s to 100s of spreadsheets
Manual report creation in Word to support “comments”
100s of KPIs manually calculated
4-week manual data and commentary consolidation across 3 companies, 12 hospitals and 9 geographical locations
Disparate data source collation into static Word reports, with limited ability for further analysis
Researching potential solutions to the “commentary and write-back limitation” in Power BI, the Clinical Governance Team at Mater found that Power ON Visual Table Editor addressed their many requirements – and then some.
With Power BI + Power ON they built a Power BI dashboard that allowed 12 hospitals and nine reporting groups to each have individual KPIs visuals that supported collaborative input across key stakeholders. Power ON also enabled them to add current and trend commentary that automatically consolidated into a unified database table for use across operational and Board reports; with the previous month’s trend commentary available for comparison and use in the current month’s evaluation for the first time.
The initial setup was relatively straightforward, with the bonus of having Prima Consulting, a local expert, to support implementation. With additional filtering capability and column look-up functionality, the potential to expand the number of analysis and reporting processes beyond the KPI commentary was a huge plus. With minimal training, the team was able to utilise the expanded abilities to capture KPI commentary in Power BI and set their new target benchmarks. User acceptance was quick as the operational advantages were clearly evident.
With Power ON, we now have the ability to add meaningful commentary from frontline managers directly into the dashboard for real-time analysis and reporting.
Management and Board stakeholders can review KPIs, with associated commentary, to make more informed decisions and prioritise areas of focus that positively impact patient care.
Dr Christine Foley, Director of Clinical Governance
Manual error-prone data collection in spreadsheets, chart creation and subsequent formatting in Word, has been replaced with automated, accurate, collaborative, and real-time data collection unified in Power BI + Power ON.
KPIs are now calculated automatically, reducing monthly report creation by 75% (from four weeks to just one), while enabling Clinical Governance staff to add meaningful commentary directly into the dashboard for real-time management use. Management and Board stakeholders now access and review KPIs, plus associated commentary, more quickly – enabling them to make more timely and wholly informed decisions that positively impact patient care. Oversight has also been, freeing regional users’ time to allocate to higher value work with more immediate patient impact.
Finally, the Clinical Governance staff now have more time to focus on their prime goal, implementing the highest standard of patient safety across Mater hospitals.
What’s next? With the success of PowerOn with writeback in Power BI in the reporting systems of the Clinical Governance team, further opportunities to leverage the writeback capability are currently being explored in other reporting areas, like hospital blood transfusion usage.
Unified monthly report data collection in Power BI (no more shuffling spreadsheets!)
Automated and collaborative commentary collection in Power BI
Automatic KPI calculation and consolidation in Power BI
75% reduction in monthly report creation (from 4 week to just 1 week)
Real-time, interactive Dashboard in Power BI for further “what-if” analysis
The Clinical Governance team now has more time to focus on their primary goals, implementing the highest standards of patient safety across the Mater Hospitals.
Mary Jane Capp, Quality and Safety Manager
What's New at Power On
Check out the latest from our blog
The Power of Dynamic Comments in Power BI
The Why Behind the Numbers ‘Why’ is this number what it is? This question is asked a million times a day by anyone doing analysis.Read More
Full Cycle Corporate Performance Management in Power BI
[NOTE: This blog, originally posted in 2017, was updated Oct 2022 to reflect the latest enhancements and functionality supported in Power BI and Power ON.]Read More
Planning for the Recession with Power BI
As the potential for global recession looms, organizations are looking for ways to shore-up finances and operations. According to Gartner, nearly 50% of leading CFOsRead More