User Account

All Pages

Examine how data warehouse is created

Assignment Help Business Management
Reference no: EM132752759

Competency

Examine how a data warehouse is created and used to support reporting and dashboarding.

Instructions

You work for a tourism board at a top destination within the United States that among other tasks, sends information out to potential visitors, provides advertising for the destination, sells tickets to local events and parks, and helps drive economic growth by attracting visitors to the region. The market research team for your organization has decided to try and gather more insight into how their ticket sales are impacting the local economy and have asked for your assistance.

The IT team has all of the data from the cash registers to show what tickets have been purchased and when, and the website has also provided reports of sales of different products. The marketing team also has data regarding who has requested information packets to be mailed to them about the local area and then came to visit. Partnerships with several national travel agencies and popular travel booking websites have also provided some great information on shopping patterns, time of year for bookings, and much more.

The teams agree that a new data warehouse might be an option for bringing the information together, but the CEO is historically reluctant to spend money on something other than promoting the destination for fear it won't generate value. Despite this, they are a big fan of graphs, factual data, and other bits of information around the destination.

Your boss has asked you to help contribute to the argument in favor of a data warehouse--as this is going to be discussed at an executive level, you feel a presentation and information packet is the best approach to get your message across.

The questions they are presenting you with include:

What is a data warehouse, and why do we need it? What are the benefits of this technology?

Why would a data warehouse be a lucrative investment for the tourism board?

How would we go about implementing a data warehouse?

What would a dashboard be useful for? What kind of information could it show that we don't already have in separate databases?

The task:

Record a presentation using the screen sharing Webware/software of your choice (an Internet search will reveal many free options). Your presentation can be recorded with your own voiceover and visuals, just as you would if you were giving the presentation live.

Your presentation should outline the benefits of a data warehouse as opposed to only using separate databases in isolation. Show specific examples of how the separate sources of data available today could be brought together to gain insight, and discuss the benefits of an executive reporting dashboard.

Create a summary report to accompany your presentation as a takeaway for your executive management team.

Reference no: EM132752759

Questions Cloud

Ethical dilemma associated with production : Briefly describe the company and its product and the ethical dilemma associated with the production and distribution of its products.
Compute the Taxable Net Income and Income Tax Due : A domestic corporation disclosed to us the following data for the year 2019: Compute the Taxable Net Income & Income Tax Due
Calculate the balloon payment at maturity : Calculate the balloon payment at maturity (Year 5) if the interest rate on this loan is 4.5%.
What current liabilities then the roce of the company will : What Current Liabilities then the ROCE of the company will be? Mr. Ali is a financial analyst working at a well reputed UAE company in Dubai
Examine how data warehouse is created : Examine how a data warehouse is created and used to support reporting and dashboarding.
What was the cash flow to stockholders for the year : What was the cash flow to stockholders for the year? During the last year, My Town Grocers repurchased 500 shares of stock at $13 a share
What entry would John make upon the return of the asset : Tom and John learn that asset is only worth $10,000 (Tom guaranteed $20,000). What entry would John make upon the return of the asset
Seriously environmental responsibility : Identify a corporation that takes seriously its environmental responsibility. In what ways does the selected corporation work to improve the environment?
What is meant by a callable serial bond : What is meant by a "callable serial bond" and why a serial bond issuer like a government might want to "call" a serial bond before it matures.

Reviews

Write a Review

Business Management Questions & Answers

  Predict the company total utilities cost

Meyer Company, which uses the high-low method to analyze cost behavior, has determined that machine hours best predict the company's total utilities cost.

  Complete the line of code to print the below variable

Complete the following line of code to print the below variable to one decimal place. Note, please do not add any blank spaces

  Time value analysis has many applications

Time value analysis has many applications. For example, you use time value of money concepts in valuing stocks and bonds, establishing loan payment schedules,

  Mission statements in the criminal justice system

1. Locate three mission statements in the criminal justice system and describe how it fit into the organizational structure. Which one do you prefer? Why? How are the three different?

  Unmanageables of sustained product innovation

There are three unmanageables of sustained product innovation: segmentalism, rigidity, and coercive control.

  What are the various manufacturing processes

What are the various manufacturing processes and which manufacturing process is most appropriate for a real estate organization and why?

  Interest rates are expected to rise

a. Assuming that he earns 5% on both his current and future savings, how much should he expect to have in savings, when he retires in 20 years? b. If Mr. Poirot plans to withdraw the money in equal annual installments over the 15 years following ..

  Develop a charter for the project including

You are to prepare and submit Assessment 3 as an individual, based on the Virtucon/Globex scenario, and your peer to peer learning from Assessment 2.

  Having a code of conduct for its suppliers

What is your opinion of Gap International's having a code of conduct for its suppliers?

  Determining the two different lotteries

A risk averse individual that has to decide between two different lotteries will always prefer a lottery with less risk. Steven only consumes two goods: X and Y. If X is a Giffen good for Steven, then Y must be a normal good for Steven.

  Perform a k-means analysis

Using the ruspini dataset provided with the cluster package in R, perform a k-means analysis. Document the findings and justify the choice of K.

  Important information about leadership and

important information about leadership and managementdiscuss and defining whether or not there is a difference between

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd