Imagine that you did all the process using the Microsoft ETL (Extract, Transform, and Load) software (called MS-SSIS or SQL Server Integration Services) within MS-Visual Studio to build and populate two tables in a star-schema data warehouse. THESE VIDEOS WILL GO THROUGH ALL THE PROCESS. There is also zipped solution
https://www.youtube.com/watch?v=fnXXytYq9KE&feature=youtu.be
https://www.youtube.com/watch?v=49nHdzaN0nU&feature=youtu.be
https://www.youtube.com/watch?v=x3VECMGhhsM&feature=youtu.be
https://www.youtube.com/watch?v=LJSAXlQYCZo&feature=youtu.be
Answer the questions in 1 page

Submit a 1 page summary report that answers the following questions:
If you were the DW Administrator for AdventureWorks, what other tables would you add to this data warehouse?
Hypothetically, if you were to add your recommended tables (from question #1), what example analyses could be performed using your data warehouse as a source?