Join us in Snowflake Booth #1670 for an engaging conversation with Prominence Advisors.
Mass General Brigham (MGB) partnered with Prominence Advisors to migrate on-premises EDW and other manual sources to Snowflake, significantly improving the performance and availability of the OCMO Quality Dashboard in Tableau. This dashboard spans four critical quality domains—Effectiveness, Equity, Experience, and Safety—and integrates data from diverse sources, including Epic Clarity, Vizient, HCAHPS, Real-Time Surveys, NDNQI, and NHSN.
By utilizing Snowflake’s databases, SQL Stored Procedures, Python libraries, and SnowSQL commands, the implementation optimized data transformation and availability. Additionally, Python notebooks facilitated the download of API data, light transformations, transferring and staging, while Tableau connected to Snowflake SQL tables to deliver actionable insights for healthcare quality improvement.
-
Michael Pandolfi
Director of Clinical Data & Analytics
Prominence Advisors -
Andrew Williams
Director of Data Science
Prominence Advisors
Join us in Snowflake Booth #1670 for an engaging conversation with Prominence Advisors.
Mass General Brigham (MGB) partnered with Prominence Advisors to migrate on-premises EDW and other manual sources to Snowflake, significantly improving the performance and availability of the OCMO Quality Dashboard in Tableau. This dashboard spans four critical quality domains—Effectiveness, Equity, Experience, and Safety—and integrates data from diverse sources, including Epic Clarity, Vizient, HCAHPS, Real-Time Surveys, NDNQI, and NHSN.
By utilizing Snowflake’s databases, SQL Stored Procedures, Python libraries, and SnowSQL commands, the implementation optimized data transformation and availability. Additionally, Python notebooks facilitated the download of API data, light transformations, transferring and staging, while Tableau connected to Snowflake SQL tables to deliver actionable insights for healthcare quality improvement.
SAVE YOUR SPOT!
Date: March 4, 2025
Time: 4:00 PM PT