Data Warehouse

Cube Building and Reporting for Consolidated Policy Data


A U.S. based Insurance company required services to develop OLAP cubes to cover a wide range of business perspectives and to develop a reporting system that provides multidimensional view of this data.

Client Challenges and Requirements

  • Exponential growth in data warehouse with some tables having 300 million plus data
  • No subject area data marts
  • Large size of the fact tables and incorrect ad hoc reporting resulted in major performance issues and impacted the database server
  • Existing reporting system based on Business Objects universe
  • High licensing cost of Business Objects

Bitwise Solution

Helped business in decision making for the reporting tool selection by performing Impact Analysis based on Cost and Resource Utilization

Developed OLAP cubes that would provide a consolidated policy data for Submissions, Premium and Loss (Claim)

Designing of OLAP Cubes for aggregating high volume data for optimal performance ad hoc reporting

Providing online user interactive reports for management for various reporting and analysis needs

Online tailor-made report creation facility using multidimensional cubes

Automated refreshing of cubes minimizing user intervention

Tools & Technologies We Used


Key Results

Established common reporting platform

Improved Analysis and decision making

Flexibility to users to tailor the reports

Improved business operations

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Ready to start a conversation?