15 49.0138 8.38624 1 1 4000 1 https://apcdjournal.com 300 true
Analytics and Reporting

Inconsistent Data Sets: Augmentation of the ETL Process for CMS Quality Data

When something occurs automatically, the computer completes a task from start to finish. In an augmented task, the computer helps the person to complete the task, but needs some form of interaction or input from the user. Previously, we explained how Freedman Analytical Engine (FAE) uses metadata dictionaries to convert column headers and measure identifiers...Read more

Inconsistent Data Sets: The Use of Dictionaries for CMS Quality Data ETL

In the previous blog post, I explained the general ETL process for CMS quality data. Analysis of quality data from the Centers for Medicare and Medicaid Services (CMS), just like all payer claims data, population health management data, and other data sources, requires the data to be extracted, transformed, and loaded. The majority of this...Read more

Far from perfect competition: A Look into the Market Shares of our Nation’s Leading Health Insurance Companies

Prepared by: Ellen Bloom, Jonathan Mathieu, and John Freedman. Do you know the principal health insurance companies in your state? Take a look at the following highly concentrated markets and see which health insurance companies hold the largest market shares (with the least amount of competition). By now, we have all heard the term “Medicare...Read more

All Politics, Even in Healthcare, Is Local: A look at NRHI’s latest report on healthcare cost variation in 6 regions

Are you looking for a deeper dive into the reasons why healthcare costs vary so widely among states? You may want to pay attention to your local health system.     A recent edition of The Hospital Finance Podcast focuses on the Network for Regional Healthcare Improvement’s (NRHI) report discussing this issue, “Healthcare Affordability: Data...Read more

Social Determinants of Health: Addressing Barriers to Create Healthier Communities

What do income, education level, employment, social networks, and housing have in common with with healthcare? Experts widely accept that these factors, known as Social Determinants of Health, can greatly affect a person’s physical and mental wellbeing. The phrase Social Determinants of Health, or #SDOH as it commonly appears on social media, has received a...Read more