Description: Renal disease is a very heterogenous medical condition whose end state is dialysis, a recurring cost intensive medical condition. Dialysis cost is one of the major medical cost drivers in USA. Insufficient and improper care management in the early stages of CKD (chronic kidney disease) leads to early incidence of end stage renal disease (ESRD) among CKD patients which not only leads to high medical costs, but also reflects poor health quality.

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