Data engineering project using UK Bus Open Data Service (BODS) to calculate late buses in real-time for any selected region in England. Prefect, Docker, Terraform, Google CloudRun, BigQuery and Streamlit

Data Engineering project focused on designing a Star Schema for a bus travel agent dataset using Kimball's methodology. Includes ERD creation, identification of slowly changing dimensions (SCD), defining fact tables, and illustrating a Star Schema to support data analysis, reporting, and historical data tracking.