Tessera
Folgen

Ralph Spandl

@spandl.ca

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

339 Posts1864 Follower609 Folgt
Ralph Spandl@spandl.ca · 3w ago

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

Montreal Bike Counters

Interactive dashboard of cycling activity across Montreal, based on open data from the Ville de Montréal.

compteurs-cycliste.r42.ca

The War on Cars@thewaroncars.bsky.social · 3w ago

Every city needs more bike counters. It's a great way to show that bike lanes are busy even when they appear empty. (And they often appear empty because cyclists don't get stuck in traffic.)

Ralph Spandl@spandl.ca · 3w ago

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...

2026 FIFA Squad Visuals

Interactive visualizations of 2026 FIFA World Cup squads, clubs, and leagues.

world-cup-26.r42.ca

Datawrapper@datawrapper.de · 3w ago

We just published a new Data Vis Dispatch! Explore the best of last week's charts and maps about the World Cup ⚽️🏆 , the heat in Europe 🔥🥵, Middle East alliances 🇮🇷, US politics 🇺🇸, and more: www.datawrapper.de/blog/data-vi...

3D surface (mesh) chart showing territorial momentum in the Argentina vs. Egypt match, with blue peaks marking Argentina's pressure and red marking Egypt's across the pitch. The score sits at 0–1 to Egypt in the 29th minute of the first half, with a small momentum area chart tracking the swing along the bottom.
Ralph Spandl@spandl.ca · 4w ago

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

Bild
Ralph Spandl@spandl.ca · last mo.

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.

Ralph Spandl@spandl.ca · last mo.

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.

Ralph Spandl@spandl.ca · last mo.

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
Ralph Spandl@spandl.ca · last mo.

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
Mike Brondbjerg@mikebrondbjerg.bsky.social · 2mo ago

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

LDNMayor Data@ldndata.bsky.social · 2mo ago

The State of London report 2026 is out today. The GLA’s annual report with over 100 datasets about the capital’s economy, society, environment, all in one place. Published for the first time as a fully digital report: apps.london.gov.uk/state-of-lon...

Mehdi Oudjida@mehdioudjida.bsky.social · 3mo ago

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🧵

Gregor Aisch@driven-by-data.net · 5mo ago

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...

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.

zeit.de

Observable@observablehq.com · 5mo ago

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

Ralph Spandl@spandl.ca · 5mo ago

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
Ralph Spandl@spandl.ca · 6mo ago

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..