Tag: Power BI

Cluster Analysis Visualization Techniques For Power BI – Power BI Review

Posted on by Annie D

In this break out session from a recent Enterprise DNA Learning Summit workshop, we are diving into how you can showcase data clusters in Power BI.

Not only this we are also showing how these data clusters change through time.

There are many DAX concepts and also visualization techniques discussed during this tutorial.

Enjoy.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Time Based Cohort Analysis – How To Setup Your Data Model In Power BI

Posted on by Annie D

In this example we’re going to work through how you can create time based cohort insights within Power BI.

You need to get a number of development techniques right here to make it all work, including with the data model and also with your DAX formulas.

This is a break out session from a recent Enterprise DNA member only event.

Enjoy working through this advanced analytics example for Power BI.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Dynamically Group Receivables Based On When Cash Is Expected – Power BI Accounting

Posted on by Annie D

During this unique accounting focused example I’m going to showcase how you can create some incredible analysis of your receivables within your organization.

We are going to review some dynamic grouping formula techniques that I believe will amaze you in their ability to showcase information in new and interesting ways.

This scenario can also be referred to as an ‘aged trial balance’

This is also a short break out session from the financial reporting course now available at Enterprise DNA Online.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Create Unique Table Template Designs Within Power BI – Power BI & Financial Reporting

Posted on by Annie D

In this tutorial I will show you how you can create unique table templates for your Power BI reports.

This is a short break out session from the new Financial Reporting course available at Enterprise DNA Online.

This is a high quality visualization technique developed by Enterprise DNA.

Plenty to learn and implement during this one.

We cover the technique but also formula ideas using SWITCH/TRUE logic.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Calculate A Rolling Average In Power BI Using DAX

Posted on by Annie D

In this example I’m going to show you how you can create a dynamic rolling average in Power BI.

This is a unique formula combination that allow you to calculate an average result for any selections or context that you have inside your Power BI reports.

We dive into the AVERAGEX function during this one, which is a very useful iterating function.

Enjoy.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Steps To Mastering Power BI & DAX

Posted on by Annie D

TO VIEW REPLAY & DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/2LINHHM

When is it?
July 10th, Wednesday – 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (GMT)
July 11th, Thursday – 8am Sydney (AEDT), 10am Auckland (NZST)

Where is it? Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay, Founder of Enterprise DNA – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

– The 4 Key Pillars To Any Power BI Development
– My Top, Best Practice Tips For Building Power BI Reports
– Showcase The Power Of The DAX Formula Language
– How To Combine Analytical Techniques To Solve Problems

If you have questions regarding this training, please send it at https://ift.tt/2xDKj94

View on YouTube

How To Create Unique Subtotals In Power BI Tables Using DAX

Posted on by Annie D

I wanted to show you in this tutorial how to create unique subtotals with Power BI.

This actually isn’t possible if you use just the out of the box table visual in Power BI. You need to use a combination of technique developed and refined by Enterprise DNA.

This is a seriously cool technique that opens up plenty of new visual possibilities in Power BI.

Enjoy learning about this one.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

The Main Difference Between ALL And ALLSELECTED – Power BI & DAX

Posted on by Annie D

During this video tutorial I run through the main difference between ALL and ALLSELECTED.

When first starting out with Power BI this can be relatively confusing so the idea here is to make this clearer in your mind when to use either in your Power BI reports and model.

Plenty to learn during this tutorial.

All the best.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

How To Create A Dynamic Headings In Power BI Using DAX

Posted on by Annie D

In this tutorial I showcase how you can create dynamic headings or text inside of a Power BI report.

This technique is not to difficult it just requires a reasonable understanding of DAX and how to utilise it in Power BI.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Posted on by Annie D

You can now add quite unique conditional formatting to visuals inside Power BI.

In this tutorial, I show you how you can combine DAX formulas with this new conditional formatting feature to highlight the last or most recent value in your visuals.

It’s a great technique that is very re-usable.

Enjoy!

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Calculating The Previous High Dynamically In Power BI Using DAX

Posted on by Annie D

In this unique example, we take a look at how you can calculate the previous highest result dynamically in Power BI using the right combination of formula techniques.

This is a great piece of analysis for many scenarios which is certainly worth reviewing and implementing in your Power BI models if it makes sense to.

Good luck understanding all the DAX logic behind this one.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

When To Use TOPN In Power BI – DAX Formula Review

Posted on by Annie D

TOPN is a great DAX function to use in Power BI when you have some internal ranking logic that you want applied to your calculation.

There are many occasions where there is a better formula combination to use than the alternative of RANKX.

There is a lot reviewed around this topic in the tutorial so enjoy!

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube