Skip to main content
HomeCode-alongsData Analysis

Analyzing Ticket Sales Data with Amazon Redshift

Using AWS's Amazon Redshift, we’ll be analyzing ticket sales data.
Feb 2023
Code along with us onCode Along

View Slides

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



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 's photo

Zoumana Keita

20 min


Using Joins to Analyze Book Sales in SQL

Learn how to join data together to get it into a state for analysis.
Tim Sangster's photo

Tim Sangster


Analyzing Streaming Service Content in SQL

Learn to join data from multiple sources, and create no-code visualizations.
Justin Saddlemyer's photo

Justin Saddlemyer


Free Trial Performance Analysis in SQL

Learn how to use SQL to analyze marketing data for a free trial of a product
John Brazier-Beckett's photo

John Brazier-Beckett


Analyzing eCommerce Data in Tableau

In this webinar, you'll explore eCommerce sales and shipping data, then build a dashboard to present the results.
Dev Bhosale's photo

Dev Bhosale


Analyzing NASA Planetary Exploration Budgets in SQL

We're using SQL and DataCamp Workspace to explore a dataset on NASA's budget
Richie Cotton's photo

Richie Cotton

See MoreSee More