For a tutorial video that walks you through the process of using the Open Data Bits library of documentation to build your own open data mashups, we have created a video that can be watched by clicking here.

Note: The data set Medicare Provider Utilization and Payment Data: Physician and Other Supplier from CMS contains CPT codes that are the intellectual property of the AMA.  There is a licensing document available from CMS at the Data Source Link below which details the terms of the license.

Data Source Link

Available Access Formats


Sources and Modeling

Row Color Derived Column
Row Color Column Not Used by Open Data Bits

Logical Model


  • County Code > State Code > Zip Code
  • County Code > State Code > City Code

Calculated Columns & Calculations

Name DAX Expression Type
Address =CONCATENATE([Street Address 1],CONCATENATE(“, “,CONCATENATE([City],CONCATENATE(“, “,CONCATENATE([State Code],CONCATENATE(” “,LEFT([Zip Code],5))))))) Calculated Column
Zip Code 5 Digit Key =LEFT([Zip Code],5) Calculated Column
Total Number of Services =SUM([Number of Services]) Calculation

Examples for Reference

Open Data Bits – CMS Medicare Provider Utilization and Payment Data Now Featured at Open Data Bits