Description: This article offers ways to make use of Excel more efficient, by applying software development and design principles

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.

Description: As the insurance industry continues to evolve due to a pandemic and rapidly changing economic and regulatory conditions, the role of data scientists and actuaries has become increasingly important. In an interview with the Atidot data science and actuarial team, we discuss what it is like to work at an InsurTech, how data scientists and actuaries can collaborate, and look at some concrete technical examples of where the innovation is having an impact. This article explores what collaboration can look like and how the role of data science and actuary may evolve in the InsurTech industry in the future.

Description: This article summarizes IT trends that impact life, health and P&C insurance providers as revealed by Gartner's research.

Description: This article is about why actuaries should have integral roles within nearly every IT and business intelligence company serving the insurance industry.

Description: Mindful data visualizations show the end users the end way in how to analyze and interpret your data. More importantly, they can then use this data they see to drive decisions and modeling going forward.

Description: This article contrasts the madness of the building of the Winchester House, a large California mansion, to business intelligence and data warehousing systems.

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.