Maven Airlines Challenge

Project Scope

The project scope was to analyze customer satisfaction of a fictional airline company and related causes starting from a single fact table.

Data Model

As I had one single fact table I've use Power Query to get my lookup tables. For analytic purposes I've create a calculated column for age group and , as the fact table had multiple columns for each satisfaction attribute, I've used the unpivot technique to get a second fact table with a single attribute column. This step helped me a lot as I made just one related measure.

As I've created a separate attribute table the final schema was a Snowflake Schema.

Dashboard and Insight

I have done a single page dashboard focusing on:

• Surveys attributes
• Delays and distance
• Satisfaction Level by Attribute

The main insights is that the most of satisfied people belongs to business traveler cluster despite of travel class and arrival/departure delays. Dissatisfied people belongs to economy class customers and personal travel type, showing a big gap with business class.

The In-flight Wi-Fi Service is the lowest rated specially among the business traveler.