Tuesday, August 14, 2018

Creating a Data Warehouse using SQL Server 2012 and SQL Server Data Tools

Scenario
The dataset contains product sales details of a drug store and customers buy products and salespersons sell products.

The model contains 5 dimension tables and 1 fact table. Star schema has been used to model the data warehouse.



No comments:

Post a Comment