This project involves analyzing a FIFA dataset using SQL. The goal is to extract meaningful insights from the dataset through various SQL queries.
- 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.
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.
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
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
- 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
- Set Up the Database: Use a SQL database management system (e.g., MySQL, PostgreSQL) to set up the database. Import the
goal_data.csvfile into your database. - Run the SQL Script: Execute the
fifa_sql_project.sqlscript in your SQL database management system to run the queries. - Analyze the Results: Review the
Fifa_sql_project.pdffile to understand the insights and conclusions drawn from the analysis.
This project is licensed under the MIT License - see the LICENSE file for details.
For any inquiries or issues, please contact drahulsingh.