Note how 'clean' our Fact table now looks. It only contains fact values and Integer foreign keys to our Dimensions, which allow efficient joining.
The workflow below is a practical use case example of our Data Warehouse. It produces a Bar Chart of passengers carried by Iberia airlines by month in 2024.