Enterprise DNA Learning Summit – August 2019 PREVIEW

REGISTRATION FOR THIS SUMMIT – https://ift.tt/2OPUJOe

FOR MORE DETAILS ON THE EVENT – https://ift.tt/2yMzfH9

Summit is free for all Power BI users.

EVENT DETAILS

Session 1 – Data Model Design Best Practices

Learn how to optimize data
Setup data model structure
Relationship best practices
Unique data model designs
Working w/ multiple tables

Session 2 – DAX Fundamentals

Review the concept of context
Iterating vs Aggregating functions
Understand how DAX works w/ the data model
How to structure and organize your measures

Session 3 – CALCULATE vs CALCULATETABLE

Understand what CALCULATE does in-depth
Start using CALCULATE correctly
When to use CALCULATETABLE
The main differences between these two functions

Session 4 – DAX Formula Combinations

How to scale your development w/ DAX
How to quickly create compelling analysis
Analyze trends and time-based information
Learn to re-use similar combinations of formula

Session 5 – Budgeting Techniques

Learn to deal w/ data at different granularity
Manage a more complex data model
Learn how to create virtual relationships using TREATAS
Review Actuals vs Targets overtime

Session 6 – Optimizing DAX Formulas

Learn to structure your formulas correctly
Master the proper syntax and best practices for measures
Understand why your formula is working slowly
Learn auditing techniques to optimize your measures
Understands more deeply how formulas are calculated

View on YouTube

Using ALLEXCEPT To Stop Cumulative Total From Resetting – DAX Solution

In this example we will work through how to use the ALLEXCEPT function to prevent a cumulative total from resetting every time a date selection is change in a Power BI report.

This was a recent question from the Enterprise DNA Support Forum where a member had a real world use case to solve for this particular piece of analysis.

This is a great review of how ALLEXCEPT work within the CALCULATE function when using the cumulative total pattern in DAX.

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

Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI

In this tutorial I run through a unique example that recently came up on the Enterprise DNA Support Forum.

This example looks to solve how to showcase cumulative total comparisons, but to only have one part of the visualization affected by a slicer selection on dates.

This is relevant if you wanted to showcase information or values versus forecasts but you wanted to be able to adjust the date range you are looking at for your actual values and leave your forecasts as they are.

We look to use a duplicate date table to solve for this scenario.

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

Why Using Variables Is A Better Way To Write DAX Measures – Power BI Admin Advice

In this tutorial I run through an advanced formula and how I have used variables effectively to simplify the readability of the entire function.

I talk through why and when I decide to use variables extensively versus measure branching techniques.

In the example I’m working through the logic I included in a recent member-only event focused on project management analysis in Power BI.

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

Create A Gantt Chart In Power BI With A Matrix Visual

In this tutorial, I will work through how you can create a Gantt Chart in Power BI using the matrix visual.

This is a very unique way in Power BI to create a visualization which represents time related information.

We work through how to create the right data model. The advanced DAX formula combination and also how to use conditional formatting inside the matrix visual.

Enjoy learning about Gantt Chart in this particular tutorial.

***** 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 Use Iterating Functions To Solve Total Issues In Power BI – DAX Concepts

In this example I will show you how to solve issues with your total results by using simple iterating functions like SUMX in Power BI.

This is a very good review of how context works in Power BI. This is such a key concept to master when utilizing DAX formulas.

***** 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

Using The Performance Analyzer In Power BI – Model Optimization Tips

In this tutorail we are going to review the new Performance Analyzer feature in Power BI.

We will first review how it works and some of it’s functionality, then I will run through a few optimization ideas for your reports and formulas that should improve performance.

This is a fantastic new addition to Power BI, that will help if your models and calculations are running slow.

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

How To Use The GROUPBY Function In Power BI – DAX Function Review

In this tutorial we will run through how to use the GROUPBY function in Power BI.

This is a similar table function to the likes of SUMMARIZE and SUMMARIZECOLUMNS, but it has some unique nuances to it that are interesting and worth diving into more deeply.

You can use the GROUPBY function in a few ways and I will look to show these to you during this particular video.

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

Custom Conditional Formatting For Power BI Tables

In Power BI we now have a wide variety of conditional formatting possibilites for tables. This wasn’t always the case.

During this tutorial I take you through a range of examples using conditional formatting rules in Power BI.

There is so much flexibility now to complete an almost unlimited amount of conditional formatting.

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

How And When To Use COMBINEVALUES In Power BI – DAX Function Review

In this video we will be covering how and when to use the COMBINEVALUES DAX function in Power BI.

This is not a difficult function to use and is similar to the CONCANTENATE function in excel.

I run through a number of examples to give you a good idea of where this can be used effectively within your development.

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 Staff Turnover In Power BI Using DAX – HR Insights

Recently I created a tutorial around how to calculate the amount of staff an organization has at any one time.

From this I decided to also then calculate the staff turnover calculation.

When you can get both of these results onto one chart you can actually create some compelling insights in Power BI.

You can create to high-quality HR (Human Resources) insights with Power BI.

You’ll learn exactly how to do this within this particular tutorial.

Good luck

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

Conditional Formatting For Chart Visuals In Power BI – What’s Possible?

In this tutorial I wanted to showcase to you some examples of how you can create custom conditional formatting within charts and visuals.

This is a seriously good addition to Power BI functionality, and I’m hoping to give you some inspiration here.

There are almost unlimited ways you can create insights within your visuals no using this feature.

A great video to work through. 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