Blazing BI: Transpose to Expose and Rock Your BI Users!

Explore a ground-breaking implementation of a pricing data warehouse for a major insurance carrier utilizing the latest Microsoft BI tools and Hyper-V clusters. Canal Insurance was able to put detailed profitability information in the hands of the product managers and senior level decision-makers quickly and cost effectively by sweeping virtually all premium and loss data into the BI Reporting solution. Deployment was through Microsoft Excel workbooks published to Microsoft SharePoint for power users and Microsoft SQL Server Reporting Services parameterized reports for the broader business community. Canal Insurance is now able to more accurately price their products, refine their market segments, and introduce innovative products because their new BI solution includes: • Blazingly fast drill-through loss ratios by every rating variable and loss category • Analytical groupings specific to their unique business niches • Visibility into business development activities in the agency channel • Transaction level detail for trending, benchmarking and auditing • Robust, scalable BI solution which is designed to incorporate the new data sources required for product innovation