ACA’s data warehousing services feature a combination of technical expertise and industry experience to ensure that clients can make meaningful use of the large volumes of data they accumulate. ACA’s comprehensive Medicaid behavioral health data warehouse brings together information from disparate sources into a SQL Server relational database structure that is optimized for reporting. ETL (extract, transform and load) processes include automated data validation to ensure the accuracy and integrity of the underlying information.
In addition to the relational database, the ACA reporting data warehouse incorporates an Online Analytical Processing (OLAP) database utilizing Microsoft® SQL Server Analysis services to pre-aggregate data for rapid ad hoc analysis. The OLAP database features a wealth of measures and dimensions to allow users to quickly identify and explore trends and anomalies in their program data.