In the world of big data, tools like Microsoft Excel and VBA are starting to get stretched beyond their intended purpose and capabilities. While easy to use and helpful in analyzing small datasets, these traditional data tools lack the capacity to process and visualize data dynamically. In the last few years, many vendors have started to fill this gap with successful tool offerings for insurance use cases. Although these tools may seem daunting to learn at first, the time saved, and increased flexibility provided by these tools has been well worth the initial investment for many companies.The presenters will use case studies to introduce a variety of data visualization tools for actuaries with different technical backgrounds. In addition, they will demonstrate ways to leverage data visualization techniques to craft compelling stories for stakeholders and business owners. Discuss solutions such as R Shiny, Microsoft Power BI, Python Dash, Tableau, and other cloud offerings. Use cases may include data exploration, data mining, business intelligence, and dashboarding.
By attending the session, you will:•Identify drivers of excess deaths in both the U.S. population and insured population as a result of the COVID-19 pandemic.•Understand changes in the U.S. population’s health and behaviors that have contributed to these drivers.•Apply theses learnings when considering impacts to future mortality for the insured population.