Date spreadsheet from course

Hi Craig,

I do not know your data set but in a data model you will need need a combination of DIM (lookup tables) and FACT (transaction tables).

I assume that you have a DIM table where you have a row for each customer identified by a customer id, a DIM table for each product identified by a unique product id, and a DIM table for your orders where each order is identified by a unique order number.

Then you need a number of transaction (FACT tables) tables. A FACT table for each transaction you have for each order, product, and customer.

I am sorry but I cannot tell you exactly how you should build your model. You may or may not have to work with more tables.

I assume you will need another FACT table if you have a product price in the product table. You will need a transaction if you change the prices.

I am sorry I am on my way to the airport going on my Christmas holiday. We are happy to help you if you have more questions. If you have more please raise it as a new question. Another trainer will then help you, and if you reference our conversation, the trainer will have a look at this.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector