Skip to content

vignesh4005/Excel_Healthcare_Data_Analysis

Repository files navigation

MS Excel- Healthcare_Data_Analysis

Welcome to the Healthcare Data Analysis and Insights project! This repository contains the code and documentation for analyzing healthcare data to extract actionable insights aimed at improving patient care and healthcare resource management.

Objective

Analyzed healthcare data to extract actionable insights aimed at improving patient care and healthcare resource management.

Key Features

  • Data Management: Ensured data integrity through cleaning and transformation.
  • Analysis: Identified trends and relationships in health metrics.
  • Visualization: Highlighted key patterns for informed decision-making.
  • Outcomes: Contributed to improved patient care, optimized resource allocation, and enhanced cost management within healthcare facilities.

Dataset

The dataset used in this project contains anonymized patient information, including demographics, medical history, treatment details, and associated costs. You can download the dataset from here.

Analysis and Insights

  1. Data Cleaning: Handled missing values, corrected inconsistencies, and formatted data.
  2. Data Transformation: Split columns, converted data types, and created new categorical columns.
  3. Data Exploration: Generated summary statistics and visualizations.
  4. Data Analysis: Combined tables, created pivot tables, and visualized data with charts.