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.

Model loading and cleanup

Model loading and 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

Model loading and cleanup

“

- [Instructor] Okay, so the objective of this sub-lesson is to go ahead and do some model cleanup. So some things that I'm going to want to clean up is, if you recall back when we did the sales append, we still have other country sales and United States sales. So at the end of the day, we do not need these two queries to deliver data to the data model 'cause all the relevant data is inside the sales table now. And similarly, we've got product roll up. We no longer really need this table in the data model because the one column inside of product roll up we wanted is now inside of the product query. So I'm just going to click close and apply. Let's load all of our data over into the data model and apply our steps, and we can see here that we've got seven tables. So I want to prevent other country's sales, United States sales, and the product roll up table from coming through into the data model because they're taking up space unnecessarily. So I'm go backward to transform data, and what…

Contents