This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Announcing Alteryx + Snowflake | Alteryx and Snowflake make analytics and data science fundamentally easier. With the new integrated starter kit, you can push down data prep transformations and more into Snowflake for faster data quality and analytics output. Learn More
Alteryx for Disaster Relief: Hurricanes Irma and Maria
Name: Michael DePue
Title: Vice President
Overview of Use Case
After hurricanes Irma and Maria, Atkins, a contractor to the US Federal Emergency Management Agency (FEMA) used Alteryx to blend over a dozen GIS and tabular data sets to predict the extent of structural damage. The model was updated and revised daily to improve the quality of predictions, saving thousands of hours of field work and expanding recovery and reconstruction efforts in Puerto Rico and the U.S. Virgin Islands.
Describe the business challenge or problem you needed to solve
Following hurricanes Irma and Maria, FEMA needed to inspect all impacted buildings within the Special Flood Hazard Area to determine if they were more than fifty percent damaged. Historically, this has been a very labor-intensive process that required a team of two to three people spend an hour at each damaged structure to conduct inspections. The sheer size of the disaster made this an impossible task. It would take several years to get through all the buildings using the traditional process.
The strategy was to use Alteryx to estimate the structural damage that had occurred, prioritize areas that still needed some sort of human inspection, and ultimately reduce the total number of in-person inspections so that the recovery process could begin quickly. Alteryx was used to blend over a dozen data sets and the following variables to predict damage:
- Building style
- Wind speed
- Flood levels
- Elevation levels
- Structure type
- Wind exposure
- Construction quality
Atkins determined that they needed to get three functional groups of teams out to the field quickly. The first team used a geographic information system (GIS) to find the locations of damaged structures. The second team collected the information on the structures, and the third team built the analytics model in Alteryx.
The data that was feeding the model came from very disparate sources. They accessed data from the European Union, NOAA, the National Weather Service, FEMA, and the Army Corps of Engineers. This data was stored in various formats that required cleansing prior to blending, and creation of indices between the data set. Alteryx was used for all of these tasks.
Describe your working solution
Atkins ultimately decided to use the Boosted Regression Decision Tree model in Alteryx. The Engineering Team loved the output from this model as it showed all the variables and which ones were the most important. While many variables were obvious, like building type and roof type, others were less expected. The team could see the relationships between the variables and gather more data if new factors were discovered.
As they got deeper into the analysis, they started to see things that were not quite as intuitive. For example, they noticed the areas that were oriented northeast and northwest on ridge-lines got a lot more damage. The Atkins engineers knew that there were effects from the mountains. That's a well-known factor in wind engineering, however, it would have been almost impossible to quantify given the time available. The model did a great job of illustrating that information.
Describe the benefits you have achieved
At the end of the day, what did all of this accomplish? This project helped over 100,000 people get on the road to recovery more quickly. It cleared a significant hurtle for them as far as rebuilding their structures and it gave the communities information that they really needed to start reconstruction.
They evaluated about 146,000 structures, of which about 30,000 of needed an on-the-ground inspection. The net result was that only about 21% of the total needed further inspection, which saved tens of millions of dollars in the response effort. It also saved years in terms of the amount of time that it will take to recover in some of those communities. It was all made possible because of what they were able to do with Alteryx.
The entire PowerPoint presentation can be found attached below. Additionally, visit thislink to watch the entire recorded session.