Airlines Customer Satisfaction Survey Analysis -- 3
Budget: $30 – $250 USD
Conduct an analysis of airline customer satisfaction survey data to help identify areas for improvement in customer experience. The analysis should summarize satisfaction scores across various service areas, identify trends, and provide actionable insights for enhancing service quality. You may use either Google Sheets or Excel..
Key Requirements:
1. Data Cleaning and Analysis: Clean and organize the dataset, then calculate average satisfaction scores across different service areas (e.g., Seat Comfort, Inflight Entertainment, Leg Room Service). Identify service areas with the highest and lowest scores and filter responses based on customer types (e.g., 2. Business or Personal Travel).
Visualization:
Create a bar chart showing average satisfaction scores by service area.
Include a pie chart displaying the overall percentage of satisfied vs. unsatisfied customers.
Insights Summary: Provide a text box summarizing the key findings, highlighting service areas with the highest and lowest satisfaction and any notable trends by demographic or travel type.
Deliverables:
A Google Sheets or Excel file containing:
A cleaned dataset ready for analysis.
Summary metrics with calculated averages for each service area.
Two visualizations (bar chart and pie chart) with clear labels and titles.
A brief written summary of key insights, located in a text box within the file.
Dataset
Use the "Airlines Customer Satisfaction" dataset from Kaggle, available here - https://www.kaggle.com/datasets/sjleshrac/airlines-customer-satisfaction
Budget: $50
Key Requirements:
1. Data Cleaning and Analysis: Clean and organize the dataset, then calculate average satisfaction scores across different service areas (e.g., Seat Comfort, Inflight Entertainment, Leg Room Service). Identify service areas with the highest and lowest scores and filter responses based on customer types (e.g., 2. Business or Personal Travel).
Visualization:
Create a bar chart showing average satisfaction scores by service area.
Include a pie chart displaying the overall percentage of satisfied vs. unsatisfied customers.
Insights Summary: Provide a text box summarizing the key findings, highlighting service areas with the highest and lowest satisfaction and any notable trends by demographic or travel type.
Deliverables:
A Google Sheets or Excel file containing:
A cleaned dataset ready for analysis.
Summary metrics with calculated averages for each service area.
Two visualizations (bar chart and pie chart) with clear labels and titles.
A brief written summary of key insights, located in a text box within the file.
Dataset
Use the "Airlines Customer Satisfaction" dataset from Kaggle, available here - https://www.kaggle.com/datasets/sjleshrac/airlines-customer-satisfaction
Budget: $50