Post by Shivam .

📊 Excited to share my latest Healthcare Analytics Dashboard project built in Excel! Over the past few days, I worked on an end-to-end healthcare data analysis project using a dataset containing 38,000+ medical condition records, 26,000+ encounters, and 1,100+ patients. 🔹 Key Highlights: • Cleaned and transformed healthcare data using Python (Pandas) • Built a data model in Excel using Power Pivot • Created DAX measures for advanced KPI calculations • Designed 3 interactive dashboards with slicers and dynamic filtering 📈 Dashboard 1 – Healthcare Executive Overview • Patient demographics • Age and gender distribution • Healthcare service utilization • Top medical conditions 💰 Dashboard 2 – Cost & Financial Analysis • Total claim costs and payer coverage • Coverage ratio and uncovered costs • Cost drivers analysis • Healthcare spending by service type ⚠️ Dashboard 3 – Patient Risk & Emergency Care • Emergency utilization analysis • Inpatient admissions • Critical cost cases • High-risk patient insights • Ongoing condition monitoring 🛠 Tools Used: Python | Pandas | Excel | Power Pivot | Pivot Tables | DAX | Data Visualization This project helped me strengthen my skills in data cleaning, KPI design, data modeling, dashboard development, and healthcare analytics. Feedback and suggestions are always welcome! #DataAnalytics #HealthcareAnalytics #ExcelDashboard #PowerPivot #DAX #Python #Pandas #BusinessIntelligence #DataVisualization #HealthcareData #AnalyticsProject