Reference no: EM133183958
Data Warehouses and Dashboards
Assignment Content
Examine how a data warehouse is created and used to support reporting and dashboarding.
Scenario
You work for a tourism board at a top destination within the United States that, among other tasks, send 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 gather more insight into how their ticket sales impact the local economy and have asked for your assistance.
The IT team has gathered data from attractions ticket sales to show what tickets have been purchased and when, and each attraction website has also provided reports of sales on 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. Still, 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 will be discussed at an executive level, you feel a presentation is the best approach to get the message across.
Create a presentation that should outline the benefits of a data warehouse and address the following:
Discuss a data warehouse and the benefits for the tourism board?
What is a dashboard, and what kind of information could it help that we don't already have in separate databases?
Provide examples of how business intelligence dashboards can supplement current reporting strategies and discuss an executive reporting dashboard's benefit.
|
Sections of the federal trade commission act
: What purpose does the Federal Trade Commission serve and why must business owners be educated on Federal Trade Commission practices?
|
|
Increase in revenue reimbursement
: Increase in revenue reimbursement through inpatient length of stay and outpatient vendor relationships
|
|
Basic components of a mission statement
: Writing a mission statement requires focus and should inspire not only the employees within an organization but the customers, suppliers and community as a whol
|
|
Determine the amount of the loan outstanding
: If the interest rate on the loan is 12%, perform loan amortization calculation that will allow you to determine the amount of the loan outstanding
|
|
Data warehouses and dashboards
: Discuss a data warehouse and the benefits for the tourism board? discuss an executive reporting dashboard's benefit.
|
|
Define a set of suitable organizational goals
: Read Middleboro Casebook Case #9, Hillsboro County Health Department. The Hillsboro County Health Department (HCHD) is a component of county government, charged
|
|
Defining the competitive environment
: Provide Updated information on Starbucks. Provide an external, internal analysis and recommended strategy per instructions below.
|
|
What amount should be reported as net income
: Taxes of P60,000 for the fourth quarter of 2021 were paid on January 20, 2022 and charged as expense of 2022. What amount should be reported as net income
|
|
What is the balance in the investment in smith account
: Harled Company purchases all of Smith's common stock on January 1, 2018, for $14,520,000. What is the balance in the investment in Smith account
|