Data Quality

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

October 3, 2019

Analytics and Reporting, Data Quality, Technology

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

Freedman HealthCare Staff

August 26, 2019

Analytics and Reporting, Data Quality, Technology

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

Inconsistent Data Sets: ETL Process for CMS Quality Data

Freedman HealthCare Staff

August 19, 2019

Analytics and Reporting, Data Quality, Technology

New Blog Series: Inconsistent Data Sets How do you deal with inconsistent data? Every experienced analyst knows that about 90% of the job is getting your data in shape for analysis. This 90% is not only time-consuming, but also more drudgery than enlightenment. This is especially true if you need to merge multiple data sets...Read more

Data quality checks: A framework for APCDs

John Bott, MBA, MSSW

July 20, 2018

Data Quality

Inhabiting the space of health care performance measurement for quite some time, I’m convinced the biggest improvement we will make in measurement will not come from better measures. It will come from better data. So, when I was recently asked to examine the capacity of a given APCD to produce performance measures suitable for accountability,...Read more

Health Care Needs More than Bezos, Buffet and Dimond

Mary Jo Condon, MPPA

February 14, 2018

Data Quality

Customers tame markets. But in health care, the customers with the greatest ability and responsibility to shape the industry– the employers who buy health care for most Americans – have lacked the courage to demand value. They’ve chosen to accept outrageous costs rather than face the public relations’ unpleasantries of rejecting high-priced providers. They’ve shied...Read more

Lead with Nothing

Eric Olmstead, PhD

September 22, 2017

Data Quality

Medical claims extracts will frequently drop the leading zeros from codes as shown in this dataset. It is important to add leading zeros back to your codes before using crosswalks and code sets.Read more