Analyzing Ticket Sales Data with Amazon Redshift

Using AWS's Amazon Redshift, we’ll be analyzing ticket sales data.

Feb 7, 2023

Code along with us onCode Along

In this live training, we’ll be analyzing ticket sales data through Amazon Redshift, a data warehouse product that is part of Amazon Web Services.

Even though Redshift’s underlying technology is vastly different from classical relational databases, we can also run queries using SQL. Using DataLab, we will connect to a redshift cluster and start with some initial exploration of the data.

Next, we move on to answering increasingly complex analytics questions using common techniques like joining, grouping, and aggregating the data.

To top it all off, we will create an insightful visualization that shows the highest-grossing events in the dataset. Filip will provide a template workspace for you so you can easily follow along as he’s coding up the model.

Key takeaways

Connect to a Redshift cluster, and browse tables with DataLab
Run queries against a Redshift cluster with DataLab
Perform joins of multiple tables, and grouped aggregate functions to answer increasingly complex questions

Topics

Data Analysis

SQL

Business Intelligence

Data Analyst

tutorial

A Complete Guide to DataWarehousing on AWS with Redshift

This guide to AWS Redshift covers setting up and managing a cloud data warehouse, loading data, running complex queries, optimizing performance, integrating with BI tools, and provides best practices and troubleshooting tips for success.

Zoumana Keita

20 min

tutorial

DynamoDB to Redshift: Three Methods for Migrating Data

Learn three methods to migrate data from Amazon DynamoDB to Redshift, with step-by-step instructions, the pros and cons of each method, and best practices for data integrity and performance optimization.