This project analyzes team performance across the top 5 European football leagues using advanced metrics and interactive visualizations. The goal is to help scouts, analysts, and fans quickly identify tactical strengths, weaknesses, and performance patterns through data-driven insights.
📊 Built entirely in Tableau. Python was used initially only for web scraping from FBref.
🔗 Dashboard Link: View on Google Drive
🔗 Tableau Public Link: Football Capstone Dashboard
-
Team Selector Panel: Interactive sidebar listing all teams in the selected league. Clicking on a team updates the entire dashboard.
-
Team Badge and Name: Clearly displays the selected club’s name and official crest.
-
Recent Form (Last 5 Matches): Shows team’s recent results using colored squares — green (W), red (L), gray (D) — for a quick form snapshot.
-
Top Goalscorer & Assister: Highlights the team's leading scorer and assister, along with their goal/assist totals.
-
Most Common Formation: A visual formation layout is shown on a football pitch, based on the team’s most frequently used setup.
-
League Selector: Dropdown filter allows switching between top European leagues like Premier League, La Liga, Serie A, Bundesliga, and Ligue 1.
-
Scatter Plot – Goals Scored vs. Goals Conceded:
- X-axis: Goals Conceded
- Y-axis: Goals Scored
- Each dot represents a team, with the selected team highlighted in orange.
- Enables quick identification of attacking and defensive efficiency across the league.
- Website: FBref.com (powered by StatsBomb and Opta)
- Scraped Stats Include:
- Goals, xG, Shots, Shots Inside Box, Shot Conversion %
- Goals Conceded, xGC, Defensive Duel Success Rate, Aerial Duel Success Rate
- Possession %, Progressive Passes Completed, Passes in Final Third
- Opponent Passes into Final Third, Crosses Completed
- Most Common Formation
- Top Goalscorers and Assisters (last 5 matches)
- Form over last 5 matches (e.g., 'WWLDL')
- 🇬🇧 Premier League
- 🇮🇹 Serie A
- 🇪🇸 La Liga
- 🇩🇪 Bundesliga
- 🇫🇷 Ligue 1
- Data Collection: Team stats, match results, formations, and player contributions scraped from FBref.
- Data Cleaning: Unnecessary columns removed; data reshaped and formatted.
- Data Integration: Combined multiple FBref tables into a clean Tableau-ready structure.
- Visualization: Built an interactive Tableau dashboard featuring bar charts, scatter plots, and pitch diagrams.
- Focused entirely on team-level analysis, not individual players.
- Provides tactical and statistical context — form, formation, and scoring efficiency.
- Built with clarity and interactivity in mind for fast, actionable insight.
- Add filters for matchweeks or time ranges
- Incorporate xG/xGA, PPDA, and other advanced team metrics
- Enable cross-league team comparison tools
- Data: FBref
- Project by: Meshach Samuel
- Tools: Tableau, Python (for data scraping only)