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: 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.