Description: Actuaries are currently familiar with the impact of new technologies used primarily by clinicians and health care providers, such as new drugs and devices. The common theme emerging from many of the articles points to a technological revolution in health care accelerated by the COVID-19 crisis this year. Actuaries need to understand these technologies, their impact, learn how to drive this technological change and guide the response of their profession and their own health care organizations.

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.