🧠 Organ Transplant and Donor Demography Dashboard (2023/24)

This Power BI report provides a comprehensive analysis of organ transplants, donor demographics, and waiting lists across the UK for the year 2023/24. It is designed to help stakeholders, researchers, and public health professionals explore key performance indicators and identify trends in organ donation and transplantation.

---

📊 Key Features

1. Organ Transplant Analysis

• Organ and Country Slicers: Interactive buttons to filter by organ and UK country.
• KPI Cards:
  • Total Transplants
  • Total Waiting List
  • Waiting to Transplant Ratio
  • Average Transplant Rate (pmp)
• Charts & Visuals:
  • Transplant Share by Organ
  • Transplants vs. Waiting List by Organ
  • Transplants by Country
  • Donor Efficiency by Organ

2. Donor Demography Analysis

• KPI Cards:
  • Donor Efficiency
  • Total Deceased Donors
• Charts:
  • Total Deceased Donors by Organ
  • Age Distribution by Group (DBD vs DCD)
  • Blood Group Distribution
  • Gender Profile
  • Ethnicity Profile

---

📁 Data Sources

Data was extracted from a national organ transplant activity report (PDF) for 2023–2024. Transformation was performed in Power Query, with calculations in DAX.

• Transplant & waiting list data by organ and country
• Deceased donor demographic breakdown
• Rate per million population (pmp)

---

🛠 Tools & Technologies

• Power BI Desktop
• Power Query M
• DAX
• GitHub (for version control)

---

💡 Insights Uncovered

• Which organs have the highest transplant demand vs. supply
• Regional disparities in transplant access across the UK
• Age, gender, ethnicity, and blood group characteristics of deceased donors
• Transplant efficiency ratios and donor utilization trends

---

✅ How to Use

1. Use slicers at the top to filter by organ or region
2. Hover or click charts for interactive tooltips
3. Compare trends over time and between groups (DBD vs DCD)

---

📌 Future Improvements

• Add image-based slicers (organ illustrations)
• Embed dashboard into Streamlit or web app
• Include long-term trends and survival outcomes if available

---

🧠 Author & Purpose

This dashboard was created to:

• Support data-driven decisions in kidney and organ health
• Raise public awareness about organ donation
• Provide a reusable reporting model for future NHS data releases

© ADEYEMI Bolaji, 2024 | Designed for educational and public health advocacy purposes.