Healthcare Analytics Dashboard
The Challenge
Healthcare administrators and policymakers required a unified, easy-to-interpret view of patient care, diagnostic trends, and treatment costs. Data was fragmented across multiple sources, limiting visibility into patient outcomes, treatment effectiveness, seasonal admission patterns, and cost drivers; slowing down evidence-based decision-making.
What I Built
I designed and delivered an interactive Tableau dashboard that integrates multiple healthcare datasets into a single, analytics-ready view to support operational and strategic decision-making.
- Prepared and modeled healthcare data in Microsoft Excel for analytics readiness
- Designed KPI-driven visualizations including trend lines, bar charts, pie charts, and heat maps
- Built interactive filters enabling drill-down by time period, patient type, and diagnosis
- Applied Tableau best practices for clarity, usability, and data storytelling
Business Impact:
• Enabled rapid identification of trends in patient admissions and outcomes
• Improved monitoring of treatment effectiveness and cost patterns across conditions
• Revealed seasonal admission trends using heat map analysis
• Reduced decision-making time through real-time access to critical healthcare KPIs
Dashboard Structure
- Patient Summary – admissions trends, outcomes, and gender distribution;
- Diagnostic Conditions – prevalence and patterns across medical conditions;
- Treatment Cost Analysis – comparative cost and effectiveness across diagnoses.
The solution consists of a three-page Tableau dashboard:
- Overview Interactive healthcare analytics dashboard providing real-time visibility into patient outcomes, diagnostic trends, and treatment costs. Designed to support data-driven decisions for healthcare administrators and policymakers.
- Technologies Used Tableau Desktop(Interactive Dashboard), Microsoft Excel, Data Modeling
- Skills Demonstrated Healthcare analytics, data storytelling, KPI development and visualization, dashboard design, Tableau best practices, interactive reporting, and analytics UX design.
- Business Impact Enabled healthcare stakeholders to monitor patient care performance, identify cost drivers, and improve resource allocation through centralized, real-time analytics.