Airline Passenger Satisfaction

I present a data analysis project focusing on airline passenger satisfaction, utilizing Excel to derive actionable insights. The dataset, sourced from Maven Analytics, encompasses over 120,000 entries detailing passenger demographics, flight specifics, travel types, and evaluations of various service aspects.

I structured the analysis following the six phases of the data analysis process:

Ask: Defining the business task to understand factors influencing passenger satisfaction.

Prepare: Collecting and storing the dataset appropriately.

Process: Pre-processing and cleaning the data to ensure accuracy.

Analyze: Examining the data to identify trends and correlations.

Share: Presenting findings through visualizations and summaries.

Act: Providing recommendations based on the analysis.

Through this project, I demonstrate proficiency in Excel for data cleaning, analysis, and visualization, offering valuable insights into factors affecting airline passenger satisfaction.

I have written a detailed tutorial of this project on my Medium account where many people found it effective. Here's the link : Airline Passenger Satisfaction