Tag: dax studio tutorial

GroupBy In Power BI: An Implied Function In VertiPaq

GroupBy In Power BI: An Implied Function In VertiPaq

This tutorial will discuss about the storage engine and implied GroupBy in Power BI. You’ll learn what’s happening behind the performance and see potential bottlenecks. This will allow you to create ideas and strategies to mitigate those problems for faster DAX performance. The storage engine queries are expressed in a language called xmSQL. It’s not

Continue reading

Storage Engine In Power BI – VertiPaq Operators & Queries

Storage Engine In Power BI – VertiPaq Operators & Queries

This tutorial will discuss about the VertiPaq operators and storage engine queries in Power BI. You’ll learn how operators work behind the calculation and how the storage engine helps you to optimize your DAX codes’ performance. The VertiPaq operators and queries allow you to monitor the execution of each code so that you can improve

Continue reading

DAX Query In Power BI – Logical & Physical Query Plans

DAX Query In Power BI – Logical & Physical Query Plans

This tutorial will discuss about the two DAX Query Plans in Power BI. Query plans affect the DAX’s performance in generating valuable data. They also help in optimizing DAX codes that make your report more compelling. These are the two query plans that are generated by the formula engine: Logical Query Plan Physical Query Plan

Continue reading

DAX Query Structure In Power BI – Two Engines & DAX Studio

DAX Query Structure In Power BI - Two Engines & DAX Studio

This tutorial will be about the DAX query structure and the two engines inside DAX Studio. You’ll see the process behind how your DAX formulas produce results. You’ll also learn how each engine works in your calculation. There are two engines that are responsible for producing data: the formula engine and the VertiPaq storage engine.

Continue reading

VertiPaq Analyzer Tutorial: Relationships & Referential Integrity

VertiPaq Analyzer Tutorial - Relationships and Referential Integrity

This tutorial will discuss the Relationships tab in the VertiPaq Analyzer in DAX Studio. You’ll learn how useful it is in identifying referential integrity violations which slow down your DAX codes. It helps you determine which table or column needs to be optimized and improved. Relationships Tab Tutorial In The VertiPaq Analyzer The Relationships tab shows all

Continue reading