Comparative Healthcare Analytics Dashboard – US vs India
Project Title: Comparative Analysis of US and Indian Healthcare Systems Group Project – MS in Business Analytics, UMass Amherst
Project Overview: This project presents a data-driven comparative analysis of the healthcare systems of the United States and India, focused on evaluating key indicators such as healthcare expenditure, life expectancy, maternal mortality, immunization rates, hospital infrastructure, and healthcare workforce. The goal was to identify disparities, policy implications, and opportunities for optimization through visual analytics.
Objectives: • Analyze and compare healthcare quality, accessibility, and efficiency between the U.S. and India • Visualize trends in life expectancy, immunization, maternal and child health • Examine socio-economic and demographic influences on healthcare outcomes • Provide actionable insights for healthcare policymakers, researchers, and strategy professionals
Dashboards & Visuals (Created in Tableau): The final Tableau dashboards showcase: 📌 Population & Demographics 📌 Life Expectancy Trends (2013–2022) 📌 Maternal Mortality Ratios 📌 Hospital Beds per 1,000 People 📌 Immunization Coverage (DPT, HepB3, Measles) 📌 Physicians per Capita 📌 Healthcare Expenditure: Public vs Private, % of GDP, per Capita
Explore the PDF or Tableau file for dynamic dashboard views.
Key Insights: • India’s public health system faces challenges in accessibility, maternal health, and infrastructure, particularly in rural areas • The U.S. system offers advanced infrastructure but suffers from high costs and unequal access • Preventive healthcare (e.g., immunization) shows opportunity for growth in both systems • Both countries face chronic condition burdens and need tailored strategies • International benchmarks and WHO goals highlight the need for collaboration & universal health coverage
Tools & Technologies: • Tableau: Dashboard development and data visualization • Excel: Data cleaning and transformation • Public Health Datasets: World Bank, WHO, India Ministry of Health, U.S. CDC
👥 Contributors: • Anand Gupta • Rahul Mishra • Ryan Mack • Guided by: Prof. William Oliver, UMass Amherst
Files Included: 602 BIA Project File.twbx: Tableau workbook, 602 BIA Project File.pdf: Exported dashboard visualizations, 602 presentation.pptx: Final presentation deck
Notes: This project highlights the power of visual analytics in driving policy-level decisions and fostering global healthcare insights. Data limitations were addressed through transformation techniques and assumptions outlined in the project documentation.