Skip to content

Posts by Jeff Knezovich

The on think tanks interview: Bill Dugan of WRI

We caught up with the winner of the second round of the On Think Tanks Data Visualisation competition about their inspiration and experience creating the winning piece.

Visualising the Past, Present and Future of Carbon Emissions, an interactive visualisation by Bill Dugan at the World Resources Institute, USA, is an innovative concept that had big impact. We spoke to Bill about his team’s inspiration for the graphic and his advice for anyone else looking to use interactive visuals to tell a story.

Read more

How to… summarise data with Pivot Tables in Excel

In this how to, we will look at how to summarise that data to answer specific questions using the PivotTable utility in Excel.

Read more

The on think tanks interview: Eric Barrett of JumpStart Georgia

We caught up with the winner of the first round of the On Think Tanks Data Visualization competition about their inspiration and experience creating the winning piece. Don’t limit HER possibilities, a static visualization by Eric Barrett at JumpStart Georgia, won round the judges with its original use of photography and creative manner of telling the story about STEM education for girls in Georgia. We wanted to unpack Eric's motivation for the graphic, the origins behind its unusual style and some of the challenges they faced during the process.

Read more

2014–15 #ttdatavis compilation now available

Today, at the Cartagena Data Festival in Colombia, On Think Tanks launched the 2014–15 compilation of the #ttdatavis competition. The compilation, and the competition more widely, aims to inspire think tanks and similar organisations by showcasing real world examples of impactful data visualisation. It also contains useful resources and 'how tos' to support think tanks to develop their own visualisations.

Read more

#TTDATAVIS compilation sneak preview

On Monday, 20 April 2015, we'll be launching the compilation for the 2014–15 On Think Tanks Data Visualisation Competition at the Cartagena Data Festival in Colombia. Here's a sneak preview.

Read more

Announcing the winners for Round 3 of #TTDATAVIS

The process for choosing winners for this third and final round of the 2014-15 On Think Tanks Data Visualisation Competition has been a complicated one. In total we had 17 strong entries in this round. Of those, three were new and had only submitted to this round. But 14 also participated in a previous round. We asked our six judges to consider all seventeen entries, rather than narrowing it down to a top five in the public vote.

Read more

Round 3 of ttdatavis now open for submissions!

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.

Read more

TTDATAVIS how to series: How to… map data using Google FusionTables

In this how to, we use data that we already collected from Import.io and import it into Google FusionTables in order to create a map of that information. We use an example of mapping hospitals in the UK based on what percentage of staff who work at each hospital actually would recommend getting treated there.

Read more

TTDATAVIS how to series: How to… merge and tidy datasets with Microsoft Excel

In this how to we use Microsoft Excel to merge two different datasets. We mainly focus on the VLOOKUP function, but also remove duplicates.

Read more

TTDATAVIS how to series: How to… import live data with GoogleDrive Spreadsheets

In this how to, we will look at how to use Google Drive Spreadsheets to import live data from the web. I should note that this function is available in newer versions of Excel as well, though it operates slightly differently.

Read more

Follow

Get every new post delivered to your Inbox.

Join 6,077 other followers