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 26,000 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

“

All right, so in this sub lesson, we're going to discuss data model cleanup and perform some cleaning tasks to keep our model easier to understand. Okay, so one of the things that we did in the previous sub lesson to help with data model cleanup was removing the sales territory region text-based column from the sales table. So that has already been done. The next thing we want to do here is we're going to look at hiding key columns from all tables in our model view. So essentially what we want to have happen here is we don't want to show the key columns to our end users for report writing purposes. So these columns here that say key, essentially what we want to do if I go to my report view and expand the data preview pane here, I want to go and take a look at any one of these tables and this column here called Customer Key, Product Key, Sales Territory Key, we want to hide those so that people do not see them here at the report level. So keeping in mind this is a report view, this…

Contents