A century-old insurance company with a diverse portfolio of financial offerings prides itself on helping at a local level and building community while maintaining a national perspective. Being a leading provider in the insurance industry and keeping to the mission of serving clients as individuals, not as policies, comes with great daily challenges.
The company found itself with large stores of data – customer data, claims data, policy data, so on and so forth – and an inefficient way of gleaning insight from the data. They embarked on a large scale project to extract data from the mainframe systems and deposit it into a big data lake with an analytics visualization tool sitting on top.
With differing opinions on how to tackle the grand data lake, the company connected with BlueGranite to explore options of making the data accessible to the business. BlueGranite embarked on a discovery exercise, involving multiple sessions with the business, in order to uncover the mechanisms which make the business run, how data is perceived, how data is utilized and how it is viewed. The answers and findings in these “model storming” sessions became the clues to the data model.
BlueGranite developed a cloud-based dimensional data warehouse based upon the needs of the business and structured it in a functional manner that suited the processes and procedures followed by the business and aligned with the everyday data requests. Microsoft Power BI was laid on top of these functional dimensional data areas and sample reports were delivered to the customer to showcase the power of the newly built data warehouse.
