Author: Enterprise DNA Experts

Power BI Data Model Optimization With VertiPaq

Power BI Data Model Optimization With VertiPaq - Enterprise DNA

In this tutorial, you’ll learn how to use the VertiPaq Analyzer in DAX Studio to optimize your data model in Power BI. VertiPaq Analyzer is a built-in tool in DAX Studio that extracts meaningful information about tabular models from an optimization standpoint. To launch VertiPaq Analyzer, go to the Advanced tab in DAX Studio. Then,

Continue reading

CROSSJOIN DAX Function: Server Timings & Query Plan

CROSSJOIN DAX Function Server Timings & Query Plan - Enterprise DNA

In this tutorial, you’ll learn how the CROSSJOIN function works in DAX using the Server Timings pane and its query plan. The CROSSJOIN function can be used to create a Cartesian product of two tables. A Cartesian product is a set of all possible combinations of rows from two or more tables. The DAX code

Continue reading

Scatter Plot In R Script: How To Create & Import

Scatter Plot In R Script How To Create & Import - Enterprise DNA

In this tutorial, you’ll learn how to create a scatter plot visualization using an R script. This is based on a report submitted for the Enterprise DNA Challenge #16. You can watch the full video of this tutorial at the bottom of this blog. What Is Scatter Plot A scatter plot is a type of

Continue reading

DAX CALCULATETABLE Vs FILTER Function

DAX CALCULATETABLE Vs FILTER Function - Enterprise DNA

Both CALCULATETABLE and FILTER are powerful tools for manipulating and analyzing data in DAX query, but they have some key differences that are important to understand. In this blog, we’ll go over the CALCULATETABLE function and its query plan in DAX studio, and understand how it differs from the FILTER function. By the end, you’ll

Continue reading

UNION DAX Function Vs Power Query

UNION DAX Function Vs Power Query - Enterprise DNA

In this tutorial, you’ll learn a DAX optimization technique using the UNION function. This tutorial will compare the performance of the UNION function versus Power Query and other techniques for combining tables. The UNION function combines two tables into a single table by combining their rows and removing any duplicate rows. The example in this

Continue reading