Join Gini von Courter for an in-depth discussion in this video Using lookup tables in a dataset, part of Learn Microsoft Power BI Desktop: The Basics.
- [Voiceover] We're going to create one new dataset,…and this dataset will be created…from three different Excel spreadsheets.…And we're going to begin using lookup tables.…Let me explain this dataset to you.…First, we have three files,…a file of catalog requests from customers.…Then we have a file that is nothing…but breakdowns of dates,…and this file is one that I created for myself in Excel.…It's the type of file that once you create it,…you'll never need to create it again.…
You'll just copy it and use it in a file…each time you need it.…And finally, a file of zip codes and geospatial data,…specifically, longitude and latitude information…that's required if we want to do mapping.…So if we want to be able to visualize dates…more robustly and map data more robustly,…we may need these supporting tables.…Here's how lookup tables work.…We begin with a customer table…that includes columns like First Name, Last Name,…Address, Postal Code, and Request Date.…
And then we add two more tables.…One has latitude and longitude information in it,…
AuthorGini von Courter
- 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
Creating Excel Power Pivot and Power View Dashboardswith Ron Davis1h 12m Intermediate
Data Modeling with Excel Power Pivotwith Ron Davis1h 15m Intermediate
1. Get Started
2. Get Data
3. Model Data: Shaping, Combining, and Merging Data
4. Create Visualizations and Reports
5. Share Your Work
Next steps1m 38s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.