

Bar chart races!
Thanks to @jburnmurdoch my twitter timeline is full of Bar chart races these day. And now Flourish have made it even easier to create one yourself, so I really wanted to make one as well. 🚨New template alert! 🚨 Inspired by @jburnmurdoch and @MattNavarra … you can now make “bar chart race” viz in Flourish in seconds without coding 🙂 Fully responsive and complete with … Continue reading Bar chart races!

Births per neigbourhood of Amsterdam sonified
This tweet got me excited to try out twotone, a way to turn your data into a song! Today we’re making noise (no pun intended) with TwoTone, a free, open source, browser-based tool to sonify data by @datavized and @GoogleNewsInit. Upload data, choose variables, instruments, speed and other features and listen: https://t.co/8aXEgrecHF pic.twitter.com/s1kx7c2EmF— Alberto Cairo (@albertocairo) 6 maart 2019 For my song, I looked at … Continue reading Births per neigbourhood of Amsterdam sonified

Are your neighbours young or old?
I think the age distribution of the neighbourhood I live in in Amsterdam has changed quite a bit in the recent years. There are more and more kids coming in, ‘replacing’ older people. To see if I could find the facts about this, I went to the Open Data Portal of the city of Amsterdam.. There, you can find the ‘Basisbestand Gebieden Amsterdam (BBGA)‘. I … Continue reading Are your neighbours young or old?

Adopting a bench in the Vondelpark
Scatterplot with all the benches in the Vondelpark that are up for adoption Continue reading Adopting a bench in the Vondelpark

Coloring cities based on streetnames – Belgium edition
Earlier, I created some colored streetmaps for Dutch Cities. Here’s the Belgian edition! I created all the maps with the Osmnx package for Python, created by Geoff Boeing, who was also very nice in helping me on stackoverflow when I got stuck on a strange error message (which was caused by me getting environments mixed up) Let’s start with Antwerpen: Next up is Brussels, but … Continue reading Coloring cities based on streetnames – Belgium edition

Coloring cities based on streetnames
Recently I saw this tweet from @puntofisso where he coloured the roads of urban areas mainly in England, based on their names. He got his inspiration from this article from @Erdavis and @cedscherer. I used and adapted his code that uses Osmnx for Python to create maps of Dutch cities, colored by their streetnames. Here’s Amsterdam: The Canals are clearly visible, and besides that … Continue reading Coloring cities based on streetnames

Packed circles and treemaps from Flourish
I tried to use nested circles in a visual, using Flourish. A dataset about different types of roads in different cities in the greater Amsterdam area seems to lend itself for this type of visual. The viz below is easy to make in Flourish: But I did notice quite some flaws, that are issues with this type of chart. They are probably magnified by my … Continue reading Packed circles and treemaps from Flourish
Excel in excel
Excel is the omnipresent tool to work with data in the world, and it is loved and hated because of this. In this post you will find some useful links, some horror stories and some fun with excel. I strongly believe that you can save yourself a lot of time if you increase your Excel skills! Useful Resources: You can obviously find a ton of … Continue reading Excel in excel
Auto’s en toeristen snelst stijgende bron van inkomsten voor Amsterdam
Het CBS publiceerde een artikel over de gemeentelijke belastingen in Nederland voor 2019 met een aantal interessante inzichten. In het artikel wordt Amsterdam apart genoemd als het gaat over toeristenbelasting en parkeerinkomsten, daarom heb ik gekeken naar de bijdrage van deze posten voor Amsterdam. Dat blijkt behoorlijk anders dan het totale beeld van Nederland. Waar voor heel Nederland de Onroerendezaakbelasting op 1 staat, is dat … Continue reading Auto’s en toeristen snelst stijgende bron van inkomsten voor Amsterdam
Which chart is best for your data?
If you are inspired -and maybe also a bit overwhelmed- by all the great examples of data visualisation in this post, you probably want to use visualisations more often for yourself as well. The question of course is which chart you should chose for your data. The answer, of course, is “It depends”. Some general guidelines: Less is more: Edward Tufte introduced the ‘data to … Continue reading Which chart is best for your data?
The power of telling stories with data
“Most of us need to listen to the music to understand how beautiful it is. But often that’s how we present statistics: we just show the notes, we don’t play the music.” – Hans Rosling If you have never heard of Hans Rosling, now is the time to get to know his work. He’s one of my great heroes, because he turns statistics into amazing stories … Continue reading The power of telling stories with data
Can I test it? Find the Power!
Imagine you have this great new idea for an e-mail you send to all your customers. You are obviously quite certain that this new picture will drastically boast your conversion, but after reading about the power of Experiments and A/B testing, you decide to run a quick test… First: Good for you! 🙂 Before you setup the test, it is important to see what sample … Continue reading Can I test it? Find the Power!