Tag: Power BI

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?
September 4th, 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (GMT)
September 5th, 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

Revenue Forecast Techniques For Project Data – Power BI Insights w/DAX

Posted on by Annie D

When working with project data in a lot of cases, you are dealing with information in the future.

In this tutorial, we work through how you can project revenue into the future based on future project data.

I showcase how to set up the model and also what DAX formulas to utilize to run this piece of analysis.

Enjoy working through 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

Calculate Days Of Zero Stock – Inventory Management Insights w/Power BI

Posted on by Annie D

Recently we had an interesting request on the Enterprise DNA Support Forum where a member needed to workout the number of days their inventory stock levels were at 0.

The technique required to work this out was unique because of the data set up that the member had.

Some different DAX formula techniques were used to solve this.

Enjoy working through 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

Enterprise DNA Learning Summit – August 2019, Optimizing DAX Formulas

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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