Tag: Data Modelling

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

Junk Dimension: What Is It And Why It’s Anything But Junk

Today, I want to talk about a data modeling concept called junk dimension. From its name, you’d think it’s a technique that’s derogatory and something you’d want to avoid, but it’s actually a useful approach. In fact, I worked on a question from the Enterprise DNA support forum, and a junk dimension was the perfect

Continue reading

Column From Examples Power BI – Power Query Tutorial

Column-From-Examples-Power-BI-–-Power-Query-Tutorial

For today’s blog, I want to share my favorite feature inside the Power Query Editor, by far, which is the Column from Examples Power BI. You can watch the full video of this tutorial at the bottom of this blog. When I look at my data sets now, I always think about how I can

Continue reading

Power BI Data Transformation and Setting Up Models and Relationships

Power BI Data Transformation and Setting Up Models and Relationships

In this tutorial, I’m going to show you how I set up my models and the relationships in it. Creating a seamless flow around Power BI data transformation can greatly improve the report development process, and the way you set up your models is a primary contributor to this flow. To clearly portray my Power

Continue reading

Data Modelling In Power BI: Tips & Best Practices

Data Modelling In Power BI: Tips & Best Practices

In this tutorial, you’ll learn valuable tips and best practices for data modelling in Power BI. You can watch the full video of this tutorial at the bottom of this blog. This is one of the four pillars of Power BI report development and is a proven method to develop reports with ease. Honing in

Continue reading