Analytics and Reporting

Inconsistent Data Sets: ETL Process for CMS Quality Data

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

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

Jonathan Mathieu, Ph. D.

June 5, 2019

Analytics and Reporting

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

Jonathan Mathieu, Ph. D.

March 14, 2019

Analytics and Reporting

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

Emma Rourke

July 17, 2018

Analytics and Reporting

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

T test in Excel for Hospital Performance Data: The Recap

Rik Ganguly, MPH

May 14, 2018

Analytics and Reporting

Post 3: In this post, I will summarize the steps used from the previous blog post in applying the T test to hospital quality data, using one of the measures from CMS Hospital Compare as an example. The formula references in this post are directly from prior blog, so it is probably helpful for you...Read more

T test in Excel for Hospital Performance Data: Running the T Test

Rik Ganguly, MPH

May 14, 2018

Analytics and Reporting

Post 2: In the first blog post of this series, I introduced the idea of using Excel to run T test on hospital quality data from CMS Hospital Compare. I laid out the assumptions and approach to the analysis. Please check it out before proceeding. The focus of this blog is setting up the Excel...Read more

T test in Excel for Hospital Performance Data: Approach

Rik Ganguly, MPH

May 14, 2018

Analytics and Reporting

Post 1: Imagine you are in a pinch and need to run an analysis quickly and produce meaningful results. You throw your data into Excel, thinking all you need to do is enter some formulas and make it pretty. And then, after opening up with Excel and toying with your dataset, you realize this might...Read more

Next 1 … 5 6 7 8 Previous

Inconsistent Data Sets: ETL Process for CMS Quality Data

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

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

Social Determinants of Health: Addressing Barriers to Create Healthier Communities

T test in Excel for Hospital Performance Data: The Recap

T test in Excel for Hospital Performance Data: Running the T Test

T test in Excel for Hospital Performance Data: Approach

About the APCD Journal

Follow the APCD Journal

Categories