Skip to content

LoganathanAnalyst/Health-Analytics---PowerBi

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Health Analytics Dashboard

🏥 Health Analytics Dashboard – Power BI

A powerful and interactive Health Analytics Dashboard designed to transform raw healthcare data into meaningful insights. This report helps understand patient trends, diagnosis patterns, hospital operations, and overall health performance metrics — all in one place.

🌟 Overview

This Power BI dashboard provides a complete picture of healthcare performance. It is built for students, analysts, and healthcare professionals who want simple, visually engaging insights.

✔ Easy to navigate ✔ Professional design ✔ Clear storytelling through data ✔ Real-world healthcare KPIs


📊 Key Insights Provided

👨‍⚕️ Patient Demographics – Age groups, gender split, region distribution

🏷️ Diagnosis Category Trends – Top diseases & frequency

🏥 Hospital Metrics – In/Out-patient counts & visit patterns

🔍 Treatment Analysis – Timeline trends, cost overview, case categories

⭐ KPI Cards – Total patients, high-risk cases, avg treatment cost, etc.


🛠️ Technologies & Skills Used

Power BI Desktop

Power Query (Data cleaning & transformation)

DAX Measures (Custom KPIs & calculations)

Data Modeling (Star Schema)

Professional UI/UX design best practices


🧩 Data Model Summary

The model is designed for efficiency and fast performance:

Dimension Tables 📌 Patients 📌 Doctors 📌 Diagnosis 📌 Date

Fact Table 📌 Treatment / Visit Details

Proper relationships ensure smooth filtering, drilling, and KPI calculations.


🖥️ Dashboard Features

🎛️ Interactive slicers (Age, Gender, Disease, Year, Region)

📈 Trend analysis using line & bar charts

🍩 Category distribution with donut charts

📌 Drill-through pages for patient-level insights

🧮 Custom KPIs using DAX

🎨 Modern color theme for clean visualization


📂 Included File Health_Analytics_Dashboard.pbix


🚀 How to Use

Download the health Analytics Dashboard.pbix file from this repository.

Open in Power BI Desktop (Latest Version).

Explore dashboard visuals, KPIs, and filters.

Refresh or replace the dataset if required.


🤝 Contributing Have ideas to improve this dashboard? Feel free to open issues or submit pull requests.


⭐ Support This Project

If you found this dashboard useful, please star ⭐ the repository. Your support motivates further improvements!

🧑‍💻 Author
👤 Loganathan Balan
Passionate about Data Analytics, Power BI, and building meaningful dashboards.

😊 Happy Dashboarding!

About

The Health Analytics Dashboard is a Power BI report that turns raw healthcare data into clear, interactive insights. It helps users quickly understand patient trends, diagnosis patterns, and key hospital performance metrics.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors