Tableau on Tour - One Shade of Orange - Paul Chapman

Paul is co-host of the London Tableau User Group

BI Journey

EasyJet profit by seat of £8.12

65 million passengers per year, with 85% on time performance. 1,500 staff in HQ

Two key values – Safety first, Customer Focus

BI theme – getting the whole picture for agile decision making

3 years ago – data and reporting outsourced to 3^rd parties (read “slow & expensive”)

Could only get part of the story as the data sets were too large for the data set being analysed

2 desktop licence proof-of-concept

EasyJet partnered with The Information Lab for server deployment, training, mapping support etc

Focused on rolling out to ‘Purple people’ (a mix of analytics and business skills)

CEO asked for the demo to be in their own data – Paul made it so it already was!

Paul wanted to change standards of reporting to create consistency and introduce visualisation best practice

Starting to look at Alteryx to support the Tableau work

Viz Standards

Paul condensed down Stephen Few’s guidelines to create better analytics

Orange, Grey and Blue introduced to get away from Red, Amber and Green

Information Buttons on dashboards to help Consumers make the most of their data

What is going to be different for the CEO? Paul’s honest answer was not a lot apart from speed. Paul highlighted the 4 or 5 chains of command the request goes through to cobble together the ‘beautified question’.

-        “Tangible changes to the way that our analysts work”

Live Demos

Paul took us through a full safety briefing before introducing his live demos

Blending aircraft communcations with PlaneFinder.net API to track routes actually flown

Using Tableau to show the difference between expected journey vs actually flown (timing and fuel usage)

Using routes against maps to see how the pilot is making choices to avoid noise pollution for wealthy areas

Allocated seating – 3 price rows when introduced

Analyse was completed on these numbers. Paul and the team used Tableau to show a custom background image to show where people were sitting on a flight. Different images used to show the different planes.

People are prepared to pay to sit as far forward as possible for the least price.

EasyJet board use their iPads instead of their laptops to consume their dashboards

Paul is testing deploying dashboards through the Apple Watch to keep decision makers close to their data / information.

Birdstrikes are an issue for EasyJet and are therefore monitoring when and where they are happening to insure the correct maintenance is being done to their aircraft.

Showing the impact of strikes by French Aircraft control can help the company understand how to respond to such issues.