Requirements
With their multitude of fields, tables and column names, transactional systems are not meant to serve reporting and analysis requirements. To overcome this limitation, many companies turn to enterprise data warehouses. Created by extracting data from operational or transactional systems (like ERP systems) and loading them to a analysis- and reporting-friendly database, data warehouses are repositories of data that can be accessed in ways that enable both fast and effective management decision-making.

Solution
Following best business and technology practices, SAPIENCE™ follows a coordinated data mart approach, one that entails sequential integration of different functional areas on one single enterprise-wide definition. Coordinated data marts significantly reduce time to roll out of data warehouse, reduce cost of implementation and at the same time offer capability for enterprise wide data administration and distribution from one single location.

The data warehouse is supported with ETL tools from either SAPIENCE™ partners or built in ETL tools available in the selected target database. SAPIENCE™ extracts the most granular data from the source systems and uses it to populate the data models. Decision-makers can easily access transaction-level detail and gain a micro view of the business issues at hand. Additionally, unified dimensions help provide a unified business view across the enterprise whereas industry standard schemas helps fasten the speed of query response.