Data Platform Implementation and Maintenance for a Leading Rehabilitation Hospital

Share Via

Summary

Sagence built a data platform that enabled a hospital to centralize their key data assets in one shareable location. Reports and dashboards were then created using the data sourced from this new system. This platform allowed the hospital to use their data assets more effectively and efficiently, as they develop future applications, reports and dashboards and move away from local spreadsheets. Sagence continues to operate and maintain the data platform for the client.

Challenge

The client is a national leader in physical medicine and rehabilitation for over 30 consecutive years. They implemented the first-ever “translational” hospital where clinicians, scientists, innovators, technologists and patients are located in the same space, enabling enhanced communication leading to improved patient care. Many of these stakeholders were still generating reports and dashboards in spreadsheets, and they did not have a centralized location where they could find and share data. Data was kept in silos throughout various systems across the hospital.

Solution

We held multiple requirements gathering sessions to understand the client’s data sources and how the data will be used within reports and dashboards. From these sessions, we categorized their data into different domains and designed data marts for each of these domains. Then, we created the data warehouse and its data marts on AWS (Amazon Web Services). We also created ETL (Extract, Transform, Load) jobs that refreshed the data marts with the latest data on a daily basis.

Once the data platform (data warehouse, data marts, ETL jobs) were implemented, we designed and created dashboards for end users using data sourced from the platform, which is now a centralized location for sharing the hospital’s key data assets.

Sagence has continued to maintain their data platform since its implementation – responsibilities include monitoring infrastructure and ETL jobs, performing data quality checks, addressing end-user questions and fixing ad-hoc issues.

Results

The data platform provided a new capability from which reports, dashboards and applications could be built. This platform saved thousands of hours from not having to manually gather data and generate daily, weekly and monthly reports and dashboards. Additionally, the dashboards we created provided an improved way for users to visualize the data and drill-down into areas to enhance their understanding of key aspects of the hospital’s operations.