Visualizing the independence of African countries over time with Tableau

Africa Day celebrated annually on the 25th May, commemorates the foundation of the Organisation of African Unity on May 25, 1963. As we at Think Africa, the organisation I am chairing, are organising a few exciting events to celebrate this day, I wondered about the independence of African countries and if it would be possible to have a visualisation showcasing how that happened over time and from whom, especially as I had not seen something like that.

I always like those time-based motion videos that show the development of something over time, but I had never created something like that. Thus this musing of mine, also gave me an opportunity to learn something new 🙂

Creating the Dashboard in Tableau was not difficult, but creating the video was more involved than I had anticipated. But thanks to Google, I found some good guiding materials that I share here.

Here is the finished video.

A clarification on the data: French Cameroon got its independence on 1st January 1960, while British Cameroon or British Cameroons became part of Cameroon on 1st October 1961.

Unfortunately, Tableau does not have a great way for creating animations that automatically play when the page loads, and as I got to learn, when you save an animation to Tableau Public, you loose the functionality of the animation and the user has to click to make transitions. Here is the Dashboard on Public Tableau.

I thus used this helpful tutorial on recording videos with VLC player to record my screen and capture the transitions. I then used this free tool called, online video cutter, to speed up the video, and that was it!

If you spot any errors, please let me know 🙂