Tag: Power BI Desktop Data Model

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 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

Power BI Integration In MS Teams

Power BI Integration In MS Teams

In this tutorial, I’m going to highlight how seamless Power BI integration in Microsoft Teams is and how it can change the way you and your team operate on a daily basis. This is the process we’re currently implementing in Enterprise DNA and I want to discuss the advantages of doing the same for your

Continue reading

Financial Year Dynamic Filtering In Power BI Reports

Financial Year Dynamic Filtering In Power BI Reports

In this tutorial, I’ll discuss how to display information based on financial year within Power BI reports. However, this analysis is a bit complex. This is because it has different customers and each of them has a different financial year. You can watch the full video of this tutorial at the bottom of this blog.

Continue reading

Power BI External Tools – Installing Practice Dataset

Power-BI-External-Tools-–-Installing-Practice-Dataset

I want to introduce you to one of the best Power BI external tools that Steven McGuire from the Enterprise DNA forum and I put together to help you with your structured practice. You may watch the full video of this tutorial at the bottom of this blog. I’ve talked a lot about structured practice,

Continue reading