Complete the following tasks for Mechanic Company that enables analysis of Orders by Calendar, Product, Customer, Order
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Related Book For
Posted Date: