Paper, logos and cognac: Sweet Spot Dec 12 2017

It’s the Christmas edition of the Sweet Spot! That wraps up 12 months of, what I hope, have been inspiring and entertaining things to read/watch/listen to, all somehow related to helping people see and understand data. For the final issue of the year, some fun stuff. Still relevant. But fun. See you in 2018!

Secrets to measuring a piece of paper (5 min video, Numberphile)

Numberphile is one of my favourite YouTube channels. This video, by the wonderful Cliff Stoll, provides a brilliant gotcha to teach you a lesson about data collection. It’s a simple lesson but one with big implications: how do people learn to trust their data? Should they trust it blindly? Are they measuring things correctly?

A New Master Blend: Giorgia Lupi and Kaki King (3 min video, Hennessy)

Dataviz, music and cognac: a Christmas gift seemingly designed for the data geek in your life. This is a great project from three inspiring people.

Branded in Memory (15 min read, Signs.com)

Our visual system is the most powerful of our senses, but our brain’s a little lazy and doesn’t remember everything with complete accuracy. This campaign from Signs.com asked people to draw logos. The results are really interesting, and they did some great data analysis and storytelling with the results. (shared by Louis Archer in Product Marketing)

Sweet Spot Dec 1: Visicalc, Excel, and Planet-Sized Data

A Spreadsheet Way of Knowledge (20 min read, Backchannel)

“A virtual cult of the spreadsheet has formed, complete with gurus and initiates, detailed lore, arcane rituals – and an unshakable belief that the way the world works can be embodied in rows and columns of numbers and formulas.” That’s my favourite quote from this piece celebrating October 17’s Spreadsheet day (marking the 35th anniversary of Visicalc. When Tableau is 35yrs old, will people look back and reflect in the same way? (That’s 2038, by the way!)

Meet the Spreadsheet That Can Solve NYC Transit (10 min read, Vice Motherboard)

Clearly there’s life in the old spreadsheet! This article strikes an almost romantic tone as it describes the depth and complexity of a spreadsheet that models NYC’s transport system. Read it and marvel at how far we’ve come with Tableau. I’m amazed at how this is so anachronistic and yet, somehow, appropriate? Go download the spreadsheet itself and marvel at the charts, and the maintenance nightmare this must be. Surley we could model this with a good database and Tableau?

Mission One Complete! (5 min read/watch)

Shall we map the entire world, every day? Why yes, why not? We’ll need a bunch of our own satellites to create 1.4 million images daily (that’s 6 petabytes of data, each day!). That’s what Planet did. Now they’ve built it, think of the possibilities of this dataset. Their promo video is crazy: imagine measuring a country’s economy by measuring the number of ships in a port each day? Or tracking natural disasters more accurately than ever before? Sure beats the Excel datasets described above! Their promo video really sets the scene.