Maven Healthcare Challenge

My analysis journey began with the collection of crucial data from CSV files, which I then imported into Microsoft Power BI. This initial step set the stage for what was to come – transforming raw data into actionable insights.

In Power Query, I dove headfirst into the data, cleansing and profiling it. This meant tackling issues such as managing missing values, correcting data types, and guaranteeing data uniformity.

Profiling gave me an in-depth understanding of the data's structure, a solid foundation for the next steps.

Streamlining the dataset by carefully selecting necessary columns while eliminating the redundant ones was essential. This step made the data more focused and manageable for the analysis ahead.

Constructing a strong data model formed the foundation of my analysis. This model facilitated table relationships, simplifying the process of aggregating and visualizing data across different dimensions.

DAX measures, my trusty tools, came next. These expressions helped me calculate average ratings for measures and states, providing precise metrics to gauge patient satisfaction trends.

Finally, it was time for the fun part – creating visuals and dashboards. Power BI offered a variety of visualization options, which I used strategically to showcase insights.

In the end, my journey culminated in a comprehensive analysis that uncovered valuable insights.

Findings:

The survey covered 19 questions within 10 measures across 51 states. Completed surveys decreased over the years, along with patient response willingness.

Positive ratings declined over the past 2 years. Nebraska and South Dakota excelled with top positive ratings, while the District of Columbia faced low response rates and negative results.

Is the dip in positivity and responses due to overall dissatisfaction? In 2020, positive ratings increased, possibly due to pandemic demands. Did the pandemic raise standards or strain resources?

Communication about medicines received consistently negative ratings, and Care transition rarely saw positives. Opportunities exist for improving Discharge information.

Best performances were in Communication with doctors and nurses.

While some measures improved, none surpassed their initial ratings.