Sqlbi – Optimizing DAX Video Course | Digital Download

Sqlbi – Optimizing DAX Video Course

This video course 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 and 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 Performance Analyzer 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 almost 40 hours of lectures covering the formula engine, the VertiPaq storage engine, DirectQuery over SQL, and composite models. You can watch the videos at any time, and the system will keep track of your progress.

The companion content available to the students includes:

• The PDF version of Optimizing DAX: The book includes a detailed description of all the modules of the video course. You have access to the PDF version of the book, which is also on sale in printed version.

• PBIX files for all the demos
• DAX code for all the demos
• Backup of SQL Server databases to refresh the PBIX files
• BIM file to create Analysis Services databases used for demos with large models

Students have access to a private discussion area where they can interact with the instructors, asking questions related to the lectures and the exercises.

Prerequisites: Students need a good knowledge of the DAX Language, and a previous experience using 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.

Get Sqlbi – Optimizing DAX Video Course at Tradersoffer.forex