HealthCare Analytics

💡 Problem Statement

Healthcare facilities often face challenges in effectively utilizing large-scale patient data to improve healthcare delivery and operational efficiency. Without proper analysis, hospitals cannot fully understand critical patterns such as disease trends, patient demographics, or insurance preferences, limiting their ability to improve service and allocate resources efficiently.

💡Objectives

The objective of this project is to analyze hospital data using Microsoft Excel to uncover key insights related to patient demographics, medical conditions, and hospital performance, providing stakeholders with actionable recommendations for improving healthcare delivery.

💡Data

The dataset 🖥️ used in this project is obtained from kaggle.

💡Tools Used

• Tools : Microsoft Excel
• Keywords: Healthcare Analytics, Data Analysis, Data Visualization, Pivot Table, PivotChart, VLOOKUP, Aggregate Functions, Trend Analysis, Correlation

💡Dashboard

The dashboard analysing various metrics is presented as follows:

💡Description

The steps involved in building this healthcare analytics projects are mentioned below:

• The project begins with the process of data cleaning, which involves removing any duplicate entries, removing null values, setting the correct format for columns with text, setting the correct datatype for each column, and so on.
• The next step is to form tables and start the analysis process, using the vlookup function to extract useful data columns for analysis purposes.
• We created pivot tables and pivot charts to solve the problem statement.
• Finally, we created an interactive dashboard to more effectively represent the analysis.

💡Results

The following key results were obtained after performing data analysis on the dataset:

1. Doctors Treating Specific Conditions: A significant proportion of doctors, 16.92%, specialize in treating arthritis, while a nearly equal percentage, 16.91%, focus on managing diabetes.

2. Patient Blood Type Distribution: Among the patients, 16.08% have a B-negative blood type, reflecting a notable segment of the patient population.

3. Age Demographics: The majority of patients, 21.87%, are over the age of 70. This age group represents the largest portion of the patient population.

4. Health Condition Prevalence by Age: Patients aged 70 and above experience the highest incidence of hypertension.

5. Patient Volume in 2020: The year 2020 recorded the highest number of patients, with a total of 11,285 individuals seeking medical attention.

Thank you for visiting my repository!