HDTutorial
EN
Excel Tutorial: How to understand many-to-many relationships | ExcelCentral.com

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Excel Tutorial: How to understand many-to-many relationships | ExcelCentral.com

21,187 views October 28, 2015 11:06

Watch on YouTube
ChannelExcelCentral.com

Description from the creator

This video lesson provides a complete explanation of many-to-many relationships in relational databases and how this applies to Excel 2013.

The lesson begins by explaining what many-to-many relationships are and shows an example schema with Invoice, Product and InvoiceProduct tables. You'll also learn about some common mistakes that are made when modeling many-to-many relationships and how to avoid them.

This video comes from the Data Model, OLAP, MDX and BI session (Session 6 in our Excel 2013 Expert Skills training course).

I’ve written a more up to date (and completely free) overview of OLAP that you can read on this link:

thesmartmethod.com/excel-power-pivot-2-minute-o…

About this tutorial

ExcelCentral.com published this 11:06 video tutorial on October 28, 2015. It has been watched 21,187 times on YouTube.

Category
Education
Duration
11:06
Published
October 28, 2015
Views
21,187
Likes
132

Tags

Share

This tutorial in other languages