From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,300 courses taught by industry experts.

Discuss data model cleanup

Discuss data model cleanup - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Discuss data model cleanup

“

- [Instructor] Okay, so in this sub lesson we're just going to go through and talk about some data model cleanup that we can do here. So we have two major options when it comes to doing data model cleanup. Either we can get rid of columns out of the data model so they're no longer physically there. And obviously then nobody will be able to report on them. And we have the ability to hide columns inside of our data models so they cannot be seen at report time. So what I want to do here is I want to focus on our sales table. So our sales table, if you keep in mind just a moment ago in the previous sub lesson, we went and removed the sales territory region from the sales table. And that's because that column was no longer needed in the fact table because there is a sales territory region in the sales territory table that we would use for any filtering. So that got completely removed out of the model in safe space. But there's certain columns here in this fact table that we don't actually…

Contents