Airlines Data Analysis using SQL | Travel Analysis on Real Data | SQL Portfolio Project
In this video, I analyse by writing SQL Queries based on my own travel data to different continents.
The focus is on thinking of the important metrics to look at and playing around with some SQL.
Here is the link to the dataset
Data: https://drive.google.com/file/d/1HwIJ...
⏲️===TimeStamps===⏲️
00:00 Intro
00:55 Unique Airlines Taken
01:35 Year with maximum source cities
02:53 Money spent by Airlines
03:53 YOY % increase in flights
08:20 Airlines with maximum distance and flights