An Airline Company has a reservation system that allows online and offline booking (through travel agents and airline offices). Offices are distributed in different cities all over the countries. Passengers information tracked in the system is name, gender, phone, email, nationality. Booking data are route (source and destination), travel date, booking date, ticket price, and travel class.

The managers are interested to have total sales price and number of booked passengers according to travel month and year, gender, travel class, nationality of the passenger, booking channel and its address, and travel route.

You are asked to: 1. Define the dimensions and hierarchies 2. Define the measures and aggregate functions and write the expression 3. Create an excel workbook that contains the necessary sheets for dimensions and fact 4. Simulate some records for each of the dimensions and 1,000 records for the fact 5. Load the data from the given excel sheet 6. Write expressions to find: a. Sum of prices b. Sum of cost 7. Create List boxes: Year, Month, Country, Root name (Rname), Class 8. Create Pie chart that reflect the total sale price percentage per Route 9. Create Pivot table chart that has 2 dimensions (Route and class) and one expression: sum(price) 10. Create Combo chart that has a. drill down dimension(country cityanameRname class b. Two expressions: i. total price: bar ii. total cost: line 11. Analyze total sales between 2 selected cities reflected over a 12 month period. 12. Apply what if analysis to show the Profit/Loss in case of changing the cost between -10% and +20%