Power BI for Groundwater Professionals
Power BI for Groundwater Professionals
Do you find yourself spending a lot of time manually cleaning and reviewing groundwater datasets, across multiple spreadsheets, only to repeat the same process next month?
Our two-day Power BI training course is designed specifically for Groundwater Professionals, to up-skill you quickly through hands-on exercises using examples which are directly relevant across the groundwater industry. We provide this course online, in-person open session, or customised in-house training for your team. Places are limited (max 8 participants per class) so secure your spot today!
Learn how can Power BI be applied within the Groundwater Industry
In this course you will learn:
How to Get Started using Power BI: A crash-course in Power BI from data import, data modelling, calculations (DAX), visualisations and collaboration, so you can apply to your own projects back in the office.
How to Automate Data Processing: A tour of the Power Query, where we can combine hundreds of CSV and Excel files and automate complex data cleaning tasks such as accounting for limit of reporting values and unit conversions, and connect to regulatory guidelines.
How to Calculate Statistics: An introduction into the DAX language, with practical examples of how to calculate groundwater statistics such as percentiles, confidence limits, standard deviations, moving averages and seasonality.
How to Compute and Highlight Exceedances: Building on the DAX introduction, you’ll learn how to use measure branching to compute groundwater quality exceedances, and more complex functions and iterators such as CALCULATE, TOPN and RANKX, to dynamically highlight the largest exceedances.
How to Visualise Hydrographs and Time-series Data: An introduction into Power BI visualisations, where we’ll create interactive hydrographs and matrices to display trends in groundwater quality and groundwater levels over time.
How to Create Interactive Maps: We’ll explore different mapping visuals to create interactive point, cluster and heat maps to display spatial distributions of groundwater concentrations and levels over time.
How to Create Interactive Conceptual Site Models: Using the certified custom visual Synoptic Panel, we’ll create interactive conceptual site models and connect these with your datasets to dynamically communicate key findings to non-technical specialists.
How to Bring it all Together in Interactive Dashboards: We’ll bring together all the individual pieces into an interactive dashboard, and explain concepts such as edit interactions, tooltips, bookmarks, drill-down, to create a holistic groundwater reporting tool.
How to Share and Report Online: An introduction to the secure Power BI online service, where we’ll publish our groundwater dashboard to the cloud, and show you how to embed your report in SharePoint, Websites, and the Mobile App.
By completing our training course, you’ll be able to take your groundwater studies to the next level - and develop interactive groundwater reporting tools and online dashboards to streamline data processing, analysis and communication, and develop a culture of data driven decision making across your organisation.
Take a look at some of the interactive dashboards you’ll create from scratch!
Click on the images below to interact with the Power BI reports…
Discover how we deliver our training, with a difference:
Designed for Groundwater Professionals: Unlike most Power BI training courses out there which focus on sales, logistics and finance datasets, our training is designed by groundwater professionals tailored for the groundwater industry. Your trainers Alice and Christian , both have close to 10 years experience working across the water resources and contaminated land industries, and are industry leaders in Microsoft Power BI. Alice is a recognised Microsoft Most Valuable Professional (MVP) for her technical knowledge of the Data Platform, and both Alice and Christian are Microsoft Associates in Business Intelligence and Microsoft Certified Trainers in BI Reporting. They work in your industry. They speak your language. They are your data champions!
Fast-tracked Group Learning: Our courses are designed to fast-track your learning. We limit each class to a maximum of 8 people, and have least one trainer per 4 participants. We apply a group learning approach, where participants learn together and help each other. This really improves the retention of material and fast-tracks the program.
Cheat Sheets, Check Lists and Templates: You’ll learn Power BI, in Power BI! We won’t weigh you down with lengthy manuals. We provide PBIX files, cheat sheets and check-lists which are invaluable resources when you get back in the office and are creating your own Power BI projects!
Select your preferred training method:
Virtual (Public): Two-day training (14 hours of content), with structured group learning, exercises and Q&A sessions. Course delivered in Zoom, and available to cater for different time-zones, open to the public.
Virtual (In-House): Two-day training (14 hours of content), with structured group learning, exercises and Q&A sessions for up to 8 participants from your organisation. This allows us to tailor the content of the course to meet your organisations needs, skill levels and areas of interest. You also have the option to mix-and-match content from any of our other Power BI training courses, and select Date / Times to suit your group.
As part of our course, you will receive the following:
Power BI Introductory Videos (Pre-Work) : A series of short videos and example PBIX files will be provided to be completed before the course. These are designed to get everyone up to speed on the basics of Power BI, so we can all make the most of the 2 day training, and focus on the exciting things!
Power BI Files (PBIX): All Power BI files and datasets used in the course will be provided, where individual PBIX files are provided for each module, so you’ll never fall behind.
Power BI Cheat Sheets and Check Lists: Summary cheat sheets and checklists will be provided for each module, to help you follow along and are a fantastic resource when applying Power BI to your own projects!
Ready-made, Groundwater Dashboard: Our four groundwater dashboards that we create together will provide you with an excellent example, directly applicable to your industry, which you can adapt for your own projects.
Power BI Course e-Certificate: On the completion of the course, all participants will receive an e-Certificate to celebrate your achievements. This is a valuable addition to your profession development and CVs!