Use
Objectives:
• Get familiar with Data Warehouse.
• Get familiar with QuickSight #AI functions
Data:
• Tickit Diagram (sample Amazon Redshift database), more about data: https://dataedo.com/samples/html/Tick...
Steps:
1. In QuickSight, create a new data set and connect to the Tickit database on Amazon Redshift. The Redshift connection info is posted on Canvas.
2. Join the sales table with the listing table, join the listing table with the event table, and join the event table with the venue table and the category table. Change the venue city data type to city. Exclude duplicated fields.
3. Create a dashboard that can compare the total price listed and the total sold paid, including:
3.1. The sum of the total price paid per month with forecasting
3.2. The number of shows in each category
3.3. The comparison between the total price paid and the total price listed
3.4. The anomaly detection on the total price paid
3.5. The cities with the total price paid
3.6. The growth rate of the total price paid
4. Add an action to enable the bar chart as a filter
5. Publish your dashboard as your_last_name_first_name_lab4.
6. Share your dashboard with the instructor’s QuickSight account.