A comprehensive ELT pipeline for analyzing passenger satisfaction data. Features a modern data architecture with Apache Airflow for extraction, dbt/Snowflake for transformation, Python/Pandas for cleaning, and interactive dashboards for visualization with NextJS.
The Skytrax Global Airlines Analytics Project is an innovative initiative designed to transform how we analyze customer feedback for airlines. By leveraging modern cloud services and industry-standard technology, it offers an end-to-end process for not just collecting reviews but also processing and visualizing the data. This project aims to provide actionable insights into customer satisfaction, operational efficiency, and overall competitiveness within the airline industry, making it an invaluable tool for stakeholders.
With an architecture that meticulously combines data extraction, transformation, and analysis, this project stands out by utilizing the vast amount of information available from customer reviews on Skytrax. It focuses on providing directional insights rather than definitive conclusions, acknowledging the nature of self-reported data. In doing so, it caters to specific user needs while maintaining clarity in data interpretation.
