My client represented Medicare which provides medical benefits under the United States government. With over 165,000 entries in the 2020 data set, it was all but impossible to figure out or comb through that much data in order to reveal certain trends of billions of dollars paid for medical care. The job was to pull out some sample information from the data set to help the stakeholders have a better picture of their spending. They wanted to know five trends from their data, and I would look for more trends during my analysis, if possible, to give additional insights and help them make some logical and informed decisions.

This is a comprehensive analysis of the 2020 Medicare inpatient charges to gain specific insights on the charges submitted by the top medical providers, what do the charges mean, why the charges are as such, who is charging what, and where they are located, and offer a solution to Medicare with regards to how they should approach and try to remedy the underlying issues.