woensdag 2 november 2016

WorldWideImporters Data warehouse Datamodels

Introduction

Just 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:
  • Order
  • Sale 
  • Purchase
  • Stock Holding
  • Movement
  • Transaction
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.

Order

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)
  • City
  • Date
  • Customer
  • StockItem





Sale

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).
  • City.
  • Date.
  • Customer and BillToCustomer (Customer).
  • StockItem


Purchase

The purchase Fact has the following dimensions :
  • Date
  • Supplier
  • StockItem



Stock holding 

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

Movement

The movement fact has the following dimensions:
  • Date
  • StockItem
  • Customer
  • Supplier
  • TransactionType




Transaction

And the last one, Transaction has the following dimensions:

  • Date
  • Customer and BillToCustomer (customer)
  • Supplier
  • TransactionType
  • PaymentMethod



Conclusion

A simple and overview of the WorldWideImporters demo database of SQL Server 2016.

Greetz,

Hennie

Geen opmerkingen:

Een reactie posten