Data Warehouses and Dashboards
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. Par