Data and Analytics

Breathing Data-Driven Insights into the Blood Management Process

Introduction

A leading US Humanitarian Organization was struggling with their legacy on-premises data warehouse and analytical system. They reached out to Exavalu in order to modernize their data platform for seamless blood management.

Services Offered

Modern Data Warehouse

Challenges

They held a legacy on-premises data warehouse and analytical system on Teradata and Oracle, which required high maintenance cost. It was unscalable during high demands and had high latency for data flow.

How Exavalu Made an Impact

- Performed current state assessment and identified the underlying objects and dataflow business logic
- Designed solutions using Redshift, CData, Glue, Pyspark, Lambda in AWS environment
- Created data lake in S3 to import blood management data from multiple sources
- Developed ODS data layer in Postgres for operational reporting
- Build data warehouse in Redshift for BI and Analytics
- Used CData to sync tables between Teradata and Redshift during implementation