Architecture Goal

Design a scalable and maintainable analytics architecture capable of transforming raw Fantasy Premier League API data into structured, interactive Power BI reporting and fantasy football intelligence.

The architecture was designed to separate ingestion, transformation, modelling, semantic logic, and reporting into clear analytical layers for improved maintainability, performance, and reporting consistency.

ChatGPT Image May 7, 2026 at 09_55_39 AM.png

🏗️ End-to-End Data Flow

Fantasy Premier League APIs
        ↓
Power Query Ingestion Layer
        ↓
Data Validation & Cleansing
        ↓
Transformation & Shaping
        ↓
Star Schema Data Model
        ↓
DAX Semantic Layer
        ↓
Interactive Power BI Dashboards
        ↓
Fantasy Football Insights

🌐 Data Sources

The solution integrates football datasets from Fantasy Premier League APIs and supporting football statistical endpoints.

Primary datasets include:

Player statistics
Club information
Fixtures and results
League standings
Player prices
Goals and assists
Minutes played
Form and performance metrics

The APIs provide JSON-based football datasets which are ingested and transformed into structured analytical tables.