Load the AviationStack data to facts

Before we saw how to incorporate new data from the Internet and load this into a Staging table. The final objective, of course, is to make this data available to our users in the Data Warehouse.

Below you can see the Workflow to incorporate this Staging data into our Data Warehouse

Now that we have this new data available in our Data Warehouse, here is a Workflow to report on it (Flights in 2025):

Below you see the output of the report showing the flights from the year 2025 which were added from the AviationStack data:

We offer the entire Data Warehouse creation and explotation process we seen so far as a service. Please look at our Project DWaas page for more information.