Healthcare facility analysis

Proud to share our end-to-end healthcare data analysis project where we combined SQL, Python, Excel, and Power BI to transform raw data into actionable insights that support data-driven decisions in the healthcare sector.

Project Highlights:

Database Design & SQL Extraction: Imported 9 relational tables into SQL Server, performed multi-table joins, and exported a clean, integrated dataset.

Data Cleaning & Preprocessing: Removed duplicates, handled missing values, standardized formats, and verified data integrity using Excel and Python.

Exploratory Data Analysis (EDA): Applied statistical summaries, visualized patterns with Matplotlib, and created interactive filters for focused analysis.

Power BI Dashboard: Built interactive reports with KPIs, slicers, and charts to display patient distribution, cost analysis, service types, and satisfaction scores.

Key Outcomes:

Gained insights into patient demographics, service type distributions, and cost patterns.

Identified trends and anomalies to support better decision-making in healthcare management.