Description: CMS provides ACOs with monthly claims data for members, including their medical visits and ACO program eligibility. This data can be divided into Membership and Claims tables through the ETL process. However, when calculating PMPY at specific levels of detail using these tables, issues arise due to unrelated dimensions, leading to inaccurate and understated results. This article presents a solution to this problem by utilizing Tableau's data blending capabilities.

Description: Uncertainty of a predictive model is a fact of life that many insurers could be overlooking at their peril without a framework for assessing it. The article provides a framework to understand the prediction uncertainty, which can be critical for the insurance operations using predictive models. Coin toss example explains model uncertainty and randomness inherent in making predictions to the number of heads expected. A mortality analysis case study illustrates how the Bayesian methodology can be used to develop the prediction uncertainty. In particular, the article shows that the Bayesian framework is a way to combine historical data and actuarial judgment, and directly address the model uncertainty through its posterior distribution.

Description: Applying Predictive Analytics for Insurance Assumptions Setting: high level principles.

Description: A new project combining survey data from people across the country with data from John's Hopkins and the CDC on COVID cases and deaths. This project provides weekly data for individuals, businesses, and policy makers to understand which COVID mitigation efforts are in place in their area, how they are working, and how different COVID mitigation methods have been working in different parts of the country.

Description: The most recent demographic data published in Mexico allows us to analyse in detail the profound demographic transition that has been taking place in the country for more than four decades. It is possible to develop forecasts for the future on the basis of this historic experience. The purpose of this article is not only to illustrate the profound demographic change in Mexico – and what it is expected to experience over the coming decades – but to highlight the challenges for the insurance industry posed by the various demographic trends. Wherever challenges are found, however, opportunities also exist, provided the industry succeeds in adequately transforming its own processes and meeting the needs of a changing market.

Description: Deep learning neural network applied to experience analysis for post-level term lapse and mortality.

Description: This article delves into the transformative realm of Business Intelligence (BI) tools. We explore the fundamental functionality and structure of these tools, and through case studies illustrate how they offer valuable insights into carrier experience and underwriting dynamics. From real-time data visualization to in-depth data analysis, discover the essential features that empower businesses to make better informed decisions.

Description: An application of GLM trees to mortality modeling using the Individual Life Experience Committee 2009-2015 dataset. GLM trees are a hybrid of GLMs and decision trees which are analogous to the way actuaries have analyzed data. The major benefits include speeding up actuarial analytic workflows, improving data understanding, and improving data visualization.