University Hospitals sought to expand its data management and analytics capabilities by leveraging the data platform and analytics services available in Microsoft Azure. A new, hybrid data warehouse would allow users to discover and analyze data faster in a self-service solution.
With their previous data warehousing and business intelligence solutions, University Hospitals experienced a variety of challenges and limitations. Issues included onboarding new data sources, the standardization of data models, and difficulties discovering and sharing datasets. Query performance did not meet user needs and real-time analytics did exist.
The previous data warehouse was comprised of multiple staging databases that contained snapshots of data retrieved from multiple source systems. In addition, a centralized data model that covered a set of core functional areas was also available. This solution failed to meet the needs of the organization for cloud-based data warehousing, historical reporting, near real-time data processing, analytics, self-service data preparation, and collaboration.
University Hospitals engaged KiZAN to migrate the data warehouse and artifacts to an Azure Modern Data Platform at an accelerated pace so that they could retire parts of the on-premises data warehouse prior to January 1, 2021.
The full end-to-end solution adheres to the best practices of Azure infrastructure, security, monitoring, and cost containment for consumption.