BIG Ideas from The Business Intelligence Guy

BIG Ideas from The Business Intelligence Guy


CMS Provider Utilization Data 2020

August 01, 2022

Do you know your practice’s market share?


Do you know what your competitors are charging?


Today’s BIG Ideas podcast can help you answer both of those questions using CMS provider utilization data.  CMS just released the 2020 Provider Utilization File.  The file has over 10 million records, so I used SQL Server and Power Pivot to analyze the data.  The CMS data tells you how many times providers billed CMS for each procedure code and what they charged.  This information can be terrifically helpful in understanding your competition and planning expansion.  You can also use the data for E&M coding comparisons.  Listen for some of the constraints in the data, such as CMS removing procedure codes billed less than 11 times.  You will also get some ideas on how you might use this data.  If your practice does not have the IT bandwidth to work in SQL Server, let’s talk about how to get a subset of the data to use in a traditional Pivot Table.












The post CMS Provider Utilization Data 2020 appeared first on Moore Solutions Inc.