top of page

Create Your First Project

Start adding your projects to your portfolio. Click on "Manage Projects" to get started

Analytics Pipeline Football API — End-to-End Project (API → BigQuery → SQL Modeling → Looker)

Project

Analytics Pipeline

Date

November 2025

Client

Private

Looker dashboard

Premier League data - Analytics pipeline

Tools

API, Python, Google Big Query, Looker

Premier League Analytics Pipeline — End-to-End Project (API → BigQuery → SQL Modeling → Looker)
Overview

I built a complete end-to-end football analytics pipeline using the API-Football dataset to analyse match, team and player performance in the Premier League.

1. Data Extraction — Python + API-Football

2. Cloud Data Warehouse — Google BigQuery

3. Data Normalisation — From JSON to Relational Model

4. SQL Modeling — CTEs, Transformations & Analytical Views

5. Data Visualisation — Looker Studio

© 2035 by Pablo de la Riva. Powered and secured by Wix 

bottom of page