Skip to main content

Live Training: Analyzing Ticket Sales Data with Amazon Redshift

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 DataCamp Workspace, 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 DataCamp Workspace

  • Run queries against a Redshift cluster with DataCamp Workspace

  • Perform joins of multiple tables, and grouped aggregate functions to answer increasingly complex questions


  • Slides

  • Access to the code-along notebook

  • Access to the solution notebook

Follow along with this training in Workspace.

Filip Schouwenaars Headshot
Filip Schouwenaars

VP of Engineering—Workspace at DataCamp

Recommended Content

Setting Up Your Python Environment

Learn to install common tools to work with Python, including Anaconda and git.


DataCamp Workspace Live Code-Along

Hands-on session: What is DataCamp Workspace, and how can you use it?


Spend Less Time in Spreadsheets with SQL

Hate wrangling data in spreadsheets? SQL does it better.


Hands-on learning experience

Companies using DataCamp achieve course completion rates 6X higher than traditional online course providers

Learn More

Upskill your teams in data science and analytics

Learn More

Join 2,500+ companies and 80% of the Fortune 1000 who use DataCamp to upskill their teams.

Don’t just take our word for it.