From the course: Excel: PivotTables in Depth

Unlock the full course today

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

Create relationships between tables

Create relationships between tables

From the course: Excel: PivotTables in Depth

Start my 1-month free trial Buy for my team

Create relationships between tables

“

- [Narrator] One of the best practices in database design is storing data about separate business objects, such as orders, customers, and products, in separate tables. In this movie, I will show you how to take data that is stored across multiple tables and combine them into a single data model. My sample file is 0901 model, and you can find it in the chapter nine folder of the exercise files collection. This workbook contains three worksheets. And they are orders, customers, and products. Let's take a look at the orders table. And I want to point out specifically that the first column order num, or order number, has a distinct value for each row within the table. So there's only one row for order number 1103798. That means if I want to get information about that order, I can type in that number and I will get information about that order and only that order. Two other fields I'd like to point out are customer ID, which contains a value that can be found in the customer's table, and…

Contents