Last week, we had our Microsoft last business intelligence focused webinar of the year, “Hybrid Analytics in Healthcare: Leveraging Power BI and Office 365 to Make Smarter Business Decisions.” Heidi Rozmiarek, Assistant Director of IT Development for UnityPoint Health, spoke, along with our Microsoft BI team, on implementing an analytics platform in a hybrid environment.
First, the Perficient team covered architectural components and functions, architecture options including on premises, hybrid, cloud, and delivery considerations. Next, Steven Gregor, a technical consultant on our Microsoft BI team, reviewed Power BI and its features, including the security model and client side Data Management Gateway, and then walked through a live demo.
Last, Heidi shared how her organization is architecting a successful analytics infrastructure using Microsoft technologies. She explained how UnityPoint Health is leveraging Microsoft’s BI stack to provide simple solutions for complex questions. Heidi shared how they built the solution, collected and cleansed the data, modeled the data, and visualize and report the answer. She wrapped up by sharing her organization’s plans to move further to a hybrid on-premises/cloud solution in the next few months.
Heidi’s key takeaways are worth noting:
Power BI transforms Excel
- Power Query allows for data acquisition & cleansing
- Power Pivot enables data modeling & cube development
- Power View & Power Map fuel advanced visualization
Power BI & SSRS transform SharePoint into an analytics hub
- Sharing of Power Pivot data models
- Sharing of Power View dashboards
- SSRS running in SharePoint integrated mode allows reports to sit alongside dashboards
End user adoption is rapid
- Familiarity of Excel & SharePoint allows quick ramp up
- Analyst layer of the organization will flourish
- Build an environment that can “grow with you”
During the session, I mentioned a case study, published by Microsoft, on Heidi’s work at Meriter Health Services. It describes how Meriter deployed a self-service BI solution leveraging the Microsoft stack to extend its EHR solution. This solution enables the hospital to provide more effective patient care and save more than $1 million annually.