IntroductionJust a small blogpost about the data models of World wide Importers data warehouse (WorldWideImportersDW). I just wanted to get an overview of the data warehouse models of World Wide Importers demo database of SQL Server 2016. There seems to be 6 facts:
- Stock Holding
WideWorldImportersDW is the main database for data warehousing and analytics (OLAP – OnLine Analytics Processing). The data in this database is derived from the transactional database WideWorldImporters, but it uses a schema that is specifically optimized for analytics.
This is the order fact of the WorldWide Importers database and there a couple of (role playing) dimensions here:
- Order date and Picked Date (Date)
- SalesPerson and Picker (Employee)
The sales fact contains almost the same dimensions as the order fact. There are a couple of (role playing) dimensions here:
- InvoiceDate and DeliveryDate (Date).
- SalesPerson (Employee).
- Customer and BillToCustomer (Customer).
The purchase Fact has the following dimensions :
The StockHolding is a bit weird fact, in my opinion. I don't why and how but there seems to be one dimension:
- Stock holding
The movement fact has the following dimensions:
And the last one, Transaction has the following dimensions:
- Customer and BillToCustomer (customer)
A simple and overview of the WorldWideImporters demo database of SQL Server 2016.