Each project outlines the business challenge, objectives, methodology, tools, insights, and recommendations.
These projects showcase how I built interactive dashboards and delivered data-driven recommendations.
Aerospace Data Projects
European Airports & Air Routes
Performance Analysis
Conducted an in-depth performance and economic analysis of route networks across 260 major European airports.
Tools used: Python(Google Colab), Power Query, Power BI, DAX.
Airline Operations Performance Analysis
Analyzed 10,000+ flight records to tackle a critical 42% On-Time Performance (OTP) deficit and a fragile 5.39% operating margin.
Tools used: Python(Google Colab), SQL Server, Power BI, DAX.
Airline Passenger Satisfaction Analysis
Analyzed customer satisfaction scores from over 120,000 airline passengers, focusing on their evaluations of cleanliness, comfort, service, and overall experience. Tools used: SQL Server, Power BI, DAX.
Aircraft Manufacturing Production KPI Analysis
Analyzed fictitious operational dataset containing manufacturing metrics across multiple commercial aircraft programs (including the A320neo Family, A350 XWB, A330neo, and A220 Series). Tools used: SQL Server (SSMS), Power BI, Power Query, DAX.
British Airways Case Study: Turning Customer Insights and Hub Logistics into Business Growth
Demonstrated how data-driven modeling and machine learning can optimize airport real estate and maximize revenue in a highly competitive, thin-margin industry. Tools used: Python (Google Colab), PowerPoint.
Data Projects in various sectors
Financial Performance Analysis | Optimizing Revenue, Margins, and Business Performance
Analyzed fictitious financial transaction data spanning FY2022–FY2024 using Power BI to address margin compression, fragmented reporting, and revenue concentration risk across 3 regions, 4 business units, and 7 product lines.
Reducing No-Shows in Healthcare Platforms
Analyzed appointment data to identify drivers of no-show appointments, assess the financial impact, and provide recommendations to reduce no-show rates.
Analysing cosmetics consumer behavior
Conducted consumer behavior analysis in cosmetics to identify factors influencing purchase decisions, brand perception, and price sensitivity, providing insights for strategic product development and retail execution.
Analyzing Consumer Perception and Purchase Intention about Fruit Juice Packaging
Analyzed consumer perceptions and purchase intentions in the fruit juice beverage sector to identify factors affecting packaging choice, brand loyalty and price sensitivity.
Optimizing User Engagement Through Behavior Analytics
The primary goal of this project was to leverage user behavior analytics to enhance engagement and improve the overall digital experience.
Strategies to Combat Shopping Cart Abandonment & Boost Sales
The primary goal of this project was to analyze customer behavior and improve the e-commerce checkout process.
Tools: SQL & Power BI
Analyzing Customer Churn for a telecom company
The primary goal of this project was to analyze customer behavior and improve customer retention. Tool: Excel.
Analyzing traffic patterns for a department of transportation
The project’s main objective was to analyze traffic patterns using three distinct charts: monthly volumes, weather, and holiday travel, utilizing Tableau.
Visualizing World Happiness by Factors
The main objective of this project was to visualize global happiness by factors such as economy, health, family, and generosity using Tableau.