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: The article discusses the use of R in prototyping automation procedures. It offers general pros and cons for R and walks through a specific use case, which involves scraping and summarizing data stored in Microsoft Excel.