In this how to we use Microsoft Excel to merge two different datasets. We mainly focus on the VLOOKUP function, but also remove duplicates.
Posts by Jeff Knezovich
We're pleased to announce that Round 3 of the On Think Tanks Data Visualisation Competition is now open for submissions. Submit your data visualisation and communication strategy now!
This third and final round of the 2014-15 competition is focused on finding data visualisations that have been most successfully used as part of a wider communication strategy.
In the first round of the 2014-15 On Think Tanks Data Visualisation Competition, we limited entries only to static visualisations. Static visualisations could be anything from a simple bar chart to a multi-part infographic that combines a number of data points to tell a cohesive story. Our diverse panel of judges have reviewed the top six data visualisations as determined by the public vote. Without further ado, the winner of Round 1 and of the US$1500 prize is...
The wait is over! The On Think Tanks Data Visualisation Competition is back in a newer -- and better -- incarnation for the 2014-15 season. The competition is now open to think tanks all over the world. The new and improved competition site has more information, more resources and will provide greater opportunities to learn about data visualisation.
Last Wednesday evening was the Oscars of the UK think tank world -- the Prospect Think Tank of the Year Award. Here's some quick analysis of the event and the winners.
After the end of the On Think Tanks Data Visualisation competition, we were able to catch up with the winner of the Third Round as well as the final overall winner of the competition, Michal Tošovský. Michal led the team at Otevrena spolecnost, o.p.s. -- a Czech think tank focusing on police and public security -- that is behind Mapping Czech Crime, a visualisation that we think does what it says on the tin and does it well!
The time has come. After three qualifying rounds and a final, and thousands of public votes from around the world, we're now more than pleased to announce the final results of the On Think Tanks Data Visualisation Competition.