How much bookings are there per Carrier ? or.Since our model will contain two measures, namely Number of bookings and Flight Price you will be able to answer questions such as You will start to create a dimension view that contains the different Airlines / Carriers. That means you will be able to create different charts that show how much money was spend for bookings for the connection Frankfurt–>New York compared to the connection Frankfurt–>Sydney or that show how much money was spend for flights with a certain airline. In the following you will create four dimension views for Carrier, Customers, Connections and Travel Agencies so that you can visualize our measures Number of bookings and Flight price in relation to these dimensions. Dimensions views are links to various master data, which are later used in reporting as further attributes (according to which different aggregations can be made) and thus make up the versatility of our Analytical Model.
0 Comments
Leave a Reply. |