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.