Arizona Analyses
I created this map to more readily identify the water table levels across the state of Arizona. The dataset is available publicly from the Arizona Department of Water Resources. This dashboard highlights the importance of identifying what parameters you want to inspect in a dataset. If looking at average water table depth since the 1940's, then water levels have drastically declined. However, looking at the average water table depth since 1985 water table levels have been increasing. This is likely caused by water conservation policies being put in place as Arizona's population continued expanding.
In the folder below is a forecast 3 years out from when this dataset was last compiled. The visuals below show a SARIMA forecast, and a machine learning polynomial forecast. The Mean Absolute Error (MAE) is also listed for each forecast on the visuals. The project that generated these visuals is at the bottom of this page.
An interesting way to utilize this page is to use the PowerBI map above to identify the water table you are interested in and then investigate the forecasted change in the water table level below.
Arizona Water Basins Forecast
In this analysis I built a SARIMA and Polynomial forecast model for each water basin in Arizona, that had sufficient amounts of data. These models were trained on the previously recorded values of the water table depth. In this case, our forecast will show expected water table levels for the next 3 years based on the previously recorded water table levels for the given basins. In total there are 71 forecasted basins.
The results/visuals are available in the menu above.
Each visual shows the previously recorded values, the forecast values, the MAE for the forecast values, and the trend line for the forecast values.Â
To download the results of this analysis click: Here