Create a data warehouse for a hotel resort

Assignment Help Database Management System

Reference no: EM131768333

Project -

The basis of this project is to create a data warehouse for a hotel resort.

This assignment provides an opportunity to demonstrate the value of your data warehouse from Project Milestones land 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.

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 Pt hart description (2-3 sentences) that explains the visualization for the intended user.

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.

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.

Attachment:- Assignment Files.rar

Reference no: EM131768333

Questions Cloud

Make a normal-quantile plot of the left endpoints : Of the 314 students in the STAT 21 class surveyed, 131 are female. Simulate many different samples of size 91 from the class, and use each sample to construct.

Probability histogram for the hyper geometric distribution : Use a normal-curve approximation to estimate the chance that exactly 38 of the 91 students in the sample would be female.

Compute average birth weight for babies born to smokers : In the Missouri study, the average birth weight for babies born to smokers is 3180 grams and the SD 500 grams, and for nonsmokers the average is 3500 grams.

How has the shape changed from the histogram : Combine the last four categories in Table of the distribution of the number of cigarettes smoked by the smoking mothers in the CHDS.

Create a data warehouse for a hotel resort : The basis of this project is to create a data warehouse for a hotel resort. Create a visualization for your second management question

Find the approximate quartiles of the distribution : Use Table to find the approximate quartiles of the distribution of the number of cigarettes smoked per day for the mothers in the CHDS who smoked.

Describe the different type of topology : Design a network for this company to incorporate a network server, printer and wireless network. Provide a security solution for them. What type of topology?

Discuss about the business of journalism : The Business of Journalism When it comes to news, tragedy is a best-seller the world over. For this assignment, I want you to study the front-pages of newspaper

What is the mass of 6.5 moles of sulfur : How many grams of silver chloride can be produced from the double displacement reaction of 17.0 g silver nitrate with 23.4 g sodium chloride?

Reviews

len1768333

12/15/2017 11:26:04 PM

Please see all the screenshots for the directions for the assignment. This is a 3 part project and Milestone 1-3 are all connected and need to be done in conjunction with one another. All files to what looks like links via the screenshots are all attached. The basis of this project is to create a data warehouse for a hotel resort. I hope this is all the information you need. (Note: it must be different than the first and ideally use different fact or dimension tables). Assessment - Your submission document will be checked for correctness and completeness.

Write a Review

Required(*) Message

User Account

All Pages