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
Sign up now for the meetup here: https://www.meetup.com/en-AU/powerbi4enviros - and if you have ideas for a future session then please let us know at info@discoverei.com .
Power BI Training Courses
If you’re interested in learning from our team, then we have a range of 2-day Power BI training courses available to fast-track your Power BI journey.
Click on the links below to learn more, and get in touch with the team today!
Purchase Training
Do you want to learn how to design engaging and intuitive Power BI reports, which communicate your key insights at a glance and tell your data story?
Our two-day Power BI training course is designed specifically for Power BI Professionals and Data Analysts, and provides our best practice tips, tricks and hacks to help you transform your data! We provide this course online, in-person group sessions, or customised in-house training for your team. Places are limited (max 8 participants per class) so secure your spot today!