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
SSAS
SSRS
Key Results
Established common reporting platform
Improved Analysis and decision making
Flexibility to users to tailor the reports
Improved business operations
