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

Session 3 – Ranking Insights Tips

Using either RANKX or TOPN in Power BI enable some fantastic insights. During this workshop we’ll be running through many variations where you can utilize these DAX functions to enable great analysis. Covered will be the key differences but also the best times to use each of these ranking formula concepts.

• Learn the versatility of ranking formulas with DAX
• Understand the possibilities with ranking functions
• Delve into the nuances of these important functions
• Create unique visualisations with ranking techniques

View on YouTube

FOR MORE DETAILS CLICK HERE – https://ift.tt/2q8z6Ni

Details of what will be covered below

Session 1 – Virtual Table Exploration

– Understand what virtual tables are in Power BI
– Create dynamic data groups within formulas
– Discover advanced insights fast with DAX
– Explore the limitless possibilities with virtual tables

Session 2 – Dynamic Grouping Concepts

– Learn why you should use this analytical technique
– Discover new ways to create groups for your data
– Uncover valuable insights using these ideas
– Group various dimensions from your data model effectively

Session 3 – Ranking Insights Tips

– Learn the versatility of ranking formulas with DAX
– Understand the possibilities with ranking functions
– Delve into the nuances of these important functions
– Create unique visualisations with ranking techniques

Session 4 – Developing Enterprise Apps

– Learn how to build effective app workspaces
– Scale the Power BI online service within your teams
– Manage multiple different reports and insights effectively
– Refresh your enterprise distribution strategies for insights

View on YouTube

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

When is it?
October 15th, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 16th, 7am Sydney (AEDT), 9am Auckland (NZDT)

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:

– Learn how to combine many different DAX functions together
– Solve unique analytical scenarios with DAX patterns
– Understand how to use the CALCULATE statement
– Master ‘measure branching’ techniques

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

View on YouTube

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

When is it?
October 13th, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 14th, 7am Sydney (AEDT), 9am Auckland (NZDT)

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:

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

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

View on YouTube

In this video tutorial, I showcase how you can work out a dynamic monthly calculation.

This is perfect for a CRM scenario where you may want to dynamically calculate a monthly sales forecast for the remainder of the month.

In this example, we use the DATESBETWEEN function, which enables us to open up a dynamic date window.

Enjoy working through this one.

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

TO DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/2I5zFxw

Workshop Session Topics:
– Advanced DAX formula techniques
– Measure Branching
– Time Intelligence calculations
– Moving Average formulas
– Cumulative Total formulas
– Visualization techniques
– and others

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

Where is it?
Join in from your laptop/desktop

How long is it?
Session will run for between 45 – 60 mins

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

Why should I be there?
To learn how to harness the real analytical power behind Power BI.

View on YouTube