Tag: Optimization techniques

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

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

VertiPaq Analyzer In DAX Studio | Power BI Tutorial

VertiPaq Analyzer In DAX Studio | Power BI Tutorial

This tutorial will showcase the VertiPaq Analyzer Metrics in DAX Studio and how it helps in optimizing your DAX codes. Every metric will be discussed so that you’ll understand how each can help improve the performance of your codes. This is the VertiPaq Analyzer Metrics. Tables Tab Of The VertiPaq Analyzer The first metric is

Continue reading

VertiPaq Engine In Power BI – Usage & Best Practices

VertiPaq Engine In Power BI – Usage & Best Practices

This tutorial is about the best practices when using the VertiPaq Engine in Power BI. You’ll learn different techniques and approaches to make your DAX calculations perform smoother. To be able to utilize your data models and relationships, you need to set them up in way where you can understand the flow of your calculation.

Continue reading