Itajobi/Health-dashboard-Africa

Health dashboard using Excel to visualize disease trends in Africa (1990–1995). # Health Dashboard Across Africa 1drv.ms This Excel dashboard shows health trends across selected African countries from 1990 to 1995. It visualizes key indicators like HIV/AIDS, Tuberculosis, violence, and disorder using interactive charts and slicers. The goal is to make disease patterns easier to understand and support public health insights. # Project Overview The project transforms a raw health dataset into a professional, interactive dashboard using Microsoft Excel. It applies Excel’s charting tools, slicers, and conditional formatting to create visuals that help explore regional differences in disease burden and trends over time. # Features Interactive slicers for filtering by year and country KPI cards for Total Violence and Total Disorder Bar chart showing Total Disease by country Line chart for Tuberculosis trend Stacked column chart for HIV/AIDS comparison Donut and pie charts for distribution Map chart to visualize geographic disease spread # Tools Used Microsoft Excel Pivot Tables and Pivot Charts Slicers Map Chart Conditional Formatting Layout and Color Styling # Key Insights Nigeria, Kenya, and DR Congo reported the highest total disease values Tuberculosis and HIV/AIDS showed clear differences across countries Violence and disorder data reflect underlying health challenges This dashboard can assist in public health planning and awareness # Files Included Health\_Dashboard.xlsx – The main Excel dashboard Health\_Dataset\_Mock.xlsx – The cleaned dataset used for visuals # Author Olanireti Itajobi