mayadebanjo/premier_league_analysis

This repository contains a data analytics project focused on 25 seasons of English Premier League football, from the 2000/01 season through 2024/25. The project uses match results and statistics from Kaggle, covering roughly 9,500 matches. The data includes details like match dates, teams, goals scored, referees, shots, cards, and corners. The creator built the project using PostgreSQL for storing and querying the data, pgAdmin for running SQL queries, Excel for initial data cleaning, and Power BI Desktop for building the visual dashboard. The dashboard itself is split across three pages. The first page gives a broad league overview, showing summary numbers like total goals, total clubs, and average goals per match, alongside charts for goals by season, match result distribution, and top scoring or conceding clubs. The second page digs into match dynamics, looking at how games unfold. It covers home versus away goal averages, how often half-time leaders go on to win, which half produces more goals, and the most common final scorelines. The third page is dedicated entirely to Arsenal, examining their performance across the same 25-season span. It tracks their points per season, goals scored versus conceded, home and away records, and how they have fared against their top five rivals: Chelsea, Liverpool, Manchester United, Manchester City, and Tottenham. The project also highlights several findings from the analysis. Arsenal are the highest-scoring club in the dataset with 1,809 goals. Home teams win about 46% of matches. Over 55% of goals are scored in the second half. The most common scoreline is 1-1. Teams leading at half-time win 80% of the time. Arsenal's best season was 2003/04 with 90 points, and their strongest rivalry record is against Tottenham, with 23 wins from 50 matches.