ProjectBeta

Football Analytics

Challenging
2 completions
~ 31 hours
New

Gain proficiency in writing complex SQL queries to extract specific information from a database in Python. Develop hands-on skills in filtering, joining tables, and grouping data to perform comprehensive data analysis. Learn to apply conditional logic and utilize subqueries effectively to extract nuanced insight from data. Master the art of code reusability and creating visualizations. 

Provided by

JetBrains Academy JetBrains Academy

About

Football is a data-rich sport, offering opportunities to uncover valuable insights through analytics. This project delves into football analytics using data from the top European leagues. You will explore the data using the data analyst's favorite tools: Python and SQL.  You'll combine both tools to retrieve information from a database and perform data manipulation, analysis, and visualization.

Graduate project icon

Graduate project

This project covers the core topics of the Data Analyst course, making it sufficiently challenging to be a proud addition to your portfolio.

At least one graduate project is required to complete the course.

What you'll learn

Once you choose a project, we'll provide you with a study plan that includes all the necessary topics from your course to get it built. Here’s what awaits you:
Discover the football teams with the most drawn matches in the Bundesliga
Estimate West Ham United's points in the 2014/2015 season
Calculate points earned by teams across seasons with the help of the Python function