Nearly 50 BT employees were trained over a two-week period through a mixture of self-serve learning materials from Alteryx Academy and formal sessions delivered by Alteryx and PwC. The teams then began working in an agile, sprint-guided approach which allowed them to successfully re-platform the 140+ Excel-based cascading models in just over 16 weeks.
Having joined BT to make people’s lives easier through digital transformation and data democratization, Ilya Dronov, Head of Digital Transformation – Group Finance at BT, knew the task at hand would be difficult, especially with the pandemic creating an increasingly virtual environment. He set out to accomplish three major initiatives:
Leveraging the simplicity of building in Alteryx, BT and PwC developed workflows using a set of “golden standards.” This included a standard set of rules around which tools to use, relative paths, ensuring calculations were dynamic, and other conventions to aid teamwork. Using Alteryx servers, BT crunched through millions of lines of data and was able to achieve their first initiative of making regulatory modeling both faster and easier to complete.
Alteryx’s native in-workflow commentary functionality helped BT check off their second initiative – achieving model transparency and simplifying change control and audits. Using Alteryx’s automation diagnostics and PwC’s accelerator tools and expertise in Alteryx Automation, they built model prioritization. The team was able to see workflow building blocks and easily trace calculations from start to finish by color coding workflows and utilizing tool containers.
To accomplish their third initiative, BT embedded links within workflows that led to the relevant documentation within their Confluence instance. This made navigation through workflows seamless for audits, reviews, and handover purposes.
After an additional round of optimization where efficiency improvements were identified within Alteryx workflows, BT reduced over 40% of the workflows within the cascade and published them to the Alteryx Server. They utilized macros to schedule the run sequence and enable automation. With Alteryx and PwC, Ilya’s and the BT team’s vision was fully materialized.
Head of Digital Transformation – Group Finance