The HCAHPS (Hospital Consumer Assessment of Healthcare Providers and Systems) survey is the first national, standardized, publicly reported survey of patients' perspectives of hospital care. HCAHPS (pronounced "H-caps"), also known as the CAHPS Hospital Survey, is a survey instrument and data collection methodology for measuring patients' perceptions of their hospital experience.

As part of the challenge, I downloaded the data from Maven Analytics and for further information about the survey, I have referred to the following link.

https://www.cms.gov

Eligible patients for survey:

• 18 years of age or older when admitted to the hospital
• At least one overnight stay in inpatient care at the facility
• Non-psychiatric diagnosis at discharge
• Alive at the time of discharge

And Hopsitals should conduct minimum 300 surveys.

The project's objective was to address the following questions:

• Have hospitals' HCAHPS scores improved over the past 9 years?
• Are there any specific areas where hospitals have made more progress than others?
• Are there any major areas of opportunity remaining?

Data Cleaning :

To clean the data, I utilized Power Query. In the "Responses" table, where the "Completed Survey" and "Response Rate" columns contained "not available," I converted these values to zero for calculation purposes.

In the "Completed Survey" column, I adjusted counts of fewer than 50 to 50, fewer than 100 to 100, and between 100 and 299 to 200 (the average), while counts of 300 and more were set to 300. This adjustment aimed to assess whether facilities were able to conduct a minimum of 300 surveys.

I generated a date table by extracting the year information from the "Reports" table.

Data visualization:

For visualization ,I utilized Power BI. I utilized both PowerPoint and Canva for designing the background elements of my project.

I developed an interactive report that allows users to select a specific year and different questions for analysis over time. This provides a dynamic and user-friendly way to explore and understand the data.

I've calculated the number of hospitals that conducted more than 300 surveys and those that conducted less than 300 surveys. This distinction helps us understand how many hospitals were able to conduct more surveys. It's worth noting that the cards may show overlapping numbers for the overall value because some years had fewer surveys conducted, but for specific years, you'll see the correct numbers.

Valuable Observations:

• The hospital's HCAHPS scores showed a gradual improvement until 2021(2020 survey), but they have been on a declining trend since then.
• The overall response rate from patients is approximately 27%. Increasing awareness can significantly aid in the analysis process by potentially improving response rates and data accuracy.
• Hospitals demonstrate strong performance in areas such as providing comprehensive discharge information and facilitating effective communication with both doctors and nurses.
• There is a room for further improvement in areas such as care transition, communication about medication and the overall quietness of hospitals.

Recommendations:

• Since 2021(2020 survey year), the number of completed surveys has decreased compared to previous years. Conducting more surveys can lead to a more accurate and comprehensive insight into the situation.
• For effective care transition, establish clear communication protocols between healthcare providers, ensure thorough patient education and facilitate seamless information transfer.
• To maintain a quiet hospital environment, enforce strict noise policies, educate staff and visitors on the importance of silence and use technology and soundproofing measures where necessary.