Don't miss the first Power BI Meetup of 2018! We've got talks from Andy Josolyne and Prathy Kamasani. Check it out!
An Interactive Data Model to Provide Actionable Insights as to the Departure Delays of Domestic Flights Within the USA
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.
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.
Power BI has come an awful long way since its introduction in the Summer of 2014, but it’s not the only product that’s relatively new to Office 365. In this presentation which is geared towards creating truly ‘actionable BI’, we will take a look at some of the other kids on the block, namely PowerApps, Forms and Flow to see how these fit in with Power BI and the Office 365 stack.
During this hands-on session, we will look at how James Bond and MI5 might use Office 365 to identify agents in the field, track them down and… Well, you know the rest!
Rory Neary is a Chartered Accountant turned MSBI contractor based in London / South Buckinghamshire. Rory has spent much of his career in finance roles covering external audit, internal audit and group financial reporting in addition to developing multidimensional reporting systems and document management systems.