Enterprise DNA Learning Summit – August 2019, Optimizing DAX Formulas

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 6: Optimizing DAX Formulas

During this session we’ll be looking at a number of ideas around improving and optimizing DAX formula that you create. Enterprise DNA has a number of best practices around setting up your measures within your model.

We’ll be covering what steps you should take if you’re finding that your formulas are working very slow. Also, it’s important to gain an understanding of what certain functions are doing when used in combination with each other, so we’ll be reviewing many ideas here as well.

• 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

Enterprise DNA Learning Summit – August 2019, Budgeting Techniques

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 5: Budgeting Techniques

During this session, we’ll be covering a number of high-level budgeting concepts when working in Power BI. These techniques are some of the more advanced modeling and formula concepts that can be utilized in Power BI.

The key in this session is understanding how important it is to structure your model correctly to then simplify the formula logic that you need to write.

• 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

View on YouTube

Enterprise DNA Learning Summit – August 2019, DAX Formula Combinations

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 4: DAX Formula Combinations

When looking to scale your work in Power BI, you want to understand how you can reuse DAX formula combinations throughout your model. The speed in which you can create detailed analysis is significant when you utilize these techniques.

I will be covering techniques such as cumulative totals, grouping, averaging, and more.

• 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

View on YouTube

Enterprise DNA Learning Summit – August 2019, CALCULATE vs CALCULATETABLE

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 3 – CALCULATE vs CALCULATETABLE

With CALCULATE and CALCULATETABLE you have two of the most important functions in the entire DAX language. Understanding how these two functions operate is essential to any advanced analytical work in Power BI.

During this particular session, we will be drilling into the main differences between these two DAX formulas and also when it’s appropriate to use either one inside your calculated logic.

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

View on YouTube

Enterprise DNA Learning Summit – August 2019, DAX Fundamentals

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 2 – DAX Fundamentals

To harness the analytical power behind Power BI, you really need to master DAX. DAX is the formula language which enables you to discover incredible insights into your data.

Throughout the session, we’ll be diving into some initial key concepts that you certainly will want to understand thoroughly when creating reports with Power BI. These include topics such as iterating functions, context, and measure syntax to name a few.

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

View on YouTube

Enterprise DNA Learning Summit – August 2019, Data Model Design Best Practices

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 1 – Data Model Design Best Practices

During this first session, we will be covering aspects of data modeling when working with multiple tables. Getting your model set up correctly in Power BI is absolutely essential to creating a scalable solution.

Enterprise DNA has many best practices to utilize in this particular area. Ideas around how to structure your model and also how to connect the right relationships between your tables.

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

View on YouTube

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