BuchiTheGreat/BuildSzn-FloodWatch-Analytics-Report

Crowdsourced Flood Monitoring & Weather Correlation Analytics for Lagos, Nigeria (Power BI). # 🌊 BuildSzn FloodWatch Analytics Report A comprehensive Data Analytics project examining crowdsourced citizen flood reports, NASA weather severity metrics, and Lagos elevation datasets using Power BI to drive Product Design (PD) decisions. --- ## 📌 Executive Summary * **Total Citizen Reports:** 78 * **High-Risk Hotspots Identified:** 12 * **Total Survey Respondents:** 37 * **User Retention / Willingness to Report:** 95% * **Device Split:** 51.4% iOS vs. 48.6% Android --- ## 🛠️ Tool Stack & Methods * **Power BI Desktop:** Multi-page interactive dashboard development. * **DAX:** Dynamic measures, distinct counting, and hotspot threshold filtering. * **Data Cleansing:** Categorical normalization and text-field standardization. --- ## 📊 Dashboard Overview ### Cover Page Interactive landing portal featuring high-level core KPIs, custom app branding, and seamless multi-page navigation. ### Page 1: Flood Risk & Hotspots Identifies physical hazard points, high-risk corridors (Lekki Phase 1, Surulere, Ajah), and regional residency breakdown. ### Page 2: Weather & Report Correlation Examines the direct correlation between precipitation spikes and citizen reporting surges using NASA weather telemetry. ### Page 3: App Usability & Feedback Translates connectivity bottlenecks during rain, verification methods, and requested features into product insights. ### Page 4: Executive Summary & Strategic Takeaways Synthesizes key hazard findings, usability signals, and concrete Product Design (PD) engineering directives. --- ## 📂 Repository Structure & Datasets ```text BuildSzn-FloodWatch-Analytics-Report/ │ ├── 📁 dashboard/ │ └── 📄 Group 6 DA's BuildSzn Report (FloodWatch).pbix # Interactive Power BI Dashboard │ ├── 📁 data/ │ ├── 📄 FloodWatch Community Transit & Weather Resilience Survey...csv # Survey Responses │ └── 📄 nasa_weather_data.csv # NASA Weather Severity Data │ ├── 📁 images/ │ ├── 📄 Cover Page.png …