Tag: Best Practice Tips For Organizing Your Data Models

Power Query Best Practices For Your Data Model

BEST PRACTICES FOR DATA MODEL

Power Query is used to prepare each of the tables loaded into the data model. Hence, it’s fundamental that the tables, fields, and measures in the data model should be uncomplicated and user-friendly. In this tutorial, let’s talk about some Power Query best practices for our data model, some of its features, and why we

Continue reading

Power BI Data Model: A Comprehensive Overview

The second pillar of Power BI development is data modelling. In this tutorial, you’ll learn about all the important things to consider when it comes to setting up your Power BI data model. What follows is a comprehensive overview on data model development best practices. Organizing Your Power BI Data Model 1. Star Schema One

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 a way where you can understand the flow of your

Continue reading

DAX Calculations In Power BI: Best Practices

DAX Calculations In Power BI- Best Practices

This tutorial will feature the best practices for DAX calculations when developing reports in Power BI. You can watch the full video of this tutorial at the bottom of this blog. DAX calculations are one of the four pillars of Power BI development. In this post, you’ll learn tips on how to maximize your DAX in order to obtain

Continue reading

Power BI Datasets: Types And Naming Conventions

Format Data In Power BI Using The Query Editor

In this tutorial, I will discuss Power BI datasets, including data types and the importance of naming conventions. The data used in this example is a resource pack made available for Enterprise DNA members. We want to make sure that when we import this Excel data into our Power BI model, we get an error-free

Continue reading