The Spread of Tech [animated]

  • 1

The Spread of Tech [animated]

Tags : 

Key:

  • 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.

THE DATA

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

I then posted the edited spreadsheet into Tableau (paid for version – not public)

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)

 

CONCLUSION

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!


About Author

Caroline Beavon

A communication professional with 12 years journalism experience and a genuine passion for new technologies. An experienced blogger and social media user

1 Comment

10 uses for Infographics – part 1

July 25, 2012at 2:22 pm

[…] are also opportunities to use video and animation (I created an animated map to demonstrate the The Spread of Tech over […]

"Caroline took a complicated set of facts, figures and processes and turned them into something that now only gave them clarity but also brought them to life visually. She was a pleasure to work with through, suggesting ideas and ways we could use and display information more creatively. Very much looking forward to working with her again." Jenni Fryer, Communications Manager, University of the First Age