Description
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 a powerpoint presentation.
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.
Grading Rubric
| F | F | C | B | A |
| 0 | 1 | 2 | 3 | 4 |
| No Pass | No Pass | Competence | Proficiency | Mastery |
| Not Submitted | No outline of the benefits of a data warehouse over using separate databases in isolation. | Limited outline of the benefits of a data warehouse over using separate databases in isolation. | Gives developed outline of the benefits of a data warehouse over using separate databases in isolation. | Clearly outlines the benefits of a data warehouse over using separate databases in isolation. |
| Not Submitted | No examples of how the separate sources of data available can be brought together to create insight given. | Gives limited examples of how the separate sources of data available can be brought together to create insight. | Gives developed examples of how the separate sources of data available can be brought together to create insight. | Gives clear, specific examples of how the separate sources of data available can be brought together to create insight. |
| Not Submitted | No discussion of the benefits of an executive dashboard shared. | Limited discussion of the benefits of an executive dashboard shared. | Developed discussion of the benefits of an executive dashboard shared. | Robust discussion of the benefits of an executive dashboard shared. |
| Not Submitted | No key items from the presentation stated or professionally formatted in a summary report. | Few key items from the presentation stated in a summary report. | Most key items from the presentation stated and professionally formatted in a summary report. | Key items from the presentation clearly stated and professionally formatted in a summary report. |
Explanation & Answer
Attached is the progress...i was caught up doing some revsion of a previous work. I will be done in a few hours
Data Warehousing
Name of Student
Institution
Date
Overview
• The process of using the available
information to make informed decision that
will help improve different aspects of an
organization is key to ensure continuous
growth and development
• There are different tools and strategies that
organizations utilize to collect and utilize
data to help in decision making process
• In the case of the tourism organization, it
faces a similar situation of deciding the most
effective tool of collecting and analyzing its
data
• The most effective data collection and
analysis tool that can help improve decision
making process in the organization is data
warehousing
Definition of Data
Warehousing
•
Data warehousing is the process of
integrating data from multiple sources
within an organization for purpose of indepth analysis of the information to help
improve the decision making process
•
The three main process of data
warehousing is data cleaning, data
integration, and data consolidations
•
The information collected from data
warehousing can be used for either
tuning production strategies, operation
analysis, and customer analysis
•
Therefore data warehousing is not a
database, data lake, or a data mart
Why We Need It
• According to the current situation of the organization, the IT team has data from;
❖ Cash registers showing when and what tickets were bought
❖Sales report of different products
❖Inquiries about different packets about local area
❖Shopping patterns and time of the year for bookings among others
• All this information are vital in ensuring that the company gets the right information
about the ticketing sales impact to the local economy
• Data warehousing will help in the process of in-depth analysis of all of this
information in relation to the set objective as well as provide other insightful
information that may help improve different aspects of the organization using the
Extract Transform Lead (ETL)
• It will be very difficult to draw meaningful information using graphs and factual data
Benefits
•
Saves a lot of time because the analytical
process is done automatically in one process
rather than using multiple analysis process and
connections to make meaningful conclusions
based on their findings
•
The process of data extractions ensures that
quality data is extracted for analysis to optimize
accuracy through rapid update of real-time data
•
The process also promotes meaningful data
storage that can be used with upcoming data for
future analysis that will give the organization
insights of actions to take, process to improve,
and changes needed to optimize the operations
of the organization
•
It enhances security of data through a process
of data filtering in removal of unwanted and
possible data with traces of malicious activities
•
Finally, it enables consumers or interested
stakeholder to access meaningful information
about their inquiry
Comparison with other Analytical databases
Application in the Tourism Board
Implementing Data Warehousing
Dashboard Rationale
Conclusion
There you go, please let me know if you need any edits/clarifications
Running Head: SUMMARY REPORT
1
Summary Report; Impact of Data ...
