Accutive 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
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
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
The Accutive 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
The Accutive 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
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
The Accutive Loan Data Mart is database independent.
Robust Platform
The Accutive 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 insight.
ETL Processes
ETL processes are implemented using standard database tools and components, without a requirement to license, install and configure additional software products.
Auditing
The audit archive retention is flexible, and may be located on a separate environment as business needs or security requirements dictate.
Data Refresh
The Accutive 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
The Accutive Data Mart ETL processes are fine tuned to ensure the daily data loading window is as narrow as possible, providing maximum availability of the Accutive Data Mart to end users.
EDW Integration
The Accutive technical team can assist with various Enterprise Data Warehouse integration scenarios, ranging from hosting the Accutive 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.
The Loan Data Mart
Accutive Technologies’ 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 Technologies’ 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 modeled 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 Accutive 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 Accutive 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 Accutive Data Mart is database independent and can be used with Oracle, Microsoft SQLServer, or other database management systems.
Audit Capability
The Accutive 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 Accutive 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 Accutive Data Mart to end users.
EDW Integration
The Accutive Data Mart is designed and modelled using industry standard methodology. Accutive can assist with various Enterprise Data Warehouse integration scenarios, ranging from hosting the Accutive Data Mart tables within your existing BI infrastructures to integrating with existing conformed dimensions.