Football Team Analysis using interactive data visualizations in Tableau

List of files :
Football_Team_Analysis_Tableau.twb : This is a Tableau file which was used for the visual insights used in analysis.
Football Team Analysis.pdf : This file contains final results with insights from the analysis as pdf.

Motivation:
During the transfer market period(June-Aug) of the football, most of the manager need to have the through analysis of the football market to buy in or exchange few players. There are various factors that need to be analysed in order to take the best decision. Here, quick overview of the process for a new manager goes through to buy new players at the team:

1. Analysis of the previous team Performance
   
2. Analysis of the Different Players in the team
   
3. Analysis of the Transfer Market
   
4. Revenue allocation for the process

In this project, I will focus on solving this decision problem for the managers of the football team and provide a thorough analysis of the entire football team with the help of the various IT tools in the market. Here, I will do analysis of the Real Madrid football club which is a Spanish football team participating in the various leagues of the Europe.

Tech Stack:
In this project, I have used several IT tools for the thorough analysis depending on the nature of the work required for the project.

1. Excel for Data cleaning
   
2. Trifacta for Data Cleaning and Pre-Processing
   
3. Tableau for Visual Insights in the form of Stories
   

Methodology:
This projects involved a comprehensive use of technology and tools: Web Data Scrapping: Leveraging web APIs to gather real football data from various European leagues. Data Cleaning: Employing a combination of trifecta and Excel to meticulously clean and preprocess the data, ensuring accuracy and reliability. Insights Visualization: Utilizing Tableau to extract meaningful insights from the data, providing a visually intuitive representation of key performance metrics and player attributes.

Results:
The culmination of our efforts resulted in a series of recommendations aimed at guiding team managers during the transfer market. By systematically analyzing the team's past performance, evaluating individual player statistics, and assessing the dynamics of the transfer market, our project delivered actionable insights. The core outcome was a set of strategic recommendations for managers to consider when acquiring new players.