← Back to Projects

Fixtures & League Standings

Match Results

    Team MP W D L GF GA Pts

    About This Project

    This application provides a dynamic and visually appealing Premier League standings table and match fixtures. Powered by an automated, event-driven ETL pipeline, data is fetched periodically from the Football-Data.org API. Instead of querying the API directly on every user visit, an AWS Lambda function transforms the raw data into structured formats (CSV and JSON) and stores them in an Amazon S3 bucket. This serverless architecture ensures lightning-fast load times, zero backend latency, and complete protection against API rate limits.

    The source code for this project is available on GitHub at the following link: PL Statistics.

    Key Features

    • Automated ETL Pipeline: Scheduled data extraction and transformation running seamlessly in the background.
    • Incremental Processing: Smart data merging that only processes new matches to optimize performance.
    • Zero Latency: Frontend fetches pre-computed static files directly from Amazon S3 for instant rendering.
    • Multi-Output Generation: Simultaneously generates clean JSON for fixtures and CSV for standings.

    Technologies Used

    • Frontend: HTML5, CSS3, JavaScript (Fetch API)
    • Backend: Python (Pandas, Boto3)
    • Cloud: AWS Lambda, Amazon S3, AWS EventBridge
    Decoupled Serverless ETL Pipeline Design

    Figure: Decoupled Multi-Output ETL Pipeline Architecture