Uncategorized

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.