Join Gini von Courter for an in-depth discussion in this video Understanding relationships, part of Power BI Features in Depth.
…Before we create some relationships in our data model, I'd like…to talk with you a little bit about what relationships are.…We have two tables in our data model.…The first is a table that includes…request for catalogs from customers and potential customers.…And one of the columns in that request table is the request date.…This table is called the source table.…It's the main table that we're going to be working with.…And now we'd like the ability to look up some information about the request date.…
We know the date, but we'd like to know for example, what…fiscal year that date falls in or what quarter this falls in.…And so we added a related table.…This table is named months in its…original Excel workbook, we've given it another name.…But we'd like to be able to create a…connection between these two tables, so that we say that…the request date that we have in requests can…be found in a particular column in the months table.…Specifically in the first column that is the date.…And so we're going to create the relationship…
AuthorGini von Courter
- Understanding data analysis and business intelligence
- Installing Office BI add-ins
- Searching for online data with Power Query
- Shaping data in the Query Editor
- Connecting to data sources
- Modeling data with Power Pivot
- Enhancing PivotTables and PivotCharts with PowerPoint
- Visualizing geospatial data with Power Map
- Creating and formatting Power View reports
- Sharing your data using Power BI for Office 365
Skill Level Intermediate
1. Getting Started: Self-Service, Power BI, and BI Tools
2. Using Power Query to Get Data
3. Modeling Your Data with Power Pivot
4. Enhancing PivotTables and PivotCharts with Power Pivot
5. Expanding the Data Model in Power Pivot
6. Visualizing Geospatial Data with Power Map
7. Creating and Formatting Power View Reports
8. Creating Other Power View Visualizations
9. Sharing Your Data Using Power BI for Office 365
Next steps2m 59s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
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.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.