Northwind-Data warehouse project

>> The Northwind database contains the sales data for a fictitious company called “Northwind Traders” which imports and exports specialty foods from around the world.

>> Employed denormalization techniques to enhance query performance and reduce the need for complex joins.

>> Designed and implemented a dimensional modelling for efficient data warehousing.

>> In this model we have 7 dimensions and 1 fact tables which keep track of the orders sales in our business.

>> Dimensions are (Customer_dim, shipper_dim, ch_price_dim, date_dim, employees_dim, products_dim, suppliers_dim)