Sign up to receive our monthly newsletter, and get the latest insights, tips, advice, and all the resources you need to transform your business with data.
Thank You!
After doubling revenue and tripling headcount in a span of three years, Analytics8 earned a spot among the fastest growing and most innovative companies on the Inc. 5000 list.
To thrive with your data, your people, processes, and technology must all be data-focused. This may sound daunting, but we can help you get there. Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.
+1 312 878 6600 Mon-Fri 8:30am-5:30pm CT
Connect with us on LinkedIn
"*" indicates required fields
Our monthly newsletter is full of resources to help you on your data and analytics journey.
Sign up to get expert-written insights, tips, and advice on how to get more value from your data.
See previous newsletters >
Thanks! You’ve been subscribed.
Financial Services
Qlik
Captive Resources (CRI) is an independent captive consulting company. They provide companies the ability to become insurance company owners, rather than insurance buyers, through the creation, development, and oversight of member-owned group captive insurance companies.
The analytics landscape at Captive Resources was marked by many manual and time-consuming reporting processes, leaving no time for data analysis. MS Excel was the primary and preferred tool for reporting and analysis, and even when incorporating more advanced features such as macros and linked sheets, CRI reached the limit of the capabilities of the tool. Reports were largely in tabular form, with little focus on data visualization.
CRI needed the ability to automate their reporting and see data across captives so they could perform unified analysis of premiums, claims/loss history, pricing factors, member counts, and more.
Assessment: CRI engaged Analytics8 to build a solution that would automate reporting, leverage data to support the planned growth, and refocus the effort of resources toward analysis of data. We started by conducting a strategic assessment of the company’s current state of technology and business processes. We interviewed business users to identify their daily processes and understand how they were currently utilizing their data. During these discussions, Analytics8 identified the key metrics that CRI leadership wanted to measure and helped users prioritize their report requests and use cases.
We also conducted meetings with data source experts and SMEs and profiled multiple source systems. This allowed us to begin plans for a data warehouse and gain an understanding of the feasibility of implementing each data source.
Combining the knowledge gained on the business and data sides, we created a use case prioritization matrix which weighed business value against feasibility to identify the optimal implementation schedule which would deliver value in short iterations.
The assessment resulted in an overarching long-term roadmap and more detailed short-term implementation plan with artifacts that can be used immediately to begin implementing the recommended solution. We provided a detailed plan for a robust data warehouse and centralized reporting platform and provided suggestions on data storage, BI and ETL tools, and staffing needs to support their ideal solution.
Data Warehouse Implementation: Moving forward with the analytics solution outlined in the assessment, we worked in short iterations to allow CRI to quickly start using parts of the solution. First, we designed and implemented an enterprise data warehouse that integrates Captive’s many data sources, including Sugar CRM, Pega, Pulpstream, Third-party administrator claims data, LotusNotes, and Excel; and we standardized the data collection process between captives to enable cross-captive analysis. We then implemented a modern BI platform (Qlik) on top of the data warehouse which aggregates data for 4,500+ member companies and provides self-service capabilities, powerful dashboards and visualizations, and a single point of access for all their analytics needs. The analytics solution offers insight into many business functions, including policy pricing, member history, claims, risk control, budgeting, brokers, and HR.
The roadmap and other deliverables from the strategic assessment allow CRI to proceed confidently with a solid plan to address growth concerns and implement an even more powerful and robust business intelligence solution. CRI now has a better understanding of data needs for business users across departments and the tools, data organization, and methods to effectively address those needs. They are utilizing the roadmap to plan for future phases, and the documentation within can serve as blueprints to speed up the development process.
With the implementation of the data warehouse and analytics solution, CRI now has a 360 degree view into their business and unified analysis of premiums, claims/loss history, pricing factors, member counts, and more.
The analytics solution allows Captive to:
Captive has also experienced huge time savings from automating data collection and blending tasks. Now employees can spend time analyzing their data and making data-driven decisions instead of manually creating reports. Additionally, the solution has helped create a culture where stakeholders take ownership of their data and work to improve accuracy and completeness.
Talk to an expert who will review your data struggles and help map out steps to achieve data-driven decision making.
Schedule a meeting with one of our data analytics experts who will review your data struggles and map out steps to achieve data-driven decision making.
Once a month, get expert-written insights, tips, and advice on how to get more value from your data.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.