Accutive Data Mart

Accutive Data Mart

Accutive’s Data Mart delivers business insight and analytic capabilities from Loan Origination Systems data, by transforming loan data into a business focused Data Mart.

Accutive Data Mart

Accutive Data Mart

Delivers business insight and analytic capabilities from your LOS data, by transforming loan data into a business focused data mart consumable by standard analytics and reporting tools and your organization’s data analysts. The result is a rich and intuitive platform.

The Reporting Challenge

The Reporting Challenge

Most loan origination databases are online, transactional (OLTP) databases designed to support inserts, updates, or deletions of operational data; they are not designed to support reporting and analytics.

Flexible & Customizable

Flexible & Customizable

The data mart conforms to industry standards and best-practice data mart design methodology, and combines Accutive’s extensive domain knowledge of financial industry reporting requirements and business intelligence technology.

Capabilities

Capabilities

The Data Mart is organized around core loan subject areas offering information management for executives, managers, lenders, and analysts across front and back offices, and supports standard reports, on-demand reports, ad-hoc queries, and dashboards.

Business Focused

Business Focused

Data elements in the data model have been named so as to be self-documenting making them immediately understandable and consumable by an organization’s business staff.

Database Support

Database Support

The Accutive Loan Data Mart is database independent.

Robust Platform

Robust Platform

The Data Mart is a robust platform that supports standard reports, on-demand reports, ad-hoc queries, and dashboards for all business users that need access to operational, tactical, and strategic lending insigh.

ETL Processes

ETL Processes

ETL processes are implemented using standard database tools and components, without a requirement to license, install and configure additional software products.

Auditing

Auditing

The audit archive retention is flexible, and may be located on a separate environment as business needs or security requirements dictate.

Data Refresh

Data Refresh

The Data Mart refreshes on a periodic basis during a configurable data-loading window that can be scheduled at a time most convenient to the organization.

Performance

Performance

The Data Mart ETL processes are fine tuned to ensure the daily data loading window is as narrow as possible, providing maximum availability of the Data Mart to end users.

EDW Integration

EDW Integration

The Accutive technical team can assist with various Enterprise Data Warehouse integration scenarios, ranging from hosting the Data Mart tables within a client’s existing BI infrastructures to integrating with existing conformed dimensions.

Key Features and Benefits

*

The Reporting Challenge

Most loan origination databases are online, transactional (OLTP) databases designed to support inserts, updates, or deletions of operational data; they are not designed to support reporting and analytics.

Due to large and/or complicated queries needed to retrieve loan origination data, reports and analytics run against these databases are often very slow. Reports can take hours to run and often time out before completion. Reporting directly against these databases can be resource intensive resulting in performance degradation of the application which directly impacts your business users..

 

*

Accutive’s Loan Data Mart

Accutive’s Loan Data Mart delivers business insight and analytic capabilities from your Loan Origination Systems data, by transforming loan data into a business focused data mart consumable by standard analytics and reporting tools and your organization’s data analysts. The result is a rich and intuitive platform that isolates business users from the technical complexity of the loan origination database, while allowing rapid, in-depth reporting and analysis.

 

*

Flexible and Customizable

Accutive’s Loan Data Mart architecture conforms to industry standards and best-practice data mart design methodology, and combines Accutive’s extensive domain knowledge of financial industry reporting requirements and business intelligence technology. The data mart is modelled on a generic loan origination dimensional model designed to be easily extensible and is customizable to support any loan origination system. Conformed dimensions have been designed to provide consistent reporting across all loans subject areas.

 

*

Comprehensive Data Capabilities

The Data Mart is organized around core loan subject areas offering information management for executives, managers, lenders, and analysts across front and back offices. The Loan Data Mart is a robust platform that supports standard reports, on-demand reports, ad-hoc queries, and dashboards for all business users needing access to operational, tactical and strategic lending insight.

 

*

Business Focused

Data elements in the data model have been named so as to be self-documenting making them immediately understandable and consumable by an organization’s business staff.

 

*

Robust Platform for Reporting and Analytics

The Data Mart is a robust platform supporting standard reports, on-demand reports, ad-hoc queries, and dashboards for all business users that need access to operational, tactical, and strategic lending insight. Users can easily build their own reports, visualizations, and queries with little to no training leaving valuable IT resources to be freed up. The data mart can be used with any reporting and analytics tools giving you the flexibility to implement the solution best suited to your requirements.

 

*

Extract, Transform and Load (ETL) Processes

ETL is implemented using standard database tools and components, without a requirement to license, install, and configure additional software products. Alternatively, the ETL can be incorporated into your existing framework or ETL tool.

 

*

Database Platform

The Data Mart is database independent and can be used with Oracle, Microsoft SQLServer or other database management systems.

 

*

Audit Capability

The Data Mart can archive data required for audit purposes. The audit archive retention is flexible, and may be located on a separate environment as business needs or security requirements dictate.

 

*

Operational Aspects

The Data Mart refreshes on a periodic basis during a configurable data-loading window that can be scheduled at a time most convenient to the organization. Email alerts can be configured to provide notification to IT staff of daily loading progress, errors, completion times etc.

 

*

Performance Tuned

The ETL processes are optimized to ensure the daily data loading window is as narrow as possible, providing maximum availability of the Data Mart to end users.

 

*

EDW Integration

The Data Mart is designed and modelled using industry standard methodology. Accutive can assist with various Enterprise Data Warehouse integration scenarios, ranging from hosting the Data Mart tables within your  existing BI infrastructures to integrating with existing conformed dimensions.