Complete the following tasks for Mechanic Company that enables analysis of Orders by Calendar, Product, Customer, Order Clerk, and Depot

 

• #1: Use ERDPlus to create the dimensional model

 

• #2: Use SSMS to create the operational database Final_Project and insert the data

 

• #2.5: Use SSMS to create the analytical database A.K.A. data warehouse Final_Project_DW. Show Database Diagram

 

• #3: Use SSMS to create the VIEWS, and SSIS to complete all the ETLs. Show loaded data in SSMS. Number of rows in SSMS should match the number loaded in SSIS

 

• #4: Use Tableau to create  Dashboard that includes 4 WorkSheets to visualize the Orders Analytics
•  

D1 D2 D3 DepotID DepotSize DepotZip DEPOT DepotID DepotSize Depotzip 60611 60660 60611 01 02 03 04 05 ORDERCLERK OCID OCName OC1 Tony OC2 Wes OC3 Lilly 06 07 08 Small Large Large ORDER CLERK OCID OCName DEPOT C1 C2 C3 C1 C2 C3 C1 C2 C3 D1 D1 D2 D2 P1 P2 P3 D3 D3 D2 D2 ProductID ProductName Product Type SupplierID (FK) ORDEREDVIA ORDER OrderID CustomerID DepotID OCID OrderDate ProductID (FK) OrderID (FK) Quantity PRODUCT OrderID OrderDate CustomerID (FK) DepotID (FK) OCID (FK) CUSTOMER CustomerID CustomerName CustomerType CustomerZip ORDER PRODUCT ProductID ProductName ProductType SupplierID BigGripper Tire Traction Wiz Tire SureStart Battery Auto Doc Bo's Car Repair JJ Auto Parts OC1 1-Jan-2013 OC2 2-Jan-2013 OC3 2-Jan-2013 OC1 3-Jan-2013 OC2 3-Jan-2013 OC3 3-Jan-2013 OC3 3-Jan-2013 OC3 3-Jan-2013 Repair Shop Repair Shop Retiailer ST ST BE 60137 60140 60605 SUPPLIER SupplierID SupplierName CUSTOMER CustomeriD CustomerName Customer Type CustomerZip P1 P2 P1 P2 P3 P3 SUPPLIER SupplierID SupplierName Super Tires Batteries Etc ORDEREDVIA ProductID OrderID Quantity 01 P2 P1 P1 P2 P1 P2 ST BE 28899 01 02 03 04 05 06 06 07 07 08 08 4 8 12 4 7 5 8 4 6 6 6 6