Christiana77723/Accra-Flood-Analysis-Dashboard-Power-BI-

# 🌊 Accra Flood Analysis Dashboard (Power BI) An interactive Power BI dashboard analyzing the impact of flooding across communities in Accra — tracking human toll, displacement, and economic loss to support disaster response and community planning decisions. ## 🖥️ Overview The dashboard provides a single-page view of flood impact, filterable by **Community** via a searchable checklist slicer covering areas including Achimota, Adabraka, Alajo, Circle, Kaneshie, Mallam, Odwana, Spintex, Tse Addo, and Weija. --- ## 📄 Dashboard Contents **KPI Cards** - 12 Total Deaths - 7 Missing People - 10 Communities Affected - 7,761 Total Houses Displaced **Houses Displaced by Community** - Bar chart ranking communities by number of houses displaced, with Alajo, Weija, and Kaneshie among the hardest-hit areas **Total Economic Loss per Community** - Bar chart of estimated economic loss (in tens of millions), led by Weija and Kaneshie **Total Deaths per Community** - Bar chart showing death counts concentrated in a handful of communities (Alajo, Kaneshie, Weija, Achimota, Adabraka, Circle, Odwana), with most others reporting zero **Flood Duration vs Deaths** - Scatter plot comparing flood duration (days) against death toll per community, with a downward-sloping trendline --- ## 🔍 Key Insights - **Concentrated impact:** A small subset of communities — Alajo, Weija, and Kaneshie — consistently appear at the top across displacement, economic loss, and death metrics, suggesting these areas may need prioritized flood mitigation investment. - **Displacement scale:** With 7,761 houses displaced across just 10 communities, average displacement per affected community is substantial, pointing to a need for coordinated shelter and resettlement planning. - **Duration vs severity:** The scatter plot suggests flood duration alone does not strongly predict death toll — some shorter-duration events show comparable or higher deaths than longer ones, indicating other factors (terrain, po …