Using Moving Averages To Showcase Trends in Power BI

No comments

In this video, I want to dive into trend analysis. Specifically, how you can showcase trends in Power BI really effectively.

The concepts that I run through here are techniques you might have already touched on yourself in the past.

But I wanted to break this tutorial out to showcase how important it is from a visualization perspective to showcase trends in a compelling and effective way.

We are going to dive into how you can create moving averages very quickly around results that you may have already created.

Maybe it’s simple calculations you already have, like your sales, cost, or purchases.

By overlaying a moving average formula combination and utilizing functions like AVERAGEX we can quickly turn a very granular result into an average result.

Once we apply this in our reports, we are going to be able to identify trends which are sometimes far more important to understand well than very detailed and granular information.

We are going to be able to identify trends very quickly using this technique.

For many more business insights for Power BI check out the below course module located at Enterprise DNA Online. There are so many analytical techniques you can utilize!

Business Analytics Series

Sam

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s