From the course: Excel Business Intelligence: Data Modeling 101

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Connect multiple data tables

Connect multiple data tables - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Data Modeling 101

Start my 1-month free trial Buy for my team

Connect multiple data tables

“

- [Instructor] Alright guys, time for another really important, really critical lecture. I mean this one's probably top five most important in the entire course, so, pay attention. I wish someone had taught this to me when I was first learning, because it really took a while for me to wrap my head around. So, it's the idea of connecting multiple data tables. Now consider this screen shot of a data model. Looks very similar to ours, in fact it's almost identical to ours except for one thing, which is this returns table. So, in this case we've loaded a second data table named returns which contains records of returns by date, product, and store. So we've got a quantity field in here, which is the quantity of returned products, which differs from the quantity field in the transactions table, which is the quantity of transactions purchased. So one thing you'll notice is that this table can connect up to each lookup table, just like the transactions table did. It's got a return date, it's…

Contents