Rising Waters, Rooted Resilience: Real-Time Flood Monitoring Dashboard
I'm excited to share my entry for the Power BI Viz World Championship—a near real-time flood monitoring dashboard developed for Snoqualmie Valley, a community vulnerable to frequent flooding. Using water level and flow data from the U.S. Geological Survey (USGS), the dashboard refreshes hourly, providing timely and actionable insights.
An automated data pipeline continuously pulls and processes USGS measurements, clearly highlighting critical water levels with intuitive, color-coded alerts. Users can easily switch between hourly, daily, weekly, and monthly views, allowing them to quickly assess current conditions and anticipate potential flooding risks.
The dashboard also includes a simulated near-flooding scenario. This dashboard help residents and businesses prepare proactively for emergencies. Historical insights are also included, enabling the community to analyze past flood patterns and better understand the local flood dynamics.
Designed for clarity and readability, the dashboard employs effective color contrasts and clean visual elements, making it accessible and easy to understand for everyone. Maps, charts, and simple navigation help users rapidly interpret the information.
By delivering critical data in a clear, intuitive format, this dashboard empowers the entire Snoqualmie Valley community—homeowners, businesses, and emergency responders—to make informed decisions, protect assets, and enhance overall resilience against flooding.
cc: @slindsay
(Note: Unfortunately I am not able to publish the report to web . I guess its because of the direct query mode to a lakehouse . so I have attached the pbix )
(Note 2: I was able to change the quey mode to import mode the report is piblished now)
