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 · 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
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 · 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
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
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
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
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 · 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 · 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
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 · 06/02/2026
Nice analysis of a nicely done chart.
010
Ralph Spandl @spandl.ca · 21/01/2026
😂
030
Reposted by Ralph Spandl
terence @tterence.bsky.social · 17/01/2026
Nine volcanoes of Japan. Mt. Fuji is instantly recognisable. The others too, I hope. This took a while to get right. Looks like fancy chocolates, no? Or little LED buttons. #rayshader adventures, an #rstats tale
A visualisation of nine Japanese volcanoes
0279
Reposted by Ralph Spandl
RJ Andrews @infowetrust.com · 14/01/2026
brutal bag of charts by @ashendruk.com www.not-ship.com/america-isnt...
not-ship.com
America isn't exceptional — it's the exception
America has self-importance in abundance. What it lacks is the data to back it up.
47140
Ralph Spandl @spandl.ca · 23/12/2025
Fascinating good old times style. ❤️
040
Ralph Spandl @spandl.ca · 12/12/2025
This is an amazing weekend lecture. 🧡
030
Ralph Spandl @spandl.ca · 08/12/2025
Nice video showcasing how data visualization can help to bring a point across the audience. www.youtube.com/watch?v=7Nw6... Using a 3D map showing revenues and expenses of a city (probably made with deck.gl), the author is pretty convincing in telling us that walkable cities are a good thing.
youtube.com
Suburbia is Subsidized: Here's the Math [ST07]
YouTube video by Not Just Bikes
030
Ralph Spandl @spandl.ca · 01/12/2025
These two visuals are now also available on the Power BI Marketplace and mostly free to use, even without a license. Simple visuals, no coding required like when using the Deneb visual.
020
Ralph Spandl @spandl.ca · 19/11/2025
Ohhh, this one is amazing. Visual gallery of SveltePlot.
010
Ralph Spandl @spandl.ca · 16/11/2025
Including Waffle charts!
080
Reposted by Ralph Spandl
Mike Brondbjerg @mikebrondbjerg.bsky.social · 15/11/2025
Installing @processing.org on my new laptop, and @winterbloed.be's classic HE_Mesh library!! Brilliant library! Even the examples are ace! :)
0111
Ralph Spandl @spandl.ca · 12/11/2025
It’s been quite a journey, but I’m happy to share that three new custom visuals for #PowerBI — free to download. AppSource: lnkd.in/e-demPik web: lnkd.in/eBCnUa8G
small multiples line chart with data labels for Power BIDonut chart example using small multiplesScorecards for Power BI creating a heatmap
110
Ralph Spandl @spandl.ca · 26/10/2025
A fine article on design I found on BS a few weeks ago: www.ft.com/content/e637... And don't miss out on this response letter, which I pretty mcuh agree with: www.ft.com/content/4554... There is no single discipline that can save the world on its own. Great read, #FoodForThoughts
ft.com
Why designers abandoned their dreams of changing the world
Design was once seen as a tool to improve lives — but as modernism has become marketing, that sense of social purpose has drifted away
131
Ralph Spandl @spandl.ca · 23/10/2025
Super nice!
010
Ralph Spandl @spandl.ca · 09/09/2025
Great to see @driven-by-data.net adding new visual types to SveltePlot: svelteplot.dev/transforms/s... SveltePlot is like Observable Plot, but obviously based on Svelte, what makes it much easier to extent functionalities.
svelteplot.dev
040
Ralph Spandl @spandl.ca · 14/08/2025
Strong signal - take a break.
Area chart that went the wrong way and converted dates to numbers, which results in a kind of funny data-art drawing.
050