Incorta Analytics

Business Driver

Need better-consolidated reporting from 7 different data
Replacement of the Oracle BI reporting platform, which had poor user self-service
Ability for users to understand the lineage of a specific table and column in a Business Schema
Business-friendly column descriptions for users
Data Lineage and Adoption Report

Selection Process

The company evaluated many consulting companies but selected KPI Partners because of KPI's expertise in practically all BI Reporting tools, In addition, KPI proposed a team with 100% offshore team resources to minimize cost and risk for the customer.

What KPI Delivered

Incorta Analytics on AWS
Consolidated reporting for global spend analysis
Global inventory analysis
Global sales analysis
A System Defined Schema (SDS) with aliases for all the Physical schema tables created by KPI. A BV is then created on top of this for Users for their reporting needs
A script developed by KPI to update the labels with Business-friendly names for all BPCS tables (close to 6000+ columns, which makes manual changes difficult)
Reports build by KPI on Incorta metadata and used them as data dictionary references, ex. Business Schema Details Report, Search Tables report, Usage reports, etc.
Delivery via a 100% offshore team, 70% cost savings to the client

Incorta Architecture

Incorta Implementation in Numbers

Business Benefits for the client using Incorta solution

Incorta has become a global reporting tool to access data across multiple sources reports
Faster and accurate decision making using consolidated data from multiple data sources
Implementing Incorta solution saved thousands of dollars for the client in licensing and maintenance costs of data warehouses by replacing 10+ ETL and reporting tools
Loads maintenance has become very easy and fast
Incorta self-service capability has given an advantage to users to develop reports on their own instead of waiting for the development team
Very fast load time and report speed

Customer Quote

KPI has been working with our Data Analytics team for the past four years in the development, administration, and architecture of our Oracle Analytics Cloud and Incorta products. KPI's knowledge and attention to detail have aided in keeping our analytics team on track during the recent recession and through a major restructure. KPI's quality of work is outstanding.

On more than one occasion KPI has delivered solutions to complex obstacles that even our vendors have been unable to resolve. We can always trust that KPI will not only implement but augment best practices as their knowledge, not only of the product but of the underlying technologies as well, continues to evolve.

Leveraging KPI's offshore team has enabled a near 24-hour delivery cycle for our analytics team, while also providing working hour support for our companies in the eastern hemisphere.