From the course: Learning Power BI Desktop [Update]
Join today to access over 24,700 courses taught by industry experts.
Clean up data
From the course: Learning Power BI Desktop [Update]
Clean up data
- [Instructor] We have two other data sources that we added to our model that were worksheets in our original workbook. One is called Growth_Rates, and the other is called Countries_by_population. And this gives us some numerical data to have some fun with, some things that we can actually make charts from and stuff like that. So we're going to start with growth rate, and this shows us the fastest and slowest-growing countries, and they are ranked. And then we have a Key column. This key doesn't provide us any uniqueness, so I'm going to begin by removing the column that says Key, and we'll leave the rank because that gives us something. 1 is the fastest growth rate and 100 is much slower than that. So this is our first shot. And I have an issue here that is so strange, that I decided I would retain it and show you about it. Because when this table was brought in, when it was loaded, Power BI decided that the best it could do would be to treat this as text, and I want to show you why.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.