Project Overview
Create Fertility partnered with Transparity to deliver business data centralisation, designing a cloud-based BI solution on Microsoft Azure. Using the Microsoft BI stack and Transparity’s Open ETL Framework, multiple sources were integrated into a SQL Data Warehouse with Analysis Services—showcasing our data consultancy expertise.
Power BI dashboards and Reporting Services delivered near real-time analytics, improving data accuracy and streamlining reporting so business users could access timely, actionable insights to support patient care.
The Challenge
Create Fertility needed a cloud-based data-platform that helped centralise data for use in their Business Intelligence and Reporting tools to help them provide the best possible service for their patients.
The Solution
Transparity worked with the Create Fertility IT team to help design and build a new BI Solution. This solution was built on Azure and makes full use of the Microsoft BI Stack. It uses the Transparity Open ETL Framework to load and transform data. Data was stored in a SQL Data Warehouse with Analysis Services providing data for reporting and analytics. Create Fertility use Power BI & Reporting Services providing self-service BI and delivered content to the Business.
The Outcome
An SQL Data Warehouse with multiple data sources coming from many areas of Create Fertility’s business. Analytics being delivered to business users in near real-time, providing timely actionable insights. Power BI Dashboards and Reporting Services Reports that Create Fertility’s team use to ensure the best possible service is provided to patients.
