Using Power BI to track the recent floods across eastern Australia
Using Power BI to track the recent floods across eastern Australia

For our December 2022 session, we were lucky to have Matt Allington (Microsoft MVP Data Platform - Sydney, Australia) joining us again to share his Power BI report presenting streamflow data from the most recent October floods that impacted much of Australia. Matt has been posting daily updates about impacts to the Big Bend region through his YouTube channel, which you can keep up-to-date with on his YouTube channel (Excelerator BI YouTube)

Our thoughts remain with anyone that has been or is being impacted by these devastating floods, especially those within our meetup community❤️ !

Read More
Meetup Group, Power BIAlice DrummondDiscover EIMeetup, Learning, Sharing, Empowering, EnvironmentalComment
How to calculate the likelihood of future dam storage volumes in Power BI using PERCENTILEX
How to calculate the likelihood of future dam storage volumes in Power BI using PERCENTILEX

This video is part of DiscoverEI's DAX for Enviro's series, and walks through an example of how to use Power BI for water resource management. We show how to calculate the likelihood of different dam storage volumes occurring by analysing 120 different modelling scenarios in Power BI using the DAX iterator PERCENTILEX.

Read More
Power BI, DAXAlice DrummondDiscover EILearning, Sharing, EnvironmentalComment
How to analyse dam storage volumes in Power BI using DAX Iterators
How to analyse dam storage volumes in Power BI using DAX Iterators

This video is part of DiscoverEI's DAX for Enviro's series, and walks through an example of how to use Power BI for water resource management. We show how to analyse total system dam storage volumes across 120 different modelling scenarios in Power BI using the DAX iterators: AVERAGEX, MINX and MAXX. We take it to the next level by configuring error bands for the minimum and maximum storage outlook volumes to show the range of possible scenarios.

Read More
Power BI, DAXAlice DrummondDiscover EILearning, Sharing, EnvironmentalComment
How to calculate long-term average rainfall & dynamic moving averages in Power BI
How to calculate long-term average rainfall & dynamic moving averages in Power BI

This video is part of DiscoverEI's DAX for Enviro's series, and walks through how to calculate long-term averages and moving averages for daily rainfall data using DAX in Power BI. We explore the CALCULATE, ALL, ALLSELECTED and DATESBETWEEN DAX functions, and take it to the next level by creating a dynamic moving average analysis using What If parameters.

Read More
Power BI, DAXAlice DrummondDiscover EILearning, Sharing, EnvironmentalComment
Power BI with Will Thompson: Analysing the UN’s sustainable development goals with Power BI
Power BI with Will Thompson: Analysing the UN’s sustainable development goals with Power BI

For our July 2022 session, we had the pleasure of having Will Thompson (Microsoft Power BI Program Manager) present on the recent demo Power BI report from the Gartner Bake-Off Summit. You can also see Will's demo at the Gartner Bake-Off summit here: https://www.youtube.com/watch?v=gGjJ-dY01NA

Read More
Meetup Group, Power BIAlice DrummondDiscover EIMeetup, Learning, Sharing, Empowering, EnvironmentalComment
Explore Sustainable Development Goals in Power BI (Workout Wednesday Challenge)
Explore Sustainable Development Goals in Power BI (Workout Wednesday Challenge)

For our June 2022 session Shannon Lindsay shared a recent Workout Wednesday challenge, where we created a custom theme in Power BI, in an effort to build a report exploring the UN Sustainable Development Goals. This session covered the creation of a custom theme, the use of images and icons, and tips and tricks to customize your Power BI reports.

Read More
Meetup Group, Power BIAlice DrummondDiscover EIMeetup, Learning, Sharing, Empowering, EnvironmentalComment
Real World Power BI: What Size Water Tank do I Need?
Real World Power BI: What Size Water Tank do I Need?

For our April 2022 Power BI 4 Enviro’s session, we had Matt Allington (Australian Microsoft MVP) presenting on his rainwater tank Power BI report. If you want to be good at Power BI, you must get practice. That doesn’t mean you have to practice at work. You can also get practice in at home. In this session, Matt stepped through a process of creating a Power BI report from scratch to determine what size rain water tank is needed for a new property/house.

Read More
Meetup Group, Power BIAlice DrummondDiscover EIMeetup, Learning, Sharing, Empowering, EnvironmentalComment
Global CO2 Emissions: Power BI Story Telling with Pragati Jain
Global CO2 Emissions: Power BI Story Telling with Pragati Jain

In this session, Pragati took us through her Global carbon dioxide emissions public data Power BI report, and how she generated a quick report keeping in mind what insights can be derived from this data. Her version of the report for your interest is available here: https://community.powerbi.com/t5/Data-Stories-Gallery/Global-CO2-Emissions-Analysis/td-p/2313590

Read More
Meetup Group, Power BIAlice DrummondDiscover EIMeetup, Learning, Sharing, Empowering, EnvironmentalComment
Welcome to Icon Map for Power BI
Welcome to Icon Map for Power BI

Working across the environmental industry – it’s fair to say that pretty much ALL of DiscoverEI’s Power BI reports have a map! And if you thought that MapBox was good, well you’re going to LOVE the Icon Map custom visual in Power BI – which allows you to display interactive polygons, points, lines and of course – icons, all in the one visual…plus so much more! To really appreciate how Icon Map can be used to visualize real world data, in this video blog I walk through two real-world applications of Icon Map to visualize environmental data. A big shoutout and thanks to James Dales for creating this awesome visual!!

Read More
Power BI, Mapping, Icon MapAlice DrummondDiscover EIEnvironmental, Icon Map Comments