Description: This article provides an overview of critical illness insurance: history, product description, and the three primary ways to offer critical illness coverage in the United States. This article also contains an illustration of an issue age premium rate calculation, as well as product features and rating applications specific to the various types of critical illness coverage.

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.