XTIVIA proposed a solution that entails the selection and deployment of enterprise class data warehouse platform, the creation of the logical and physical data models, the integration of industry standard healthcare groupers and custom methodologies and the creation of reports, dashboards and visualization. The proposed solution will position the company towards an analytical / retail based business model in order to not only survive but to thrive through the expected 2013 healthcare reform mandates.
As a part of the pre-established phase, XTIVIA has analyzed the business problem, storage needs, processing needs and recommended Teradata Data Warehouse Appliance 2650 for hosting the Analytics Warehouse.
The ETL solution entails extracting data from existing enterprise data warehouse platform to flat files. The flat files were loaded to landing area where the data goes through basic sanity checks. Data from landing area is loaded to staging area where the data cleansing and transformations are applied before loading the data into Grouper and Enterprise Analytics Databases. Files are extracted from Grouper database and fed to grouper processing and the output coming from grouper processing is loaded into landing area where sanity checks are applied. After the data passes through sanity checks, data is finally loaded to target Enterprise Analytics database. The ETL processes are fully automated and scheduled on Linux environment to run on a monthly basis.
The solution also includes a flexible data model to allow prospective SaaS clients. The ETL process includes restart capability, and audit logs. Teradata Viewpoint is used for monitoring the database activities and alerting different events related to resource usage.
Scalable data warehouse platform. A centralized analytics platform for client and their partners (prospective SaaS tenants). Flexible and secure data model for multi-tenancy. Compatibility of data model with grouper processing leading to future cost reduction. Reduction of annual effort in sending grouper files for processing. Additional revenues to client with each tenant signing up for access. Single platform enabling sharing of best practices between partners.
Teradata® Data Warehouse appliance 2650
Teradata Load / Unload utilities
Linux shell scripting
Download the Case Study PDF here