8) Write the SQL that will be needed to answer the three most important questions using your data warehouse. This requires writing 3 SQL statements. (10 points)   9) Create a visualization for your f

The complete SQL needed to address management’s key objectives using the fact and dimension tables of the data warehouse are created along with a description of the results suitable for presentation to management.

A detailed project report should be submitted on the due date. This project is to be done individually. This may require additional reading and research.

This project will require more than 24 hours of work time to complete.

To complete assignment, you should complete the following activities:

1) Review the management questions you developed carefully.

2) For each question identify the fact and dimension tables needed.

3) Complete the activities listed below under submission requirements.

Assignment Resources 1) The populated database that implements the DW from Milestone 2.

2) The management questions for most competitive advantage from Milestone 1.

3) Review of Chapter 13; 4) Recorded lecture slides on Chapter 13; https://www.coursehero.com/file/35107893/Project-2-Milestone-3pdf/This study resource was shared via CourseHero.comBusiness Situation Description:

You work for a large corporation that has just purchased 2 hotel and resort corporations each consisting of over 100 hotels. You have created a DW for the situation and now need to demonstrate that it works by creating the queries needed for reports and visualizations.

Submission Requirements (start with #8 to pick up where M2 ended with #7) When completed, please upload your documents under the “Assignments” tab in Canvas. Please use a document naming convention that allows us to determine your name. EXAMPLE:

“LastName_FirstName_Project2Milestone3.docx”.

8) Write the SQL that will be needed to answer the three most important questions using your data warehouse. This requires writing 3 SQL statements. (10 points) For each question, show the query and sample results of executing the query using your implemented database from Milestone 2.

These sql statements should use the ROLLUP/CUBE features of SQL for processing dimension data.

This script is from the textbook has sample rollup and cube SQL: DW-OLAP-SQL.txt 9) Create a visualization for your first management question.

(Note: Figures P13.3.2G (page 615) and P13.3 (page 616) show single fact tables with multiple dimensions.

This assignment provides an opportunity to demonstrate the value of your data warehouse from Project 2 Milestones 1 and 2. It involves exporting data from your data warehouse to Excel (or Tableau or other graphing package of your choice), then using the graphing tools to create simple visualizations of your data.

Simple visualizations are excellent for communicating effectively with users and managers.

Submit a picture of the visualization embedded in your submission document followed by a short description (2-3 sentences) that explains the visualization for the intended user. (5 points) 11) Create a visualization for your second management question. (Note: it must be different than the first and ideally use different fact or dimension tables).

Submit a picture of the graph embedded your submission document followed by a short description (2-3 sentences) that explains the visualization for the intended user. (5 points) 12) Create a third visualization, it must be different than the first two and should use different fact or dimension tables.

Submit a picture of the graph embedded in your submission document followed by a short description (2-3 sentences) that explains the visualization for the intended user. (5 points) https://www.coursehero.com/file/35107893/Project-2-Milestone-3pdf/This study resourcewasared via CourseHero sh.com Powered by TCPDF (www.tcpdf.org)Assessment Your submission document will be checked for correctness and completeness.

Connecting Assignments This milestone takes the populated database for the DW from milestone 2 and uses it to produce reports and visualizations that answer the questions from Milestone 1. It is the final step that demonstrates the value of implementing a DW.