Engineering Homework Help
Engineering Homework Help. Your company wants to merge its old product order data into a new data mart to facilitate analysis.
TEAM ASSIGNMENT
Your company wants to merge its old product order data into a new data mart to facilitate analysis. Your team has been tasked with writing an ETL (extract, transform, and load) code sequence, and executing it on three years’ worth of order data. Your team will produce:
A .csv data file suitable for direct upload to the data mart, to match the data mart format given in the assignment
A Microsoft word memo to the executive team, outlining what you did and what your recommendations are for moving forward. In the Appendix of the memo you will put the SQL code you wrote.
For this project, please do *all* of your programming in My SQL Workbench. A correct answer obtained by using something other than MySQL will not receive credit.