Join Gini von Courter for an in-depth discussion in this video How to use the exercise files, part of Learning Microsoft Power BI Desktop (2016).
- [Voiceover] If you have a premium membership to the Lynda.com training library, you can download this course's exercise files from Lynda.com. Then put that downloaded folder, for example, on your desktop after you extract it, like I have right here. Inside the exercise files folder, you'll find four chapter folders for chapters two, three, four, and five that have the downloaded files in them. And you'll use these downloaded files to create data models and reports that you will save locally as Power BI or PBIX files.
This is a little different than other exercise files you may have used. Files created and saved using the current versions of Power BI Desktop and Power BI Desktop Pro do not include the data model. So if you want to work along with the course after you build the model, you will need to save your PBIX files locally. And while you can simply re-save them using the same file name, I will use different names. And at the end of most movies, I'll tell you the name I'm using in case you wish to do the same.
So for example, when we get to chapter three, we'll be using these excel files to create PBIX files that we'll save for use in chapter four. My chapter four folder includes these PBIX files. Your chapter folder will only include them if you create and save them as we go along in the course. So when I open a file, a banner appears on the screen with the file name, for example, AllDates.xlsx.
If you don't have access to the exercise files that we'll be starting with, like AllDates, CatalogRequests, ZipLatLong, and so on, don't let that bother you. You can still work along with me using your own excel tables and CSV files and files downloaded from public data sources like gapminder.org. And in fact, I will tell you where to download ZipLatLong because it's a great file for geospatial mapping. Ideally, if you're using your own files and you want to work along, you have at least one file that includes data that can be summarized, like sales data or populations of states or countries, or the number of employees in different departments.
And you'll have another file that includes valid U.S. zip codes as part of the data table because that's the only way that we can create map visualizations. And of course, you can always simply watch this course without opening any data files whatsoever. Whatever works best for you. Let's get started.
- Installing and launching Power BI Desktop
- Connecting to Excel and CSV files
- Connecting to a database or web data
- Querying data
- Transforming data
- Creating relationship between tables
- Merging data
- Creating visualizations and reports
- Publishing to the Power BI service
- Sharing and unsharing reports
Skill Level Intermediate
Where is the course Power BI Features in Depth as mentioned throughout this course?
Power BI Features in Depth has been retired. Please see instead Learning Microsoft Power BI Desktop.