In this workflow, which you can download here , we will create and load the DIM_carrier dimension, which will contain the codes and names of Airlines.

Below you can see the resulting table in our database.

Now that we have our rudimentary Data Warehouse set up, in the next step we will produce a Pie graph showing the airlines that carried most passengers.