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:
[ Ссылка ]
