Title: Design and Implement a Data Mart Part 2: Create a Data Model for a Data Mart using Dimensional Modeling Principles In this part of the project, you will be implementing

the data mart from your data mart ERD. You will be performing Extraction, Transformation, Loading (ETL) tasks to transfer the required data into the fact table and dimensional tables. You will need to create SSIS packages to perform all the ETL tasks necessary. You have all the source data available in the transaction database AdventureWorks. Instructions: 1. Rename the AdventureWorks database inside your SQL Server to AdventureWorks2016CTP3 before starting to work on this project 2. Create a new database called AdventureWorksDM inside your SQL Server. This database will host the fact and dimensional tables 3. Create the packages in SSIS that will create the dimensional and fact tables 4. Here is the list of the tables that serve as the dimensions: a. Dim Product b. Dim Customer c. Dim Date d. Dim Order e. DimSalesTerritory 5. Here is the list of the fact table you will create: a. FactSales/nImportant Notes: • Create a surrogate key for the Dim Order Date table. The surrogate key value will be the same as the date value except you will not have any slashes. For example, if the date is 11/18/2017 the surrogate key value for that date will be 11182017. • The Dim Order Date table should have dates from 1980 until 2050. The month and the year column will contain the month value and the year value of the date. • IsHoliday and HolidayName could be one single date (such as 4th of July) or a range of dates (such as for Christmas, ranging between December 1st until December 25th). You decide which are the holiday dates based on National Holidays within the USA. 3