The project was divided into several key steps:
Web Scraping: Utilized web scraping techniques to gather a substantial amount of customer reviews from the https://www.airlinequality.com/ website. This involved navigating through multiple pages, extracting text, and capturing key information such as customer names, review text, dates, and various ratings related to seat comfort, cabin staff service, food and beverages, inflight entertainment, ground service, and value for money.
Data Analysis: With the collected data in hand, I performed in-depth data analysis using Python. This analysis included sentiment analysis to gauge the sentiment of each review and extracting key phrases and subjectivity from the review text. I also calculated statistical measures like mean sentiment polarity and mean sentiment subjectivity.
Power BI Dashboard: To visualize and present the findings,I leveraged the capabilities of Power BI. I designed an interactive and informative dashboard that allows stakeholders to explore and understand the data effortlessly. The dashboard features insightful visuals, such as sentiment analysis breakdown, sentiment trends over time, and key phrases extracted from the reviews, different ratings broken down and sliced by differenr categories. Dashboard lives here: https://www.novypro.com/project/unveiling-insights-qantas-airways-customer-reviews-analysis-power-bi
Key Highlights of the Project:
Over 200 pages of customer reviews scraped from airlinequality.com for 2014-2023 Comprehensive data analysis to uncover sentiment trends and key insights Creation of a dynamic and interactive Power BI dashboard Visual representation of sentiment analysis, key phrases, and more Valuable information to help Qantas Airlines make data-driven decisions to enhance customer satisfaction and service quality. This project showcases the power of data analysis and visualization in uncovering valuable insights from a large volume of customer reviews. It provides a powerful tool for Qantas Airlines to continuously improve and enhance its services based on real customer feedback.