Mapping Various Data Sources to a Single Centralized Data Warehouse

Mapping Various Data Sources to a Single Centralized Data Warehouse 2017-04-27T13:45:50+00:00

Project Description

Trinity Technology Group (TrinityTG) was brought in to assist California Correctional Health Care Services (CCHCS) with its Business Intelligence efforts and lay the architecture for a consolidated Data Warehouse for CCHCS.

Our initial analysis determined that mapping the various data sources to a single centralized Data Warehouse would be the most challenging aspect of the project.  Through this mapping effort we had to address a series of issues related to data quality, the type of data being collected and amount of data being collected.

Other challenges that had to be solved through our innovative solution included the fact that many of the CCHCS data sources had their own set of unique health code sets which required TrinityTG to develop a master code set to be used as part of the Data Warehouse design.

Read the entire case study here: CCHCS EHRS Data Warehouse Project