An image showcasing a star schema diagram. At the center is the Facts_Activities Schedule table, which contains core transactional fields such as Project Number, Remaining Duration, Responsible, Sub-Contractor/Supplier, T&T Lifecycle ID, Total Float, Variance Finish, Variance Start, and WBS Level 4. Surrounding this central table are dimension tables, each connecting to the fact table. Dimension tables include: - Dim_Project: Fields like City, Portfolio, Programme, Project Code, and Project Name. - Dim_WBS: Includes WBS Code and WBS Name. - Dim_Date: Tracks time-related fields such as Month Name, Date, Start of Month, and End of Month. - Dim_Lifecycle: Contains descriptive lifecycle fields like Full Name, Mid Name, and Short Name. - Dim_Supplier: Tracks supplier-related fields like Contract Terms, Supplier ID, and Supplier Name.
A star schema diagram showing how fact and dimension tables work together for clear and efficient project reporting.