A Power BI data model showcasing a Date Dimension Table (Dim_Date) at the center, connected to two other tables: Facts_Actual Costs and Facts_EVM. The Dim_Date table includes columns like "Date," "End of Month," and "Start of Month." It establishes a one-to-many relationship with the two fact tables. The Facts_Actual Costs table contains various project-related columns such as "Cost Code Level 2," "Forecast," "Lifecycle ID," and more. The Facts_EVM table features fields such as "BCWP - EV," "BCWS - PV," "Phase," and "Project Number." The model demonstrates structured relationships for analyzing time-based metrics across datasets.
A Power BI data model illustrating the integration of a Date Dimension Table (Dim_Date) with two fact tables, Facts_Actual Costs and Facts_EVM, using one-to-many relationships. This structure supports comprehensive time-based data analysis and reporting.