Dredge Dash: A real-time dredging project management tool harnessing Power BI
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.
September 2023: Session summary
Dredging projects are critical to maintaining or establishing navigational access to ports, waterways and maritime infrastructure. Engagement and reporting to various internal and external stakeholders are required for these unique projects. Dredging project data collection and reporting can be timely and cumbersome.
Swash selected Power BI to develop an interactive dredging dashboard to provide a ‘one stop shop’ for monitoring dredging projects. Real-time data could be monitored in the form of vessel location and camera images, as well as tracking historical activities through vessel track plots and heat maps. Dredge Dash eliminates the need for manually creating daily, weekly and close out reports in MS Word and PDF format in order to streamline internal and external stakeholder communications.
This session focused on many different tools used across the Microsoft Stack to bring all this information together into one Power BI dashboard, including: Logic Apps; Azure Functions and Azure SQL DB; SharePoint Excel files; and Power BI (the hero) which brings it all together, including our favourite custom visuals Icon Map, Map Box and HTML Content to bring the data to life!
🎦 Check out the full event recording here 🎦
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!