Analyzing Olympics Data with SQL and Python

Learn how to leverage the power of DataLab by combining Python and SQL to load data from different sources, combine them, and perform exploratory analyses.

This training will use an Olympics dataset and then enrich it with country details from a SQL database. Learners will then explore the data, uncovering interesting insights and creating interactive visualizations.

This training is geared towards learners with some background in SQL and some introductory knowledge of Python. It is recommended that they take Joining Data in SQL and Data Manipulation with pandas prior to attending the session.

Key takeaways

• Combine different data sources using SQL & Python using DataLab

• Perform basic exploratory analysis using pandas

• Learn how to use Plotly to easily create interactive visualizations

Materials

• Access to the solution notebook