Andy Josolyne joins us at Power BI to tell us more about his interactive data model to provide actionable insights as to the departure delays of domestic flights within the USA. Check it out!
A data model I designed was included in the showcase in the 'Information is Beautiful Awards 2017' for the following work:
A data visualisation model to provide insights into the airport departure delays for Virgin America (or any other airline operator). The model analyses 500,000 domestic flights within the USA during December 2015.
The visualisations have been chosen to provide a story of understanding the scale of operations of the domestic flights, including originating and destination airports. It is shown as a network, with geographic routes, a process map showing main hubs and the frequency of flights between airports, plus the key operating metrics and insights. Finally, it provides in-depth analysis that supports route cause analysis, whereby the day, flight number and aircraft tail number can be used to aid investigation of the causes of a delay at the departure airport.
The model was used to support my training and understanding of the Microsoft Power BI application.
YOU MAY ALSO LIKE:
An Interactive Data Model to Provide Actionable Insights as to the Departure Delays of Domestic Flights Within the USA
Andy Josolyne is a former Royal Navy Air Engineering Officer whose active service included operations in the Arctic Circle and Sahara Desert. Commercial experience was gained with Bristow Helicopters and GEC Marconi before becoming a consultant. During the past twenty years, he has provided business consultancy support to, Department for Business, Energy & Industrial strategy, Network Rail, HM Customs and Excise, UK Ministry of Defence, Turkish Ministry of Finance, Marconi PLC, Metronet, Tube Lines, Transport for London, Balfour Beatty, Carillion and Israel Railways. He also was the Interim Head of Marketing for the UK Government’s Defence Aviation Repair Agency. He was awarded an MBA from the University of Surrey in 1996.