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 analysis of health insurance cost and benefit trends using January 1, 2011 data from state employee medical plan renewals.

Description: The SOA has developed a new “tool” using Microsoft Access/Excel for international actuaries to conduct mortality and persistency studies in conjunction with the SOA’s international experience study initiative. Professionally programmed, this new tool facilitates the work of international actuaries.

Description: This article highlights business use cases where XTbML can define the tabled data in actuarial tables.

Description: Using the Internet as a Pricing Tool clinical background information, defining the change in coverage, collecting data, data quality and data limitations. Issue No. 39.

Description: Update on the SOA International experience study. The SOA has developed a new “tool” using Microsoft Access/Excel for international actuaries to conduct mortality and persistency studies in conjunction with the SOA’s international experience study initiative.

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.

Description: Update on Health Section research projects and topics, including new vision and mission statements for the Health Section Council, research and communications projects, and information about the Health Actuarial Research Initiative.