Success Story: West gate tunnel
Two of Australia’s largest construction companies
were commissioned by the Australian Government to build a large tunnel.
West Gate Tunnel using Power Automate & Power Apps, Avoiding $1m in Fines and Improving Operations.
Business Challenges
Two of Australia’s largest construction companies
were commissioned by the Australian Government to build a large tunnel.
- Involving multiple tunnel boring machines, 100+ trucks, multiple sites, multiple vendors required up to date and live information on the status of the operation
- Requiring up-to-date management of soil toxicity levels to inform soil dump locations
- Requiring information and sources from GPS devices to locate boring machines, and time stamps via sign ins to locate trucks to link soil sample results to track soil as it moved across the entire operation
- Ensuring that operational efficiency was met with the highest levels of Environmental standards.
What We Delivered
1. Initiate
- Workshops with stakeholders to understand current operations and processes
- Identifying pain points and opportunities
to simplify - Sessions to gather data points across complex vendor systems
- Recommendation of tools and
technology to streamline processes and capture missing data points - Visibility of vendors and their performance in accordance with strict SLAs
2. Build
- MVP development in first iteration
- Solutions evolved as operations matured using new tools, technology, processes
- New user stories captured
after every release - Continuous development to enhance functionality of apps and reports
3. Design
- Azure integration pipeline with a data refresh every 1-2 hours
- PowerApps for business users to simplify operations, and capture missing data points
- Sessions with stakeholders to identify reporting requirements, providing
mock-ups for approval Reporting solution for end-to-end operational monitoring
4. Run
- Showcased apps and reporting functionalities to educate stakeholders
- Developed test scenarios aligned to business requirements
- Worked collaboratively with stakeholders to resolve bug fixes before releasing to production
- Training users on the tools
Benefits
Customer was able to avoid millions of dollars in EPA fines and experienced no bottlenecks – unheard of in the construction, excavation and mining industry.
- No adverse findings when the customer was audited by the EPA (each adverse finding carries a $1m fine)
- Our end to end data/application and reporting solution, was able to provide the client with operational savings of approx. $1M over the life of the project
- The solution was delivered on time ensuring no costly delays in operations (costing millions a day)
- Better governance and monitoring over vendors including monitoring trucking delays, loss of soil between sites by trucks and process failures
- A birds eye view of all operational processes including progress of construction in near real time enabling agile and effective decision making in day-to-day operations.
“"The tool and service Agile Analytics have and continue to deliver is the key component to our strategic success and out of all facets, is by far the cheapest and best performing. Agile have been self-performing and are hoping to be able to replicate their service on other projects within our companies!”
Fully Built on Azure
Power Apps
Power Automate
Azure Data Lake
Azure Data Warehouse
Azure SQL DB
Azure Analysis Services
Azure Data Factory
Power BI
