Capstone: NFL Offensive Trends 2004-2019

Summary of Project

The purpose of this analysis is to examine what makes an NFL player and team productive by looking at NFL datasets that span from 2004-2019. The two datasets that used were the NFL Player Data from Kaggle and the nflverse data repository from GitHub.

Tools and Steps

The 5 datasets that were pulled from Kaggle were downloaded into Google Sheets and Excel where they were cleaned and re-formatted.

Once the individual datasets were cleaned, they were uploaded into BigQuery to join the five tables together to create one table with the players, teams, and their stats. I also created secondary queries to create tables that looked at specific aspects of the data to answer the purpose of the analysis.

Once I had created all the tables I needed, they were brought them into Excel to create a data source for my Tableau visualizations. I decided to create 4 visualizations: a bar graph and a heatmap that looked at player performance based on 'air' and 'ground' yards; and a bar graph and a combo plot grpah with trend line that looked at team performance based on plays and yards.

After creating the visualizations, I brought in the combined dataset to do an analysis by using R programming.

Findings

Analysis of NFL Offensive Trends (2004-2019)

This browser doesn't support PDFs. Please dowwnload the PDF to view it: Download PDF.

This analysis examined NFL offensive trends from 2004 to 2019, focusing on the balance between rushing and passing. Key findings include:

This analysis provides valuable insights into offensive trends in the NFL, emphasizing the shift towards passing and the complex relationship between individual player performance and team success.

Further Questions

Deeper Dive into the Passing Trend:

Team Success and Player Performance:

Impact on Player Evaluation and Draft Strategies:

Long-Term Trends:

By exploring these additional questions, you can gain a more comprehensive understanding of the evolving NFL landscape and its implications for team management, player evaluation, and the future of the game.