Need an Ad Hoc Report? How Does 'Two Weeks' Sound?
Until recently, SpareBank 1 Forsikring relied on a static reporting environment to piece together knowledge about customers, products and the market situation.
“If you wanted an ad hoc report into a particular insurance scenario, you would order it and then wait about two weeks for the spreadsheet to turn up,” explains Dagfinn Roed, who is responsible for business intelligence at SpareBank 1 Forsikring. “All the reports were static, fixed and usually out of date by the time they reached the decision makers.”
This approach to reporting was not only reactive, it also was costly. Vast amounts of time and resources were devoted to aggregating data from the SAS data warehouse, preparing reports in the required format and then submitting them. Each bank in the alliance also needed a different format for the report, so the same report was sometimes re-formatted as many as 20 times.
As part of a new enterprise data warehouse strategy, the Norwegian insurance giant began the search for a visual tool to perform both analytical insurance intelligence and market analysis. The Gartner Magic Quadrant was used to identify five alternative solutions, with the shortlist quickly coming down to just two: Tableau and QlikView from QlikTech. SpareBank 1 Forsikring chose Tableau Desktop licenses after seeing its agility and ease-of-use. “With Tableau, teams from the business could create their own reports in minutes; whereas QlikView required significant intervention from IT staff,” says Eystein Kleivenes, business intelligence team leader at SpareBank 1 Forsikring. “Compared with Tableau, QlikView was also tricky to learn.”
Unearthing Hidden Intelligence
More than 70 SpareBank 1 Forsikring staff now use Tableau to visualize their data. The company has transformed its approach to insurance data, from data creation to how it is viewed and used in cross-team collaboration.
To develop and deploy an effective solution, SpareBank 1 Forsikring turned to RAV, a Norwegian Tableau technology partner. RAV provided support, implementation services and expertise on everything from structuring data sources to best practices for effective visual communication.
This agile, visual analytics solution enables SpareBank 1 Forsikring to deliver the right data to identify new cross-sell opportunities, improve customer service, manage risk, ensure compliance, and lower the cost of doing business across the entire group.
In one report, for example, the insurance company can compile a view of the number of insurance products each customer has, their demographics, geography, historical profile and win/loss rates. Reports like these are used both at an operational and at an executive level for strategic decision making.
With Tableau, SpareBank 1 Forsikring has rapid-fire answers to basic and complex questions like these—in minutes:
- How many and which of the insurers’ products do the customers own?
- What products are a logical fit for them? What products can they afford?
- What products have been offered to them? Are they in the process of acquiring any of them?
- Which agents or brokers do customers do business with most?
- Which customers are likely to not renew their policies?
Potential to increase revenue by $40m in 3 years
“This improved portfolio monitoring, coupled with improved knowledge of our customers and better pricing decisions has the potential to add more than $40 million to SpareBank 1 Forsikring’s revenues between 2015 and 2018,” says Roed.
For many years, SpareBank 1 Forsikring assumed that young drivers were the least profitable customers to insure. After all, they are less experienced behind the wheel and therefore more likely to raise an insurance claim for damage to their own or a third-party vehicle. Using Tableau visual analytics, the insurance company identified that this young group of drivers is in fact among the most profitable of all its motoring customers. Armed with this information, SpareBank 1 Forsikring has been able to adjust its pricing strategy and introduce new tightly targeted marketing campaigns encouraging more policies to be taken out. “We always had that data, but once we visualized it, everything became clear,” says Roed.