Sign in

Ralph Spandl

@spandl.ca
1.9K followers 614 following 344 posts

data visualization designer and founder of r42.ca #dataviz · #LookerStudio · #PowerBI · #d3js · #measure – 🇨🇦 🇩🇪

PostsRepliesMedia
Ralph Spandl @spandl.ca · 24/09/2026
L lab. Nbb m. Meh
000
Ralph Spandl @spandl.ca · 22/09/2026
Excellent example for a good scatterplot!
010
Reposted by Ralph Spandl
Voilà: Francis Gagnon @chezvoila.com · 10/09/2026
I've just done the largest update to the #dataviz starter pack, with 30 accounts (20%) replaced. It means it will generate more content now. Might be worth re-clicking. Sadly, gender imbalance got worse. I saved 5 spots for women-run accounts. Send suggestions, including yourself! Replies or DMs.
114513
Ralph Spandl @spandl.ca · 17/09/2026
We do have croissants in Québec!
020
Reposted by Ralph Spandl
matia 🇭🇷 @joyofcode.xyz · 07/09/2026
I made a Svelte component wrapper around Rough.js for creating graphics with a hand-drawn, sketchy appearance 😄
26910
Ralph Spandl @spandl.ca · 14/08/2026
This site is actually quite smart. See full thread for story 👆🏻👆🏻👆🏻
010
Ralph Spandl @spandl.ca · 09/08/2026
The complete 9 days was amazing racing. Chapeau!
031
Ralph Spandl @spandl.ca · 20/07/2026
22 years! This has aged really well.
010
Ralph Spandl @spandl.ca · 20/07/2026
This is very cool stuff ! 💯
000
Ralph Spandl @spandl.ca · 16/07/2026
Agreed. This why I build a dedicated website for bike counters in Montreal: compteurs-cycliste.r42.ca So people can actually get an overview or a more complete picture on how much cycling has gained traction over the past years. Thanks for sharing @ohtheurbanity.bsky.social
compteurs-cycliste.r42.ca
Montreal Bike Counters
Interactive dashboard of cycling activity across Montreal, based on open data from the Ville de Montréal.
020
Ralph Spandl @spandl.ca · 15/07/2026
... not open source, and as a very specific website project, I would doubt getting any stars 😅
020
Ralph Spandl @spandl.ca · 15/07/2026
I haven't even tried LayerChart waffle or treemap, as I am using my own version, that is also published in the PowerBI Marketplace. These are very easy to use, when you know them and all the features are built-in. The Treemap is a polygon treemap, with automatic label density stuff.
010
Ralph Spandl @spandl.ca · 15/07/2026
@techniq.dev - my first public project using LayerChart 2. Was a real pleasure. Bar charts + Sankey were created with your library, Waffle and Treemap are based on my own #Svelte library. I would love if you could use this as a reference 😁
140
Ralph Spandl @spandl.ca · 15/07/2026
1 Cup. 48 Countries. 450 Employers. This new microsite explores the 1,248 players nominated to participate in the #WorldCup2026. In which clubs, countries, and continents do they play during the season? Five different views on the same question using #DataVisualization. world-cup-26.r42.ca
world-cup-26.r42.ca
2026 FIFA Squad Visuals
Interactive visualizations of 2026 FIFA World Cup squads, clubs, and leagues.
130
Ralph Spandl @spandl.ca · 14/07/2026
Thanks to @datawrapper.de for including the World Cup polygon treemap in the latest Data Vis Dispatch. The microsite is now live: world-cup-26.r42.ca more to come...
world-cup-26.r42.ca
2026 FIFA Squad Visuals
Interactive visualizations of 2026 FIFA World Cup squads, clubs, and leagues.
030
Ralph Spandl @spandl.ca · 14/07/2026
I am using #LayerChart from @techniq.dev for the first time and I am absolutely stunned how well IA agents can understand and translate my requirements (series labels with dodging, #dataWrapper style date axis, modern gridlines, line interpolation..) This task took me weeks when I hand coded them!
Test line chart
121
Ralph Spandl @spandl.ca · 10/07/2026
Preparing a new micro website with team stats of the #WorldCup2026. Preview - should be ready before we know who wins.
010
Ralph Spandl @spandl.ca · 09/07/2026
I added a new visual to the #Montreal #bikeCounter project. Which bike counter sees the most cyclists — and does that change over the year? Hover over the lines and find out. Data updates daily, the race is on. Project: compteurs-cycliste.r42.ca
020
Ralph Spandl @spandl.ca · 25/06/2026
All visualizations (except the map) in this project where built with #SveltePlot by @driven-by-data.net. Very nice to work with, offering quite some flexibility in terms of custom marks and responsive adaptation.
071
Ralph Spandl @spandl.ca · 23/06/2026
Public data is only useful if people can actually use it. After Montréal restored public access to its bike counter data last month, I decided to built a dashboard to explore cycling trends across these counters. 🚲 compteurs-cycliste.r42.ca Regularly updated as new data becomes available.
Interface of the bike counter dashboard, showing a row of KPIs and a map with installed bike counters
040
Ralph Spandl @spandl.ca · 17/06/2026
There are a lot of interesting chart variations in this addendum to the report of the Canadian Climate Institute. I guess, I should read the report to entirely understand them 😅
010
Ralph Spandl @spandl.ca · 17/06/2026
This is mentioned in the sign up form: Are you currently based in the U.S.? (This study requires participants to be located in the U.S. (compensation is paid by check).) Not quite clear, if this is only related to the compensation, but I assume there is another reason for it.
020
Ralph Spandl @spandl.ca · 17/06/2026
But you need to be located in the US, it seems.
110
Reposted by Ralph Spandl
Voilà: Francis Gagnon @chezvoila.com · 11/06/2026
@albertocairo.com talks about the 20th anniversary of Hans Rosling's TED talk and the impact it had on him — and probably on the whole field. 📊
openvisualizationacademy.beehiiv.com
Twenty years of Hans Rosling's famous TED talk
Celebrating the transformative power of joy and epiphany
063
Reposted by Ralph Spandl
RJ Andrews @infowetrust.com · 04/06/2026
wow!
1176
Reposted by Ralph Spandl
Mike Brondbjerg @mikebrondbjerg.bsky.social · 04/06/2026
This report was a HUGE effort from everyone across the City Intelligence Unit!! Really proud of my team for delivering the design and engineering. This digital release builds on years of development of our #Svelte component library, and London City Data Design System! 🥳 📊 #dataviz
083
Ralph Spandl @spandl.ca · 15/05/2026
Nice find while travelling in Europe. German version of Atlas de la mondialisation (published by Le Monde diplomatique).
010
Ralph Spandl @spandl.ca · 30/04/2026
And where are the agencies and clients that need our help with making this reality?
000
Reposted by Ralph Spandl
Mehdi Oudjida @mehdioudjida.bsky.social · 29/04/2026
This is not an analytics reporting (...Magritte, get out of this body). But about the post-modern data stack, or how to build the digital analytics solutions of tomorrow... ..a glimpse into what a future digital analytics data stack output might look like. #DataViz #Analytics 1/6🧵
221
Ralph Spandl @spandl.ca · 29/04/2026
Nice to see, that you are making progress on your project. I think analytics dashboard will take the web path: There are so many different ways how you want to see your data - adapted to the audience - that no BI tool can cover all these possibilities. So, back to DIY, using a web stack.
110
Reposted by Ralph Spandl
Safe Muffins @safemuffins.vip · 26/04/2026
The background radiation of the Internet is noisy. Very very noisy. But sifting through the noise can tell you a lot.
arman-bd.hashnode.dev
I Left Port 22 Open for 54 Days: An SSH Honeypot Study
Field report from an SSH honeypot left open for 54 days: 269K login attempts, 48K unique passwords, and a surprising cast of attackers.
55312
Reposted by Ralph Spandl
Tiziana Alocci @tiziana.bsky.social · 20/04/2026
I haven't been here for ages, is this still going? #dataviz people, are you there?
9295
Ralph Spandl @spandl.ca · 20/04/2026
Not enough tbh.
140
Ralph Spandl @spandl.ca · 14/04/2026
Just realized that I need to rename all occurrences of "Looker Studio" in my portfolio to "Google Data Studio". 🙈 www.linkedin.com/feed/update/...
linkedin.com
#datastudio #lookerstudio | Mehdi Oudjida | 76 comments
The Google Cloud team just officially announced that Looker Studio will now be called...Data Studio...yes, #DataStudio again. And this isn't an April Fool's post appearing on your timeline 10 days la...
000
Ralph Spandl @spandl.ca · 02/04/2026
For chart history freaks!!
030
Ralph Spandl @spandl.ca · 27/03/2026
Nice!
010
Ralph Spandl @spandl.ca · 25/03/2026
This is one of the best recent summaries of software development in agentic times.
032
Ralph Spandl @spandl.ca · 25/03/2026
This video is an absolute beauty!
000
Ralph Spandl @spandl.ca · 23/03/2026
Another great example showing that flags are a misleading way to represent languages. Even ignoring the Reggaeton vs. Spanish point, most songs people listen to don’t come from England but from a wide range of places—just as “Europe vs. the rest of the world” oversimplifies reality.
011
Ralph Spandl @spandl.ca · 13/03/2026
New in SveltePlot: Raster Mark I don't understand yet the full concept, but it allows you too interpolate values to create a raster in image format. svelteplot.dev/marks/raster Kudos to @driven-by-data.net
Screenshot from SveltePlot documentation of Raster Mark showing a generic map of Canada with a dithered color overlay.
020
Reposted by Ralph Spandl
Gregor Aisch @driven-by-data.net · 04/03/2026
I made an animated map of ship movements in the Straights of Hormuz using data from marinetraffic.com. Ship track frames rendered using #ggplot, base map created using #gdal, video editing using #ffmpeg, video player written in #svelte. 🎁 www.zeit.de/wirtschaft/2...
zeit.de
Straße von Hormus: So legt der Krieg die Straße von Hormus lahm
Seit Samstag droht der Iran damit, Schiffe anzugreifen, die die Straße von Hormus passieren. Sehen Sie hier, welche Folgen das für den Verkehr in der Meerenge hat.
47125
Reposted by Ralph Spandl
Observable @observablehq.com · 27/02/2026
When D3 was released in February 2011, it transformed how we build data visualizations for the web and ushered in a new age of unbridled creativity in information design, data journalism, and beyond. Today, it remains the backbone of modern, interactive data viz. Happy 15th birthday, D3 🎂 d3js.org
016838
Ralph Spandl @spandl.ca · 23/02/2026
This new visual start to work out really nice: A Likert scale bar chart with neutral values in the center and automatic calculations of the overall score (in this example: net score). Still a few features missing, but getting there.
Development environment of new Power BI visual
010
Ralph Spandl @spandl.ca · 19/02/2026
Massive update. 👍
010
Ralph Spandl @spandl.ca · 18/02/2026
The Winter Olympics are almost over. A good moment to look back at the stream of medals over time. The Olympics try to stay apolitical, but this steamgraph still reflects European history, much like cold winters leave marks in a tree’s rings. Created in #PowerBI with: r42.ca/articles/tim...
Olympic Winter Games, 1932–2022

Higher, faster — and more medals.

At first glance, the steamgraph reflects the steady expansion of the Games themselves: more disciplines, more events, more podiums. Look closer, though, and it also compresses decades of political history into a single shape.

The green band traces the forty years of a divided Germany. The red band tells a more fractured story: across the decades, Russian athletes appear under four different names, each change driven by politics rather than sport.

In absolute terms, medals attributed to countries outside the top 15 increase over time, whether their share truly grows is less clear..
010
Reposted by Ralph Spandl
Nicola Rennie @nrennie.bsky.social · 16/02/2026
When running #DataViz workshops, one question that often gets asked is "what's your favourite ever chart?" 📊 So I've started compiling some of the awesome visualisations made by other people that I often share! A very much a work-in-progress, non-exhaustive list: nrennie.rbind.io/fave-data-viz/
Screenshot of site some really cool data visualisations, arranged in a grid.
0708
Ralph Spandl @spandl.ca · 12/02/2026
I have been wondering if you worked together on this project.
100
Reposted by Ralph Spandl
Nadieh Bremer @nadiehbremer.com · 12/02/2026
📣 NEW! I’ve just released the BIGGEST and perhaps most creative project I’ve ever worked on! “Searching for Birds” searchingforbirds.visualcinnamon.com 🐤 A project, an article, an exploration that dives into the data that connects humans with birds, by looking at how we search for birds.
26503181
Ralph Spandl @spandl.ca · 11/02/2026
Hey — it’s really nice to see that even leading industry experts can take something away from my work. It’s actually quite amazing how many subtleties emerge once you dive deeper into the D3 code.
010
Ralph Spandl @spandl.ca · 07/02/2026
Ici kann bestätigen, dass ich dieses Wort seit mindestens 25 Jahren nicht mehr gehört habe! 😁
010