Dashboard Link : https://www.novypro.com/project/aviation-fleet-dashboard-airlines--aircrafts-overview-power-bi
Note:- For this project, I scraped data of latest airlines reviews from the website Skytrax of 14th of September, 2023.
① Sample Data of one airline Click Here
Background
Objective
In today's rapidly evolving airline industry, customer feedback plays a pivotal role in shaping business strategies. This project centers around harnessing the power of data by collecting and analyzing airline reviews from Skytrax, a leading source of passenger opinions and reviews for airlines worldwide.
The primary objective of our project is to extract meaningful insights from daily airline reviews, enabling airlines to make data-driven decisions to enhance customer satisfaction, optimize services, and stay competitive in the market.
➡ Each stage is meticulously designed to ensure the accuracy, integrity, and reliability of the extracted information.
• Utilize advanced web scraping techniques to extract relevant information from the Skytrax website.
• Employ cutting-edge technologies to navigate through web pages and transform raw data into a structured format.
• Leverage Azure SQL Database, a cloud-based relational database service, for seamless and efficient data management.
• Collected reviews are securely stored in Azure SQL Database in the form of table, ensuring data availability, scalability, and robustness.
Database Connection Information Click Here
Table Creation Code Click Here
• Utilize Pyspark for large-scale data analysis and efficient extraction.
• Store the extracted data in CSV format in the local system.
Screenshots : Click Here
Raw Data : Click Here
• Leverage Pandas for data manipulation and analysis.
• Clean and transform the CSV-formatted data into a structured format for further analysis.
• Visualize and summarize the preprocessed data using EDA techniques.
• Gain insights into passenger sentiments, preferences, and experiences.
Preprocessing with Pandas Part-1 Click Here
After Part-1 Save data Click Here
Preprocessing with Pandas Part-2 Click Here
Clean Data : Clean Data
• After obtaining the final clean data, utilize Power BI for creating interactive and visually appealing dashboards and reports.
• Power BI allows for seamless visualization of insights, making it easy to communicate and interpret complex information.
① Translate insights into tangible business strategies.
② Explore real-world implications and demonstrate how airlines can optimize operations, refine customer interactions, and devise innovative marketing campaigns based on data-driven insights.
Reflect on how the project contributes to the evolution of the airline industry and fosters a culture of data-driven decision-making.
Discuss challenges encountered during the project lifecycle and strategies employed to overcome them.
Outline potential avenues for future enhancements, including the integration of additional data sources, implementation of more advanced analytics, and exploration of predictive modeling.
• WebScraping - Python
• Data Storage - Azure SQL Database
• Data Extraction - Pyspark
• Data Preprocessing - Pandas
• Data Visualization - Power Bi