Football Transfers Analysis in Excel Project
Understand the Economics of Football by Analyzing International Transfers Data in Excel intermediate
With Ned Krastev
Type: Course project
Duration: 3 Hours
This Football Transfers Analysis in Excel project involves extensive data analysis of the intricacies and economic patterns within international football (‘soccer’ in the US) transfers. It delves into the movement of players from one association to another, offering an in-depth overview of the economics of international football.
Using a robust football dataset spanning two seasons (2021/2022 and 2022/2023), the analyst is asked to perform several key tasks in Excel—including data preprocessing and manipulation, filtering, working with Excel functions proficiently, and data visualization.
Students working on this project will map transfers to and from countries across different associations, create summary tables to illustrate these transfers, compute net transfer movements, and obtain the total dollar amounts for the respective transactions.
This Excel project offers a unique opportunity to blend the passion for football with the excitement of data-driven insights, fostering a deeper understanding of the global football economy. Whether you're a football enthusiast, a data analysis student, or both, this Excel project promises intriguing findings and a new perspective on this captivating game. It’s the perfect opportunity to validate several essential Excel skills you learned in the Introduction to Excel course.
- 1 Project file
- Guided and unguided instructions
- Part 1: Database Review
- Part 2: Analyze the Aggregate Number of European Transfers
- Part 3: Analyze European Transfers by Country
- Part 4: Visualize Transfer Fees of Top 5 European Countries