Visualization Use Case Part 2: Airline Arrival Delays in the US (Tableau)

After reviewing the flaws of the previous visualization of the DOT Airline performance data in part 1, I created an improved version with the same recordsets. It is a separate viz because the first version have some mistakes due to the number conversion during the csv import. I cleaned up, checked the data and used calculated fields to derive the sum of delays.

Airline Performance in the US 2015

Airline Performance in the US 2015

The basic concept is still the same, the matrix on the top left controls the dashboard, initially you see all data for 2015 combined, clicking into cells drills down.
I changed the barchart to stacked bars comparing total to delayed flight in one bar for each month.

Bar Chart

Bar Chart

I moved the split delay reasons into a separate bar chart and added a pie chart which reveals the main reason for delays (surprisingly weather and security have the smalles share!) The 2 lists are a Top 10 style lists highlighting the airports and airlines with the most delays.

Performance

Airport Performance

 

Performance

Airline Performance

 

How does the visualization transport information ? Let’s look at the strong and weak points of the second iteration.

+ The key information presentation is improved. We can see the viz is about delays.

 The dashboard starts to look a bit disorganized and the viewer eyes are moving around without a centre of attention.

+ The barchart now makes sense, you can compare total flights and delays.

– The detail delay reason over time does not create too much value as the distribution of reason is quite similar.

Conclusion: Spending more time on both data and visualizations improved the overall impact, though a bit cluttered.

Lets try to apply to some more tweaking..

Visualization Use Case Part 1: Airline Arrival Delays in the US (Tableau)

Going beyond sample datasets and basic visualizations I was looking for open data in my professional domain, the aviation and airport industry. Potential candidates for visualizations are connections, routes, flight plans, airport and airline performance. Performance is usually the comparison of scheduled operations vs. actual milestones. The delay of arriving or departure flights is not only affecting passengers and many parties inside and outside the airport community, but it is driving sentiments, perception and reputation and eventually costs money. This kind of data is not something operators like to release but thanks to the Freedom of Information Act (FOIA), a US Federal law, public gets access to all kind of statistics. From the US DOT (Department of Transportation) you can access and download a variety of datasets, one of them is the On-Time Arrival Performance of US airlines in the US and their delay causes since the year 2003 (link). You can filter by airline, airport and timeframe, review the summary on the DOT website or download the set as CSV for your own analysis. I downloaded the complete dataset for 2015, a 2,25 MB file with roughly 13.500 records.

Arrival Delays in Tableau

Arrival Delays in Tableau

 

Airline Delays in the US in 2015 by DOT

Airline Delays in the US in 2015 by DOT

 

It provides total arriving flights, cancelled and diverted flights, the delay count and total time by reason (weather, carrier, NAS, security, late aircraft) for each month-airport-airline combination for 14 carriers at 322 airports.

Airline Delays in the US in 2015 by DOT

Continue reading

About Google Play formerly known as Android Market

I looked at some statistics last time in 2011, almost a 4 years back. Interesting to observe the changes and the evolution.

You can find the facts at AppBrain (http://www.appbrain.com/stats)

From ~175.000 applications in 2011 the number passed 1,5 million in February 2015. Surprisingly the number of apps with in-app billing is only 108.000. It feels like almost any application comes with this “feature”, pretty much every serious game.

I also logged into the developers console again, just remembered I published  some simple apps in 2011 to learn about the physics of the appstore.

Developer Console

Developer Console

Interesting enough they were downloaded 700+ and 200+ times. Wonder what figures this experiment would render when I start it again.

Continue reading

Thoughts about Android

What is still missing in the market (the official Android Market) ?

  1. Language filter
    Now with a total number of apps beyond 150.000 it becomes harder by the day to find apps. Time to release a feature that allows to search apps in one (or more) languages. It does not help to browse through Chinese or Korean or Spanish apps (depending on your mother tongue).

    Language Filter ?

  2. Dates Added and Last Updated for apps
    There is currently no way to identify when an app was added or when it was updated last time. There are too many apps which are outdated or not maintained any longer (I have one app with 250.000 + downloads without an update since more than one year, despite obvious bugs). Maybe create an automatic flag “this app was not update for more than 12/24 months” so user dont waste their time looking at it, or even filter it out. Of course there are alos stable apps that dont need to be updated.
    PS: You can see the changelog with www.androidzoom.com, I guesss they maintain it independently.
  3. Sandbox for “Hello World” and “Test” apps
    Give the developer community a sandbox area where they (we) can do our tests and fooling around with features. The noise factor for the real apps gets higher and higher. OK, you dont search for “hello world”, but it would help doing the housekeeping.

    Test App

    Hello World

More statistics

Made some more statistics just by looking at the number of apps within one month (using the frontpage of androidzoom.com).
Of the roughly 175.000 apps, only 12% are games. There is a vast number of apps disappearing every month. Look at wallpapers and cards games.
I doubt many developers actively remove their apps from the market, so who else is doing it ? Are so many apps flagged by users or is Google looking at IP infringement at last ? (How many wallpapers can you count of movies and cartoons which are definitely NOT licensed by the respective owner?)
Look at it by yourself..

Homemadde statistics