Business Intelligence

Product Details

Data Warehouse and Reporting provides a robust web-based reporting environment for OASIS data. Specifically designed to support reporting, Data Warehouse and Reporting offers the following features:

- A strategic subset of OASIS premium, claim, client, and finance data at the transaction level. Additional OASIS data can be added to the warehouse schema.
- Transaction level data can be synchronized on a nightly basis.
- A tight level of integration with OASIS. The extract, transform, load (ETL) process obtains changes to the data since the last extraction.
- Validation routines within the ETL process ensure that data stays synchronized with OASIS at all times and can notify via email if errors are found.
- Multiple OLAP cubes are provided for different levels of summarization of policy, claim, and financial data.
- A Report Wizard tool is provided that enables end user report development using drag and drop to select attributes filters, sorting, aggregation, and format.
- An advanced Report Designer tool is provided that enables a more technical user to develop more complex and nested reports.