Customer overview
Recognized as a Top Performer on Key Quality Measures, a public county hospital servicing a large metropolitan area in California turned to Inviso for help automating reporting for various quality of care measures. Once implemented, Inviso then automated reports for the hospital’s finance department, saving them thousands of hours and eliminating human error.
Challenge
In response to California’s Public Hospital Redesign & Incentives in Medi-Cal Program (PRIME) and Quality Incentive Program (QIP) initiatives, a large public hospital needed to automate the production of dozens of reports that were being compiled manually. The hospital had daily and weekly Excel reports that were created by a team of analysts, and each day, several hours were spent building the reports. There were different types of reports: payroll reports (requires security), volume reports, and labor vs budget reports.
Solution
Inviso utilized the full Power BI ecosystem to create an automated BI solution:
- Power BI datasets get, transform, and clean the data model. Metrics are created based on business logic.
- Power BI interactive reports provide data insights and analytics.
- Power BI paginated reports for ready to print/export to PDF reporting on volume reports.
- Row Level security ensures users have access to the appropriate data.
- Power BI subscriptions deliver reports directly to a user’s inbox.
Inviso also provided hands-on analyst training sessions and production support to help make sure the hospital’s users were able to get up to speed quickly and to take full advantage of their new reporting system.
Results
- Inviso provided a fully automated Power BI solution with both interactive and paginated reports.
- Power BI datasets included complex business logic and row-level security.
- The solution is saving the hospital countless hours of work on a daily and weekly basis.
Insights
Project Size: $200k/year
Project Duration: 3+ years, ongoing
Technologies used
Power BI