FIFA Teams Data Analysis Using MySQL

Project Overview

This project analyzes FIFA Teams data using MySQL Workbench and SQL.

Objectives

• Analyze team performance
• Identify top attacking and defensive teams
• Study possession and discipline statistics

Dataset

• Source: Kaggle FIFA Teams Dataset
• Records: 48 Teams
• Attributes: 136 Columns

Tools Used

• MySQL Workbench
• SQL

Analysis Performed

1. Top 10 Teams by Goals
2. Top 10 Teams by Assists
3. Top 10 Teams by Possession
4. Teams with Most Yellow and Red Cards
5. Best Goalkeepers by Save Percentage

Key Insights

• Identified top attacking teams based on goals and assists.
• Analyzed possession trends across teams.
• Evaluated team discipline using yellow and red card statistics.
• Measured goalkeeper performance using save percentages.

Skills Demonstrated

• SQL Queries
• Data Analysis
• Data Cleaning
• Aggregation Functions
• Sorting and Filtering
• Sports Analytics