Sqlbi – Optimizing DAX Video Course

Description

Optimizing DAX Video Course download , Sqlbi – Optimizing DAX Video Course review , Sqlbi – Optimizing DAX Video Course free

Sqlbi – Optimizing DAX Video Course

This is the video course version of the Optimizing DAX workshop. It teaches you how to optimize queries and measures in DAX.

DAX is the native language of Power Pivot for Excel, Power BI Desktop and SSAS Tabular models in Microsoft SQL Server Analysis Services. This video course is aimed at users of Power BI, Power Pivot, and at Analysis Services developers who already know the DAX language and want to learn how to optimize DAX formulas and models for improving performance.

The goal of the video course is to enable you to find bottlenecks in DAX calculations using tools such as Profiler and DAX Studio, providing the knowledge to improve the performance by using different DAX formulas or by changing the data model, when required. The video course is made up of over 10 hours of lectures, plus another estimated 8 hours of individual exercises. You can watch the videos at anytime and the system will keep track of your progress. Within the video course you can download the material for all the exercises.

Prerequisite: Attendees need a good knowledge of the DAX Language, and a previous experience using either Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular. You may acquire this knowledge by following the Mastering DAX Workshop, or by having equivalent real-world experience.

Curriculum

Presentation of Optimizing DAX
Presentation of Optimizing DAX

Exercises, slides, and demos
How to download and complete exercises
Exercises download
Demos download
Slides of the video course

VertiPaq storage engine
VertiPaq storage engine
VertiPaq in-memory columnar database
What is VertiPaq?
Run Length Encoding (RLE)
VertiPaq compression
Segmentation
Data memory usage
Materialization in DAX
Storage internals
Relationships
Reduce dictionary size
Hands-on labs
Lab 1 – Exercise 1 – Understanding information about a model
Lab 1 – Exercise 1 – Solution

Measuring performance
Measuring performance
Tabular query architecture
Two engines
SQL Server Profiler
DAX Studio
Gathering counters
Understanding data caches
xmSQL syntax
Filter
Lab 2 – Exercise 1 – Simple grouping
Lab 2 – Exercise 1 – Solution
Lab 2 – Exercise 2 – Simple filters
Lab 2 – Exercise 2 – Solution
Lab 2 – Exercise 3 – Basic time intelligence
Lab 2 – Exercise 3 – Solution

Analyzing query plans
Analyzing query plans
SUMMARIZE
ADDCOLUMNS
Multiple measures
Cache
Storage engine features
CallbackDataID
Measuring MDX
Lab 3 – Exercise 1 – High value countries
Lab 3 – Exercise 1 – Solution
Lab 3 – Exercise 2 – Sum of similar measures
Lab 3 – Exercise 2 – Solution
Lab 3 – Exercise 3 – Context transition
Lab 3 – Exercise 3 – Solution
Lab 3 – Exercise 4 – Counting invoices
Lab 3 – Exercise 4 – Solution

Optimizing large models
Optimizing large models
How many rows do you have?
SUM or SUMX?
Optimizing degenerate dimensions
Dimension bottlenecks

Advanced optimizations
Advanced optimizations
Introduction
Division by zero
Filter materialization
Optimizing IF statements
Column filters vs table filters
Currency conversion
Lab 4 – Exercise 1 – Open orders
Lab 4 – Exercise 1 – Solution
Lab 4 – Exercise 2 – Optimizing if-then-else
Lab 4 – Exercise 2 – Solution
Lab 4 – Exercise 3 – Currency conversion
Lab 4 – Exercise 3 – Solution
Lab 4 – Exercise 4 – New customers
Lab 4 – Exercise 4 – Solution

Optimization examples
Optimization examples
Introduction
Events in progress
New and returning customers

Conclusion
Conclusion

WHAT IS INCLUDED

75 VIDEO LECTURES
This video course contains 10 hours of training, for a total of 75 lectures. Our training platform tracks your progress and resumes the course from where you left off.
The course is accessible on desktop and mobile browsers for 36 months after the purchase date.
The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.

SAMPLE MATERIAL
You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.

EXPERT TRAINERS
In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.
TAUGHT BY Marco Russo
TAUGHT BY Alberto Ferrari

TRAINING PLATFORM

TRANSCRIPTS
Along with subtitles, you can view a transcript of the content of each lecture in different languages.
The transcripts are synchronized with the video and you can easily jump from one segment to another.

STUDENT RATING

Alexander Feygin 

I guess I’ll continue buying your couses even when i’ll stop using Power BI.

Paweł Zieliński 

Hi Alberto, Hi Marco. That was very interesting course. I learned a lot. Thanks to that I have now completely different view on DAX and opimization process. Thanks!

Alexey Zidymakov

This is a great course. Thanks!

Commonly Asked Questions:

1. Business Model Innovation: Acknowledge the reality of a legitimate enterprise! Our approach involves the coordination of a collective purchase, in which the costs are shared among the participants. We utilize this cash to acquire renowned courses from sale pages and make them accessible to individuals with restricted financial resources. Our clients appreciate the affordability and accessibility we provide, despite the authors’ concerns.
2. Optimizing DAX Video Course 

• There are no scheduled coaching calls or sessions with the author.
• Access to the author’s private Facebook group or web portal is not permitted.
• No access to the author’s private membership forum.
• There is no direct email support available from the author or their team.