In Progress

build me a Tableau tool for analysing airport flight data

I am looking to create a benchmarking tool for airport flights for personal use.

I have airport data where each row is a different flight (See attached photo of example data structure in excel). I have this data for many airports all in the one data set, where the airport names are given as Orig and Dest (origin and destination of the flight). I wish to create a table that produces a number of variables for each airport. Each airport has a number of departing seats, arriving seats, and total seats (arr + dep) for each hour, day, week etc. if the airport is the "Orig" of the flight, the seats represent a departing flight. Whereas if the airport is the "Dest" of the flight, the seats are considered arriving seats.

The following variables must be produced each year for each airport:

- Departure Peak Month Seats: the number of departure seats in the busiest month of year when summing up departure seats.

- Departure Peak Month: The month in which this occurred.

- Departure Peak Month Ratio: The ratio of the peak month seats to the number of seats in the whole year

-Departure Design Day Seats: Defined as "the 2nd busiest day of the average week of the peak month". You work out how many 7-day weeks there are in the peak month, starting on a monday, and find the average number of departure seats across that month in those weeks. The week that is closest in seats to the average, i need the number of seats on the 2nd busiest day.

- Departure Design Day: the day of the week and date of the design day

- Departure Design day ratio: The ratio of the design day seats to the seats in the whole month

- Departure Peak Hour Seats: the number of departure seats in busiest hour of the design day. This is done by taking each flight and summing the number of departing seats for the airport in the next 59 minutes, including the current flight. The departure peak hour seat number is just the maximum value of this during the day

- Departure Peak Hour Seats ratio: the ratio of seats in the departure peak hour to the number of seats on the departure design day

For each airport, this needs to be done for arriving seats and total seats as well

Skills: Tableau, Data Processing

See more: flight data base programs, build flash tool shirt design, multi airport flight finder, tableau airline dashboard, udacity tableau project flights, flight delay analysis, tableau flights, flight data visualization tableau, flights dataset analysis, airport delay data, flight delay dashboard tableau, create search flight data prices, erevmax flight data, airport flight schedule animation flash, flight data api, flight data scraper, airport flight, project airport flight, data needs feed website, flight data feed

About the Employer:
( 0 reviews ) Melbourne, Australia

Project ID: #25619190

Awarded to:

ibrahimanjum330

Hi, I am Ibrahim and I am a data scientist, I can help you with tableau, you have given some themes, do you want only those sheets or something extra would also fit. Regards, Ibrahim Anjum

$30 AUD in 3 days
(36 Reviews)
5.4

16 freelancers are bidding on average $155 for this job

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project build me a Tableau tool for analysing airport flight data I can assure you the quality job. We have worked on 550 + Projects. If you are looking More

$180 AUD in 3 days
(212 Reviews)
7.7
rinabuoy13

Hello, I am an independent, experienced data analysis expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$200 AUD in 7 days
(48 Reviews)
5.5
anchalsingh0005

Hello, ‌Hope you doing well.I have checked all your requirements and we able to do this and deliver in time.I have 5 years of experience in these types of work. So, I believe we can do that work with your support. ‌Reg More

$150 AUD in 7 days
(11 Reviews)
4.1
WardWarrior

Hi, Please see the links below for examples of previously completed projects. I can work with you to develop a dashboard tool for reviewing your flight data. I can complete your specified calculations and build them in More

$300 AUD in 7 days
(7 Reviews)
4.2
willspage1991

I’m Professional Web Developer & Programmer having 6+ years of experience. Who provides top notch solution in every channel of IT. We provide services in following areas:  ✔ PHP/MYSQL Large Scale Web Applications Dev More

$150 AUD in 3 days
(3 Reviews)
3.0
nikhilgupta84

Data Scientist/Analytics Consultant with over 13 years of industry experience. I have worked in various domains like Retail, Banking, Insurance and Healthcare (Real World evidence). I have been invoved into end-to-end More

$144 AUD in 1 day
(2 Reviews)
2.9
rajeshkumararora

Hi there, I will use Matlab to read the excel data file, then do analysis in Matlab, and write the required output back to the excel file for each airport. Please ping me for further progress of this work. Thanks.

$100 AUD in 2 days
(1 Review)
1.4
abhijeethivarkar

**QUALITY WORK**ONTIME DELIVERY**LOWRATES Hello Sir, I have read your requirement and I find myself for this task because I have over 8 years of experience in building data analysis projects and worked in ETL , databa More

$111 AUD in 7 days
(0 Reviews)
0.0
revanth200

I am good in Tableau and already had enough experience in creating dashboards and story I read the description and can complete the work for you within the dead line and I can also share the sample of dashboards I crea More

$89 AUD in 1 day
(0 Reviews)
0.0
paviarun5

Good Day! We need to create a dashboard for each category. What is the frequency you need the reports generated? Please contact for more discussion. I have over 10+ years of experience as Data Analyst, We can automa More

$250 AUD in 3 days
(0 Reviews)
1.0
$111 AUD in 3 days
(0 Reviews)
0.0
artistixeit

Hello, Greetings! I take pride in giving priority to their needs. Quality and customer service are what distinguish us from others. We always strive to exceed our client’s expectations and meet their requirements. Plea More

$140 AUD in 7 days
(0 Reviews)
0.0
Lokesh1860

I am expert in Tableau , I had done many projects using tableau. I can create interactive dashboards and can create accurate analysis. so for further details we can discuss in chat.

$80 AUD in 1 day
(0 Reviews)
0.0
TabassumAnsari

Hi, I have 4+ years of experience in data visualization and analytics using different BI tool like Tableau and Spotfire. It's the analysis of data that really gets me going. I like to explore the relationships between More

$200 AUD in 4 days
(0 Reviews)
0.0
SaravananSwami

[login to view URL] Experienced in Tableau delivering end to end projects.

$250 AUD in 5 days
(0 Reviews)
0.0