Hello! I'm Mamadou Diallo

The project involves working for a large insurance company that aims to gather and analyze data related to Medicare across the United States. The goal is to understand the landscape of Medicare claims, including which hospitals have the most claims, and which states have the highest claim amounts. The company already has extensive internal data from its own customers but seeks to supplement this with external data to gain a broader perspective. To achieve this, the project will involve pulling data from external sources such as data.medicare.gov, which provides a wealth of information about Medicare and healthcare in the U.S. The process includes using tools like Excel and PowerPivot to import and analyze the data. Specifically, the project will focus on downloading CSV files containing general hospital information, such as hospital names, types, ratings, addresses, and phone numbers. This data will then be analyzed to determine the distribution and characteristics of hospitals dealing with Medicare, helping the company better position itself in the Medicare insurance market.