Sqlbi – Optimizing DAX Video Course

Description

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

Sqlbi – Optimizing DAX Video Course

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!

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Item do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank you for choosing us! We’re so happy that you feel comfortable enough with us to forward your business here.