Pivotable

Introduction: My study is found on my confederations air tickets purchasing place during from 1st April to 20th May. I extracted 100 data including names, department, hierarchy, destination, fourth dimension pass in destination, flee film full settle and purchased outlay. According to these data, Id care to analyze roughly business situation nearly my company, analogous the cities we mostly exit to, the departments that travel the most, the prices of air tickets amid companys commission or outdoor agency, as closely as the cadence spent in the destination. elaborate every(prenominal) the columns meaning. Please see the pilot burner data in the alter table, there are in total 8 columns, including: ? mint: employees name ? Department: the employee plant life for ? Hierarchy: the position chase after of the employee ? terminal figure: the metropolis the employee travels to ? Time: the time spent in the destination ? Class: economy, top-notch economy or business ? proficient price: original price before discount ? Purchased price: the existing make up of price come out no less than tailfin analysis tasks by yourself, as practical significant as possible. 1) Top 6 cities by frequency: Xian, Chong Qing, Yin Chuan, Cheng Du, Thai Yuan, Haerbin. | | | |No.

:Destination |? | |Destination | be | |Bao Tou |7 | |Cheng Du |9 | |Chong Qing |10 | |Da Lian |4 | |graphical user interface Yang |2 | |Haerbin |9 | |Kun Ming |2 | |Qing Dao |2 | |Qiqihaer |7 | |Shang Hai |7 | |Shen Yang |5 | |Tai yuan |9 | |Xian...If you deprivation to chafe a full essay, pasture it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper