+1(978)310-4246 credencewriters@gmail.com
  

Anthony Assi
ITM / MSBA 3
Final Project
Hive QL
Where to access the dataset:
https://itmemr.ggu.edu:8888/hue/notebook/
Database name: default
Dataset: sfo_monthly_air_traffic_passengers_data
Instruction for the final project:
Dear Students,
The City of San Francisco publishes regularly some of it’s city key data sets under their
DataSF’s program who’s mission is to empower use of data. they seek to transform the way
the City works through the use of data. they believe use of data and evidence can improve
our operations and the services we provide. This ultimately leads to increased quality of life
and work for San Francisco residents, employers, employees and visitors.
We have extracted the Air Traffic Passenger Statistics from their published
Transportation
dataset.
You will be analyzing the San Francisco International Airport Report on Monthly Passenger
Traffic Statistics by Airline. Airport data is seasonal in nature, therefore any comparative analyses
should be done on a period-over-period basis (i.e. January 2010 vs. January 2009) as opposed to
period-to-period (i.e. January 2010 vs. February 2010). It is also important to note that fact and
attribute field relationships are not always 1-to-1. For example, Passenger Counts belonging to
United Airlines will appear in multiple attribute fields and are additive, which provides flexibility
for the user to derive categorical Passenger Counts as desired.
This Dataset contains 15years+ of monthly traffic, 22k+ Rows and 12 Columns, each
row is an Airline Passengers entry.
Sample preview of the dataset
For this final exam, students are asked to use the dataset listed above to answer the following
questions. Once you have compiled your answers on a sheet of paper, you can go and click on the Quiz
and answer the questions using a multiple choice answer.
1. What were the top 3 busiest Geo Regions (in terms of number of passengers) Flying in and out of SFO?
2. What were the top 3 busiest Geo Regions (in terms of number of flights) Flying in and out of SFO?
3. What were the top 3 years in terms of the largest number of passengers domestic and international flying
in and out of SFO?
4. What were the top 3 years in terms of the largest number of flights domestic and international flying in and
out of SFO?
5. Which year had the lowest number of passengers flying in and out of SFO?
6. Which operating_airline had the largest number of passengers flying with them in and out of SFO?
7. Which operating_airline had the largest number of passengers flying with them internationally in and out
of SFO?
8. Which operating_airline had the largest number of passengers flying with them domestically in and out of
SFO?
9. Let’s analyze the impact of COVID-19 on the travel industry:
How did the number of flights in the first quarter of 2020 (Jan+Fev+March 2020) compared to the previous year
first quarter (Jan+Fev+March 2019)?
10. Let’s analyze the impact of COVID-19 on the travel industry:
How did the number of passengers in the first quarter of 2020 (Jan+Fev+March 2020) compared to the previous
year first quarter (Jan+Fev+March 2019)?

Purchase answer to see full
attachment

  
error: Content is protected !!