The Airline data is downloaded from the given source. Ten years of historical data is analysed to extract necessary information. The data is extracted and loaded into Hive tables after which Java programs are used for cleaning and parsing the data. Hive and Impala are used to query the data and display the results on web UI using MicroStrategy.