Football players data analysis from top European leagues including dataset, SQL queries, Tableau dashboards, and R analysis.
Football Players Database — Project Summary
Project Goals
This project was developed as part of my learning journey in the Google Data Analytics Certificate. The main goals were:
- To build a clean and structured football players database using spreadsheet logic;
- To explore and analyse the data using BigQuery (SQL), Tableau, and R;
- To publish and document the project as a public portfolio item.
Note: This project is purely educational and has no commercial purpose.
Project Structure
The data is stored in Google Sheets, divided into different sheets linked through relational IDs:
- Intro — general overview, data sources, and season scope
- Competitions — list of competitions with unique IDs
- Clubs — club information (name, competition ID, club ID)
- Players — main dataset with player-level details
The structure follows a relational logic between competitions, clubs, and players, allowing for clean queries and scalable analysis.
Season Scope
- The dataset refers to the 2024/2025 season;
- Data was collected in June 2025 and reflects final squads after the season ended;
- Summer 2025 transfers are not included.
Players Sheet
The Players sheet includes key player-level data such as:
- Shirt number, date of birth, height, weight, position
- Preferred foot, market value, contract end date
- Information about loans, academy background, and international experience
Each column is clearly named and structured to facilitate analysis.
Tools and Platforms
- Google Sheets — for database creation and cleaning
- BigQuery — for SQL-based exploration (with comments included in each query)
- Tableau — for interactive dashboards and visual insights
- R & R Markdown — for additional data processing and reporting (with a full R Markdown script documenting the process)
Access Links
- Dataset on Google Sheets: https://docs.google.com/spreadsheets/d/e/2PACX-1vQFndawZTYLGlhwrNH4dvSXpcqV-nUeN3cWUgRW-WMPYxwpsWstoBHesmR9hF592z-ts7OgBfQyZMJa/pubhtml
- Google BigQuery Dataset Access: https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1stop-leagues-player-database!2stop_leagues_player_database
- Tableau Web Access: https://public.tableau.com/app/profile/gon.alo.cravo/viz/TopLeaguesPlayerDatabase/Dataset
Contact
For questions or suggestions, feel free to reach out via my GitHub profile.
Thank you for visiting the project!