GitHunt
DR

drahulsingh/Fifa-Dataset-SQL-Data-Analysis

The Fifa-Dataset-SQL-Data-Analysis project uses SQL to explore FIFA player data, analyzing performance and attributes to extract meaningful insights on player statistics, trends, and patterns in football.

csvdatadata-analysisdataanalysisdataanalyticsdatabasedatasetfifafootballfootball-analyticsfootball-dataprojectsqlsql-analysissql-analyticssql-querysqlqueriessqlquerystatistics

Fifa-Dataset-SQL-Data-Analysis

ViewCount

Overview

This project involves analyzing a FIFA dataset using SQL. The goal is to extract meaningful insights from the dataset through various SQL queries.

Files in the Repository

  • Fifa_sql_project.pdf: A detailed report of the project, including the SQL queries used and the insights gained.
  • README.md: This file, which contains information about the project.
  • fifa_sql_project.sql: The SQL script containing all the queries used in the analysis.
  • goal_data.csv: A CSV file containing the FIFA dataset used in the project.

Project Details

Dataset

The dataset used in this project is stored in the goal_data.csv file. It contains various attributes of FIFA players and their performance statistics.

SQL Queries

The SQL queries used to analyze the dataset are stored in the fifa_sql_project.sql file. These queries cover various aspects of the dataset, including:

  • Player performance statistics
  • Team statistics
  • Comparisons between different players and teams
  • Aggregated statistics for specific attributes

Analysis Report

The detailed analysis report is provided in the Fifa_sql_project.pdf file. This report includes:

  • An introduction to the project
  • A description of the dataset
  • The SQL queries used for the analysis
  • Insights and conclusions drawn from the analysis

How to Use

  1. Clone the Repository: Clone this repository to your local machine using the command: 
    git clone https://github.com/drahulsingh/Fifa-Dataset-SQL-Data-Analysis.git
  2. Set Up the Database: Use a SQL database management system (e.g., MySQL, PostgreSQL) to set up the database. Import the goal_data.csv file into your database.
  3. Run the SQL Script: Execute the fifa_sql_project.sql script in your SQL database management system to run the queries.
  4. Analyze the Results: Review the Fifa_sql_project.pdf file to understand the insights and conclusions drawn from the analysis.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Contact

For any inquiries or issues, please contact drahulsingh.

Contributors

DR
MIT License
Created March 21, 2023
Updated February 19, 2026
drahulsingh/Fifa-Dataset-SQL-Data-Analysis | GitHunt