Bronson was recently engaged by DND to optimize a series of Alteryx workflows. These workflows were being used as part of a process to input project data and assumptions into cost forecasting models for Investment Planning purposes. However, DND needed the workflows to be able to generate alternative scenarios in real time during investment planning sessions, and the existing workflows took 4 hours of processing time to update the forecasting model.
Bronson thoroughly reviewed the existing processes and identified a number of opportunities to remove redundancy and streamline the workflows. As a result, the run time required to generate updated models was reduced from 4 hours to under 10 minutes. Consequently, the feasibility of generating alternative scenarios and exploring options during planning sessions has been substantially enhanced.