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 three companies, 12 hospitals and nine 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 significantly reduced time preparing reports, automated calculation of KPIs, and interactive dashboards,
Mater is experiencing a massive increase in business agility and improved collaboration across the organization.
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 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
Having all the data stored in the database has allowed the true value of the information to be realized. And, the Clinical Governance staff now have more time to focus on their prime goal, implementing the highest standard of patient safety across the Mater Hospitals.
What's New at Power On
Check out the latest from our blog
Top 5 reasons Fortune 500 Companies choose Power BI for Planning.
Collaborative Planning and Commenting in Power BI
Collaborative Planning and Commenting in Power BI: For most companies, forecasting and planning with Microsoft Power BI is a one-way street. Someone pulls together the data, creates some sort of visualization or dashboard, gets feedback (usually via email and more spreadsheet shuffling), andRead More
The 1 Thing The Pandemic Taught Us About Business Planning and Forecasting
It goes without saying that the pandemic shook the business world. With shelter-in-place orders around the globe, virtual meetings instead of physical visits, and shifting relationships between organizations and their partners, the old way of doing business is gone. But through that event, a fundamentalRead More