Design dimension tables

- [Instructor] Now that we have a data warehouse database … created for KinetEco, it's time to start creating tables. … I'll start with a couple of dimension tables … and in the next movie, I'll create … a fact table to link them to. … Let's suppose that the fact table will be about orders, … two common dimensions or ways … that we might want to aggregate … and group our order data together, … is based off of the date that the orders were placed … and the customers that placed the order. … So I'm going to create a dimension table for dates, … and a second dimension table for customers, … before we do that though, it might be a good idea … to take a look and see how some of the example databases … handle these same types of dimensions. … Let's look in the WideWorldImporters Data Warehouse, … and find a table called Dimension.Customer. … I'll right-click on it and choose Select Top 1000 Rows. … This dimension has a Customer Key … that's the primary key for the table, … it also has a WWI Customer ID which will store …