Behind the Dashboard: How Sunnybrook Scaled Predictive Modelling and Power BI Across Complex Data Systems

Sunnybrook Health Sciences Centre has embarked on an ambitious journey to elevate its analytics maturity by building out a modern reporting infrastructure that supports both real-time decision-making and longer-term forecasting. Data staging and advanced ETL querying capabilities enable integration of data from multiple clinical and operational systems, in turn supporting advanced reporting in Power BI and the use of predictive modelling techniques. This session will review how our teams:

• Integrate millions of rows of data across multiple systems to enable real-time and retrospective analysis
• Streamline reporting using Power BI for both clinical teams and executive leadership
• Built predictive modelling capabilities to support operational and clinical planning
• Overcame the complexities of healthcare-specific data formats and reporting hierarchies