This project features an interactive Tableau dashboard that analyzes airline customer satisfaction and service quality metrics. It provides insights into rating trends, aircraft performance, geographic distribution, and multi-dimensional service quality assessment to support strategic decision-making in aviation operations.
- Analyze overall customer satisfaction across multiple service dimensions
- Track temporal rating trends and identify patterns
- Compare performance across different aircraft types and manufacturers
- Visualize geographic distribution of customer ratings
- Evaluate service quality metrics (cabin staff, entertainment, food, ground service, seat comfort, value)
- Segment analysis by traveller type and seat class
- Tableau
- Data Visualization and KPI Analysis
- Excel / CSV (data source)
- Line Chart: Monthly rating trends over time (2016-2024)
- Map Chart: Country-wise average rating distribution
- Dual-Axis Bar Chart: Aircraft performance with ratings and review volume
- Filter Panel: Interactive controls for metric selection, date range, traveller type, seat type, aircraft, and continent
- KPI Banner: Top-level service dimension metrics
- Download the
.twbxfile from the repository - Open it in Tableau Desktop or Tableau Public
- Use left-side filters to segment data:
- Select service metric (Overall Rating, Cabin Staff, Entertainment, etc.)
- Adjust date range slider
- Filter by traveller type (Business, Leisure categories)
- Choose seat type (Economy, Business, First Class, etc.)
- Select specific aircraft or continent
- Explore insights interactively through charts and map
- Hover over visualizations for detailed tooltips
- Entertainment systems are the weakest area (1.4/10) requiring urgent investment
- Boeing 747-400 leads in customer satisfaction (4.7/10) with 97 reviews
- Significant rating volatility during 2020-2022 indicates pandemic impact
- Recent declining trend in 2023-2024 demands investigation
- Food & beverages underperform (2.4/10) compared to other service dimensions
- Geographic variations show different satisfaction levels across countries
- Airline Management: Identify underperforming service areas and prioritize improvements
- Fleet Operations: Compare aircraft performance for fleet optimization decisions
- Customer Experience Teams: Track service quality metrics and benchmark targets
- Route Planning: Analyze geographic satisfaction patterns for expansion strategies
- Executive Reporting: Monitor KPIs and trends for strategic presentations