Data Warehouse Plan
Peter Blaney
BI Certification
Solution: NorthwindLite Data Warehouse
Date: 10/27/2014
The
Northwind Lite database, being a very small data collection, is already largely
appropriately structured for a data warehouse. The below table shows the comprehensive data warehouse object definitions.
Data Warehouse Objects Definitions
The only structural modification for the existing data set made between the transactional database and the data warehouse was in integrating the category dimensions into the product table. This was done because the category domain was small and easily integrated under the product table for more efficient analytical processes.
Products Dimension table compiled from the
Products and Category Tables
Once the data warehouse structure was developed for the
existing data, surrogate keys were added for each table, the date/time stamps
were broken up where appropriate, and a date dimension was added to provide analysis functionality by
time period.
Date/Time Stamp added
Date Dimension
Finally, for the customers, a state dimension was added for regional
analysis. Also, a date dimension and current tag was added for when customer contact information
changes.
Customer Modifications
No comments:
Post a Comment