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!
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
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?
Scatterplot with all the benches in the Vondelpark that are up for adoption Continue reading Adopting a bench in the Vondelpark
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
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 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
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
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?
“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
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!
Once you collected the results it’s time to see if you really have a winner of your A/B test. Of course you calculated beforehand whether it makes sense to perform an A/B test in the first place. Maybe you can already check the significance in the tool that you are using. If this is not the case, here are some nice tools that you can … Continue reading Do we have a winner of the A/B test?