Intro to DAX: Why should Enviro's learn DAX and how to get started

In this 7-part DAX for Enviro’s blog series, we share common DAX patterns used for visualising environmental data! This first blog introduces the core concepts of what the Power BI DAX language is (it stands for Data Analysis Expression), how we can use it (Calculated Tables, Calculated Columns and Measures), and why it is considered one of the hardest parts of Power BI to learn! In addition to the blog series, we have also hosted a DAX-specific Power BI for Enviro’s session at our monthly virtual meetup, which we would love you to join if you’re interested in hearing about Power BI examples for the environmental industry.

🎦 Check out the video 🎦

JOIN YOUTUBE

Join Meetup

Recommended DAX Resources

As mentioned in the recording there are some AMAZING resources out there to help you with your DAX journey. Here is our pick of the bunch:

Power BI Docs: https://docs.microsoft.com/en-us/dax/dax-overview
DAX Guide: https://dax.guide
SQL BI: https://www.sqlbi.com/
RADACAD: https://radacad.com/new-video-course-dax-and-calculations-in-power-bi
Matt Allington: https://exceleratorbi.com.au/blog/
Chris Webb: https://blog.crossjoin.co.uk/
DAX Formatter: https://www.daxformatter.com/
DAX Studio: https://daxstudio.org/
DAX.Do: https://dax.do/

If you have an environmental DAX challenge that you’d like us to tackle in a future video then please write in the comments below or email the team 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!

Learn more

Purchase Training

Power BI Designers Masterclass

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!

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!

Power BI for the Water Industry

Would you like to learn how to develop interactive water management reporting tools and online dashboards to help foster a culture of data driven decision making across your organisation?

Our two-day Power BI training course is designed specifically for the Water Industry, to up-skill you quickly through hands-on exercises using examples which are directly relevant to water professionals. 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!

Power BI for Environmental Professionals

Do you want to learn how to create interactive dashboards to assess environmental risks, analyse spatial and temporal trends in your datasets, and design infographic style environmental scorecards to visually communicate your findings to stakeholders and decision makers?

Our two-day Power BI training course is designed specifically for Environmental Professionals, to up-skill you quickly through hands-on exercises using examples with practical applications from across the environmental industry. 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!