- RED: fixed broadband internet
- BLUE: mobile phone subscriptions
- YELLOW: internet users
- GREEN – telephone lines
- (all per 100 population)
STORY OF A VIZ:
Altered last minute to the deadline for the Guardian / Google Competition
This gave me 2 hours do something with a range of data available, to address the issue of the worldwide recession and how national behaviour protected against this, or aided recovery.
Due to the limited time made quick decision to use a simple Excel data set Data World Bank dealing with technological advancements around the world over time.
I edited the many (20+) categories down to 4 – mobile phones, internet users, fixed broadband access and telephone lines. I felt there was a clear link between these, and would give a good demonstration of how technology has moved on.
The categories I decided to eliminate included electricity generation, motor cars, paved roads and access to water.
CREATING THE VIZ
NOTE: I could have used the entire database in Tableau and simply used the bits I needed, but I often find it easier to edit the base data first (avoids crashing too)
I knew straight away that I wanted a animated map showing the spread of these tech elements over time.
Tableau has an option called Pages, which I haven’t used massively – so the bulk of my time was spent changing the options (right) to create the right set up.
I was not able to remove the ZERO values, which gave those small red dots on every country when the animation starts still need to solve this issue
Another issue to take into account was the order at which circles appear: in order for the latter circles not to appear beneath the earlier ones, they had to be ordered (in Indicator Name) in reverse order – latter elements first.
By sending the animation to Tableau Public, I would be able to embed and link to the animation. Or so I thought.
I attempted to embed the animation into WordPress but usual iframe issues impeded this (seriously – this needs sorting out).
It was now 11:45 – I was running out of time.
I initially settled on linking to the Tableau Public but sadly the Tableau Public version was not an animation, simply a manual click through option – not quite as good looking.
CREATING THE ANIMATED VIDEO
I then decided to make a VIDEO of the viz. I briefly considered exporting then individual screenshots into Moviemaker but this would definitely lose some impact.
Then I remembered some screen-recording software I had recently used to create a vidcast – Screencast-0-matic Screen Recorder.
By playing the animation from Tableau Desktop, and selecting just that element of the screen, it produced a relatively nice finished result.
I just need to remember to turn off the mic next time and think more carefully about the font I used (the menu was a little unclear)
I am pleased with what I achieved in this short time, and discovered a new way of producing video animations.
However, I do accept that the chart, as it stands, does not really answer the brief.
It was fun tough and proves what can be done in a short period of time!