Advanced Analytics:

The SQL above has allowed you to learn some of the Descriptive Analytic qualities of the data. We are looking to understand how you would approach the problem and think through a more open ended question from a stakeholder. To showcase how you would advance your analysis to learn more from the dataset, respond to one of the following prompts:

a$.$ What airport is most likely to cancel flights in the $3$rd quarter of $2009?$

b$.$ Which airports are most similar in their cancellation and delay patterns?

c$.$ What is the likelihood of cancellation by time of day or day of week? Is this different for major airports vs smaller airports?

d$.$ Open ended:Is there some other question you see in the data?