![data analysis with excel for insurance companies data analysis with excel for insurance companies](https://howtoexcelatexcel.com/wp-content/uploads/2020/09/Quick-Analysis-Charts-1024x845.gif)
![data analysis with excel for insurance companies data analysis with excel for insurance companies](https://i.pinimg.com/originals/73/aa/60/73aa60c6bca835259fb2f02874899e17.jpg)
The company uses local authorization to secure data access. They publish visualizations in Tableau Server, where 300 to 400 employees across departments log in to view and interact with the data. These analysts access up to 800GB of data stored in Oracle and Microsoft Excel platforms for their analysis. Today, a five member team at Star Health takes care of all data requirements and builds data visualizations in Tableau Desktop. This was possible on account of the fact that Star Health could lean on experience gained from implementing the earlier solution, as well as the cooperation from Bodh Tree consulting. Implementation took 4 months, from the selection of the tool to going live. The implementation was carried out by a joint team of eight from Bodhtree Consulting and Star Health. They selected Bodhtree Consultancy Ltd., as an implementation partner.īetter business insights across departments Star Health identified Tableau as the tool that would meet its requirements, based on Tableau's performance on the Gartner Magic Quadrant. Star Health was looking for an alternate tool with multiple source connectivity, in-memory technology and more importantly, the ability to generate reports internally without vendor dependency. Dependency on the vendor slowed down processes and drove up costs. With the earlier tool, it was tough for the company to accurately estimate timelines for the generation of each report and anticipate the impact on other reports in the pipeline. Even from a regulatory standpoint, insurance companies need to submit several reports on internal data to authorities. In addition to internal data, Star Health might look at the incidence of diabetes in the country, age groups, or geographies that are most affected, or causes of the disease, for example. For instance, if the company were to float an insurance product for diabetes, it would need to analyze a variety of data to arrive at the optimum pricing model.
![data analysis with excel for insurance companies data analysis with excel for insurance companies](https://www.pickl.ai/blog/wp-content/uploads/2023/03/Excel-in-Data-Analytics.jpg)
Before launching the product, the company needs to submit detailed reports with the Indian Government’s Insurance Regulatory and Development Authority (IRDA), which can be done using Tableau. This helps the actuarial team model new prototypes based on market requirements. When a new insurance product is developed, data on existing products is analyzed vis-à-vis external information. The Product Development team needs to conceptualize and design new products. The Claims department needs to analyze factors such as the incurred claims ratio against the premium procured and performance of network hospitals with respect to turnaround times, costs, etc. As a result, the internal team was not in a position to produce ad-hoc reports in a timely or cost-efficient manner. Since it was a customized tool rather than an off-the-shelf product, the company needed to work with the vendor to generate each report. Despite switching to the new platform, several challenges remained. Star Health decided to invest in a Business Intelligence platform in the year 2010. But working with such large amounts of data-Star Health has more than 1.5 million customers and policies in India-in Excel made it vulnerable and unstable. Initially, the company used Microsoft Excel to maintain reports and databases. Beyond pricing and modelling, the company relies on data analysis to inform everything from provider performance to new product development and regulation compliance. Sethuraman Kannan, CIO and Vice President of Information Technology Star Health Insurance. Our pricing and modelling depends on analysis of data, not only from our products but also from external sources in the industry,” said Mr. “As an insurance company, our entire business hinges on the availability of reliable data. Star Health has a pan-India presence with a network base of about 300 offices and 600 one man offices across the country servicing its 1.5 million customers through 6000+ hospitals, providing cashless hospitalization. Today, roughly 400 employees interact and view Tableau visualizations built on up to 70 million rows of data (800GB). The company chose Tableau because it could provide multiple source connectivity, in-memory technology, and most importantly, the ability to generate reports internally without vendor dependency. Star Health was using a business intelligence (BI) platform that was extremely vendor-dependent, making the analytics and reporting process slower and costlier. Its subsequent investors include ICICI Ventures, Sequoia Capital and Tata Capital. The company is a joint venture between Oman Insurance Company, leading NRIs and several Indian business houses. is India's first standalone health insurance company. Reference Materials Toggle sub-navigation.Teams and Organizations Toggle sub-navigation.Plans and Pricing Toggle sub-navigation.