Skip to content

CMPT 732 Project - Dealt with 3 large scale databases by joining them to analysis the economic impact of Covid-19 on the airline industry. Fetched data using API and stored in AWS S3 that is retrieved by an AWS EMR cluster that does data computation. Queried into AWS Athena and visualized the results on Tableau by implementing static and dynamic…

Notifications You must be signed in to change notification settings

RahilBalar98/Covid-19-And-Aviation-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Covid-19 Aviation Analysis

We aim to analyse Covid-19 impacts on Aviation Industry.

Team Members:

  • Dhruv Patel
  • Himalya Bachwani
  • Kishan Thumar
  • Rahil Balar

Data Pipeline:

Data_flow

Project Working:

work_flow.drawio%20(1)

Dataset:

Delay Data : https://1sfu-my.sharepoint.com/:f:/g/personal/krt4_sfu_ca/EsQhv_uPoFhMnibqiD4s29EBkbo7h_cXaS84qL34N7Chhg?e=IMTE3n
Passenger Data : https://1sfu-my.sharepoint.com/:f:/g/personal/krt4_sfu_ca/EkTjMdv6AZdJiTE03igJ_K0BgvISiD6hHqUp-UFjP7nS3A?e=jCvyVB

Tableau link of our project:

Basic Visualization: https://public.tableau.com/app/profile/dhruv4657/viz/Covid-19AviationAnalysis/Airline-Covid
Advance Visualization: https://public.tableau.com/app/profile/himalya1749/viz/CovidAviationUSAnalysis/CovidDepDelay

Steps to run the project:

Refer to running.md file

Report PDF:

https://docs.google.com/document/d/1T0UzcXiEHKlb_jAHS288hDs4HPa-ZqFPVchu074UiM8/edit?usp=sharing

Presentation:

https://prezi.com/view/cc8SFviUjjFH8eDfnglP/

About

CMPT 732 Project - Dealt with 3 large scale databases by joining them to analysis the economic impact of Covid-19 on the airline industry. Fetched data using API and stored in AWS S3 that is retrieved by an AWS EMR cluster that does data computation. Queried into AWS Athena and visualized the results on Tableau by implementing static and dynamic…

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages