Data Warehouse

While an ODS is designed for relatively simple queries on small amounts of data a data warehouse is used for complex queries on large amounts of data. At Data Centric, we implement Data Warehouses that integrates data from many sources (including ODS) for reporting and analyzing current and historical data such as trending reports for annual and quarterly reports. We start with an analysis of what data exists and how it can be collected and managed so that it can be used efficiently by users. Using industry standard practices, we ensure that metadata, data quality, and governance processes are in place to ensure that the warehouse meets it purposes.