West Gate Tunnel – Cradle to Grave Power BI Reporting Solution
The "Power BI and Data Analytics for Enviros" meetup group is all about sharing tips, tricks and hacks for analysing, visualising and communicating environmental data. The purpose of this blog is to summarise the key take-aways from the sessions, to help with sharing knowledge, empowering others and creating a strong data culture across our community.
🎦 Check out the full event recording here 🎦
Session summary
Spoil management is an integral part of any construction project. West Gate Tunnel Project provided an opportunity to develop a centralised data management system and hence near real-time reporting Power BI solution to monitor movement of spoil from one site to another. This presentation by the Agile Analytics team focused on operational reporting using Power BI for the construction industry highlighting solutions to address the following challenges:
How key business problems can be solved through reporting.
How key stakeholders can make informed decisions to run successful operations.
How time and money can be saved when information is available at hand.
Follow-up Q&A
There were several unanswered questions from the session which the Agile Analytics team have provided responses to below:
Q: The Apps are historical - did you do any predictive / escalation of issues/ alerts?
A: There were due dates set in system based on sample timings. These were used for reporting red, amber or green flags via reports.
Q: What were your learnings from a data ETL perspective?
A: Extraction of data from multiple data sources: Rrest API, csv and xml files and transformation by data cleansing, deduplication logic development to meet the business needs.
Q: What are the different coloured bins used for?
A: There were inbound and outbound TBMs operating which were extracting soil, and the colours of the bin represented each TBM.
Speakers
Matthew Salmanzadeh, CEO – Agile Analytics
Amrit Kaur, Project Manager WGT- Agile Analytics
Rohan Ingalgaonkar, Senior Power BI consultant – Agile Analytics