
👋 Hi there,

<img width="922" height="922" float="right" src="me-userpic.jpg" mt="0" mb="10">

I am Ilya. I am a software engineer. I design and develop geographic data visualizations and
geo data analytics tools.

I've completed <a href="/">many projects</a> for media, private companies, NGOs, transportation authorities
and academic institutions.
I've worked at big IT companies and startups, universities
and a <a href="http://interactivethings.com/" target="_blank" rel="noopener">renowned design studio</a>.
Currently, I am helping to build the
<a href="http://studio.foursquare.com/" target="_blank" rel="noopener">next generation geospatial analytics platform</a>
at <a href="https://unfolded.ai/" target="_blank" rel="noopener">Unfolded</a>/<a href="https://location.foursquare.com/products/studio/" target="_blank" rel="noopener">Foursquare</a>.
In late 2020 I founded <a href="https://www.geovisually.com/" target="_blank" rel="noopener">GeoVisually GmbH</a>,
an interactive maps and geographic data visualization consultancy.

My special interest is in visualizing data about
geographic movement of people or goods, e.g. transport-related data.
I wrote <a href="/assets/thesis.pdf" target="_blank" rel="noopener">my thesis</a> about this topic
and developed <a href="https://flowmap.blue" target="_blank" rel="noopener">FlowmapBlue</a>, a
free online tool for visualizing origin-destination movement.
I am passionate about building tools which help cities to shift to sustainable mobility.

Check out <a href="/resume/">my full resume</a> and <a href="https://www.linkedin.com/in/ilyabo/" target="_blank" rel="noopener">my LinkedIn page</a> for more details on my professional background.

I live in Switzerland. I like being in the ⛰ nature and 🚴🏻‍♂️ cycling. I am the father of 👦🏻🧒🏼.
I play guitar and 🎹 and [make electronic music](/music).
I share [much of my code online](https://github.com/ilyabo).

You can contact me at [ilya@boyandin.me](mailto:ilya@boyandin.me)



<button href="https://sqlrooms.org/">Website</button>
<button href="https://sqlrooms.org/examples.html">Example projects</button>
<button href="https://github.com/sqlrooms/sqlrooms" variant=outline>GitHub</button>

[SQLRooms](https://sqlrooms.org/) is an open-source library that provides a foundation and set of building blocks for creating data analytics applications that run entirely in the browser. It combines essential components like a SQL query engine (DuckDB), data visualization tools, state management, and UI components into a cohesive toolkit, making it significantly easier to create powerful analytics tools without a backend.

![](sqlrooms-ai.png)
![](sqlrooms-cosmos-1.png)
![](sqlrooms-cosmos-2.png)
![](sqlrooms-mosaic.png)


SQLRooms


<button href="https://flowmap.city">Try live</button>

[Flowmap City](https://flowmap.city)
is an analysis tool for cities, transport and mobility providers for understanding travel demand.

![Flowmap City – Passenger traffic in Switzerland](flowmap-city-npvm.jpg)

![Flowmap City – Zurich public transport](zurich-transport.jpg)


Flowmap City


As part of the Unfolded/Foursquare team I am contributing to the development of [Foursquare Studio](https://studio.foursquare.com).

Here are some of the features I've worked on:

<i>Trip layer with 3D models and labels – Flights in Europe</i>
<embed src="flights-with-clouds-50.mp4" />

<i>Swipe mode – Eagle Creek fire vegetation loss</i>
<embed src="Eagle-Creek-Fire-33.mp4" />

<i>Annotations – US Census 2020 - Population and Race</i>
<embed src="fsq-annotations.mp4" />

<i>Annotations – Editing</i>
<img src="annotations.jpg">

<i>Annotations – Editing</i>
<img src="annotations-2.jpg">

<i>Flow layer – Bike sharing in Montreal – </i>
<img src="unfolded-flow-layer-bixi.jpg">

[](2.jpg)

<i>Layer config JSON editor</i>
<embed src="layer-config-json-editor.mp4" />


Foursquare Studio


<button href="https://flowmap.blue">Try live</button>
<button href="https://github.com/FlowmapBlue/FlowmapBlue" variant=outline>GitHub</button>

[FlowmapBlue](https://flowmap.blue)
is a free tool for representing aggregated numbers of movements between geographic
locations as flow maps. It is used to visualize urban mobility, commuting behavior,
bus, subway and air travels, bicycle sharing, human and bird migration, refugee flows,
marine traffic, freight transportation, trade, supply chains, scientific collaborations,
epidemiological and historical data and data on many other topics.

The project [won bronze](https://twitter.com/kachkaev/status/1197262339935997952)
at the [Information is Beautiful Awards](https://www.informationisbeautifulawards.com/showcase/3815-flowmap-blue)
in 2019.

<embed src="flowmapblue-palermo-anim-4mapbox.mp4">

Until recently making flow maps has involved manual drawing, knowledge of programming or
specialised software.
I had learned from my experience developing
[flow](https://github.com/ilyabo/jflowmap)
[mapping](https://github.com/ilyabo/jflowmap.js)
[libraries](https://github.com/teralytics/flowmap.gl)
that there was a need for an _easy-to-use_ tool with which people without special
knowledge could make flow maps.
This is why I decided to develop flowmap.blue.
The tool makes it possible to publish interactive flow maps from data uploaded to Google Sheets.
It's free, it requires no installation and allows anyone to create a flow map in no time.

<embed src="flowmapblue-brisbane-zoom-anim-4mapbox.mp4">

![New York Citi Bike trips 2018](ny.jpg)

![BIXI rides Montreal](bixi.jpg)
![Cyclable trips in Waterloo Region](waterloo2.jpg)

<iframe src="https://player.vimeo.com/video/378757494" width="640" height="360" frameborder="0" allow="autoplay; fullscreen" allowfullscreen style="width:100%"></iframe>


FlowmapBlue


<button href="https://supplychains.resourcematters.org">Try live</button>

Data visualization made for [Resource Matters](https://www.resourcematters.org/) showing where the cobalt produced by certain companies ends up, to identify potential levers and pressure points, in hope that this helps improve corporate behavior on the ground.

Testimonial from <a href="https://resourcematters.org">Resource Matters</a>:

<blockquote>
We collaborated with Ilya on the development of a platform visualizing transactions along the supply chains of several cobalt-containing products. We were very satisfied with the results. After a quick introductory call, Ilya presented a mockup that ended up being pretty much the final version, while also resolving a major issue we initially had with our data. Further work involved expanding our initial data display ambitions. The back and forth was always speedy. By asking the right questions, Ilya easily understood (and helped us understand, which is more complex as we are not visualization experts) what we wanted to communicate and how to make it clearer and more user-friendly. The final product achieves a balance between being lightweight, beautiful, and self-explanatory, surpassing our expectations. We intend to continue collaborating with Ilya for future iterations of this platform and other projects. We highly recommend other companies to consider his services."
</blockquote>

![](01-cobalt-screenshot.jpg)

![](0.jpg)

![](1.jpg)

![](cropped.jpg)

![](2.jpg)

![](3.jpg)

![](4.jpg)

![](map.jpg)


Cobalt Supply Chain


<button href="https://mapcanv.com">Live demo</button>
<button href="https://github.com/ilyabo/mapcanv" variant=outline>GitHub</button>
<button  variant=outline href="https://www.youtube.com/watch?v=feMRman7iSo&list=PLyspMSh4XhLN1_EQY-_eyg_gs8z3psSJ2&index=17">Talk video</button>

A collaborative GeoJSON editor. Implemented using deck.gl, Phoenix, Elixir, and Yjs.
Check [my OpenJS Visualization Summit talk](/talks/2024-09-12-openjs-london) for more details.

![MapCanv collaborative GeoJSON editor](mapcanv.png)


MapCanv collaborative map editor


Prototype of interactive notebooks with SQL queries and map visualizations of the query results

<img src=workbook.png>

<embed src="workbook-us-hospitals5.mp4" />

<embed src="workbook-explorer-2.mp4" />


SQL Workbooks


An example app built using [Foursquare Map SDK](https://docs.foursquare.com/developer/docs/studio-map-sdk-introduction) showcasing [Foursquare Places](https://location.foursquare.com/products/places/).
It shows a selection of restaurants in Paris with respect to distance from the 2024 olympic venues, their type, price range and rating.

<img src="fsq-paris-2024.jpg">

<embed src="fsq-olympics2.mp4" />


Paris Olympics Places


<button href="https://graphnavi.vercel.app/">Try live</button>
<button href="https://github.com/ilyabo/graphnavi" variant=outline>GitHub</button>

Network analysis tools can be intimidating, and especially, the data preparation in the form that these tools expect (which often involves combining multiple datasets) can be very time-consuming. SQL is a very powerful and quite popuar language for data analysis and manipulation which can be of immense help for the data preparation. However, setting up a database with an SQL query engine is often a tedious process. Thanks to [DuckDB](https://duckdb.org/) we can now run an efficient SQL database, execute queries directly in the browser and pass the results to a graph layout engine to visualize them as a network.

<embed src="graphnavi-video.mp4" />

![](graphnavi-preview.jpg)

![](graphnavi-screenshot.png)


Graphnavi


<button href="https://www.makutayamaendeleo.org/">Try live</button>

Data visualization made for [Resource Matters](https://www.resourcematters.org/) with the goal of increasing the tax accountability of the mining companies in the Democratic Republic of the Congo:

![](makuta-production-zoomed-selected-material.jpg)
![](makuta-production-zoomed-materials.jpg)
![](makuta-production-zoomed-selected-material-tooltip.jpg)

![](makuta-companies.jpg)


Makuta Ya Maendeleo


<button href="https://ukraine-civilian-harm.vercel.app/">Try live</button>
<button href="https://github.com/ilyabo/ukraine-civilian-harm" variant=outline>GitHub</button>



An interactive map showing incidents that have resulted in potential civilian impact or harm since Russia began its invasion of Ukraine in 2022. The incidents have been collected by [Bellingcat researchers](https://ukraine.bellingcat.com/). Included in the map are instances where civilian areas and infrastructure have been damaged or destroyed, where the presence of civilian injuries are visible and/or there is the presence of immobile civilian bodies.

Or check the source code in the [GitHub repo](https://github.com/ilyabo/ukraine-civilian-harm/).


See also:
[by weapon and area type](https://observablehq.com/@ilyabo/bellingcat-civilian-harm-in-ukraine-beeswarm-timeline)


<embed src="ukraine-civilian-harm.mp4" img="0.jpg" />



![](2.jpg)





Civilian Harm in Ukraine


<button href="https://flight-replay.netlify.app">Try live</button>
<button href="https://github.com/ilyabo/flight-replay" variant=outline>GitHub</button>

Replay GPS paraglider flight data showing detailed 3D terrain and flight trails.

<embed src="flight-replay-cut-50-30.mp4">

![](0.jpg)

![](1.jpg)


Flight Replay


# Geographic data visualization with deck.gl

<button  variant=outline href="https://youtu.be/G58beQZlMxg">Slides Video</button>


I gave a guest lecture at the [ETH Zürich Institute of Cartography](https://ikg.ethz.ch/en/) by invitation from [Andreas Neumann](https://www.linkedin.com/in/andreas-neumann-a10114277/).  In the lecture I discussed geo data visualization using [deck.gl](https://deck.gl), [kepler.gl](https://kepler.gl) and [Foursquare Studio](/p/fsq-studio). I also covered using the AI code editor, [Cursor](https://cursor.com), to assist in coding, as well as [spatial indexing with H3](https://h3geo.org/) and efficient data processing with [DuckDB](https://duckdb.org). The second half of the talk focused on flow map visualization and the tools I've developed for it: [flowmap.gl](/p/flowmap.gl), [flowmap.blue](/p/flowmap.blue) and [flowmap.city](/p/flowmap-city). 

There is no talk recording, but I exported a video from the Keynote presentation, which includes many high quality screen recordings:
<iframe width="560" height="315" src="https://www.youtube.com/embed/G58beQZlMxg?si=GGvF3uRfBr4ecEX9" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>



ETH Zurich guest lecture


# Real-Time Collaborative Map Drawing with deck.gl

<button href="https://mapcanv.com">Live demo</button>
<button href="https://github.com/ilyabo/mapcanv" variant=outline>GitHub</button>
<button  variant=outline href="https://www.youtube.com/watch?v=feMRman7iSo&list=PLyspMSh4XhLN1_EQY-_eyg_gs8z3psSJ2&index=17">Video</button>
<button href="https://vimeo.com/1027410793">Video #2</button>
<button href="https://docs.google.com/presentation/d/1MYJyhuwWawoC4MRmYsPxAwblP1QxNGY6A6l6ogeyvZc/edit?usp=sharing" variant=outline>Slides</button>

![MapCanv collaborative map drawing app](mapcanv.png)

In his groundbreaking 1968 presentation, which was later called the "Mother of All Demos", Douglas Engelbart introduced many fundamental technologies which were years ahead of their time but are now common in modern computing.
Engelbart demonstrated the use of windows as a visual interface. It was the first public demonstration of the computer mouse. He showcased a hypertext system that allowed users to link between documents which laid the groundwork for what would eventually become the World Wide Web. He demonstrated early forms of what we now call video conferencing and collaborative editing, where two users could edit the same document in real time.

Engelbart's presentation showed how computers could be used as a communication tool for collaboration, envisioning many of the ways in which we use computers today.
The modern internet's role in teamwork is enormous. People often work in teams and these teams are becoming increasingly distributed. At least since the COVID-19 pandemic remote work is the norm. But despite being available online to anyone at any time, most of web applications do not support real-time collaboration.
When collaborating remotely on the same piece, document, spreadsheet, or code versioning is a major challenge.

Real-time collaborative apps like Google Docs, Notion, and Figma have set new expectations for seamless teamwork, particularly among distributed teams. These apps have made collaboration feel natural, but building such systems comes with significant technical challenges, particularly around data synchronization and conflict resolution. Fortunately, modern tools such as Firebase, Liveblocks, and Replicache, along with conflict-free data structure implementations like Automerge and Yjs, are making it easier to tackle these issues. The highly concurrent Phoenix framework, which powers platforms like Discord and Felt, also plays a crucial role by enabling real-time message exchange between users.

By leveraging these technologies, I developed a collaborative GeoJSON editor. In this talk, I will share the implementation details using deck.gl, Phoenix, Elixir, and Yjs, delve into real-time messaging, conflict resolution with CRDTs, and scalability, and demonstrate how these modern tools are transforming the way we build real-time, multi-user geo-visualization applications.

Video:

<iframe width="560" height="315" src="https://www.youtube.com/embed/feMRman7iSo?si=rOH_ho9EQpPS8OQn" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>

Video 2 (same talk, different venue):

<iframe src="https://player.vimeo.com/video/1027410793" width="640" height="360" frameborder="0" allow="autoplay; fullscreen" allowfullscreen style="width:100%"></iframe>

Slides:

<iframe src="https://docs.google.com/presentation/d/1MYJyhuwWawoC4MRmYsPxAwblP1QxNGY6A6l6ogeyvZc/embed?start=false&loop=false&delayms=3000" frameborder="0" width="960" height="569" allowfullscreen={true} mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>


OpenJS Visualization Summit London

<button href="https://docs.google.com/presentation/d/1MqGaL5rzBoCmV-xjuwlCfOupZ3anqNp0Lh6ckjh14FM/embed?start=false&loop=false&delayms=3000" variant=outline>Slides</button>


["Efficient data analytics and visualization in the browser"](https://docs.google.com/presentation/d/1TkTiaL3gK8e9Nj5O4DXDxSZkpww86ovx08ihMErXa2o/edit?usp=sharing) presented at the [Armada JS conference](https://armada-js.com/) in Novi Sad.

Talk abstract:
> Making sense of data requires adequate data analysis and exploration tools. Modern browsers offer an increasingly rich and powerful platform for application development. We can now deal with larger amounts of data in the browser with performance very close or equal to native applications. We'll discuss how JavaScript typed arrays, Apache Arrow, WebGL, workers, WebAssembly and other technologies make it possible to run data analytics queries over millions of data points and to visualize the results directly in the browser.


Slides:

<iframe src="https://docs.google.com/presentation/d/e/2PACX-1vTxOGJjvTxsrHsa5CeJyrqMtiRjuHYSZRWPnPTTZuCpskNxAS17UXkjQVE6t9dzMbLoq03Z4mVAFc84/embed?start=false&loop=false&delayms=3000" frameborder="0" width="960" height="569" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>


![](novi-sad.jpg)
![](novi-sad-3.jpg)
![](novi-sad-2.jpg)
![](novi-sad-4.jpg)


Novi Sad JS conference

<button href="https://www.youtube.com/watch?v=MCA6jIdxqt8&list=PLGi6hymK320gP5l7qy6-AESTASRaHmain&index=2&start=15">Video</button>
<button href="https://docs.google.com/presentation/d/1MqGaL5rzBoCmV-xjuwlCfOupZ3anqNp0Lh6ckjh14FM/embed?start=false&loop=false&delayms=3000" variant=outline>Slides</button>

["Dynamically adaptive Deck.gl layer
for mobility data in FlowmapBlue"](https://docs.google.com/presentation/d/1MqGaL5rzBoCmV-xjuwlCfOupZ3anqNp0Lh6ckjh14FM/embed?start=false&loop=false&delayms=3000) presented at the [Open Visualization Collaborator Summit](https://deck.gl/events/madrid-summit-2022/) in Madrid.

Talk abstract:
> FlowmapBlue is a free tool for rendering origin-destination data (counts of movements between pairs of locations). Geographic networks often contain large numbers of connections and displaying them on a map presents significant challenges both in terms of the rendering performance and the map readability. To address these challenges in FlowmapBlue we decided to not always show the data in full detail, but instead to present useful and readable summaries which constantly adapt to the map viewport. In this talk, we'll discuss the motivation behind this approach and describe the inner workings of the FlowmapLayer implementation in FlowmapBlue.


Slides:

<iframe src="https://docs.google.com/presentation/d/e/2PACX-1vRa4YCOTG_LOxBb2xf7GEkF4zvdR-YNuLs602ZxHs6K1bJYQhtdm4aIWiQRP2NCpPlfY4cj_IszPEi3/embed?start=false&loop=false&delayms=3000" frameborder="0" width="960" height="569" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>


Video:
<iframe width="560" height="315" src="https://www.youtube.com/embed/MCA6jIdxqt8?start=15" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>



Deck.gl Summit

<button href="https://www.youtube.com/watch?v=21im47hpxR8">Video</button>

Fireside chat with past Information is Beautiful Award winners
with [Sonja Kuijpers](https://www.linkedin.com/in/sonjakuijpers/), [Amy Cesal](https://www.linkedin.com/in/amycesal/), and [Jill Brown](https://www.linkedin.com/in/jillannebrown/).

<iframe width="560" height="315" src="https://www.youtube.com/embed/21im47hpxR8?rel=0&amp;showinfo=0" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>




DVS Fireside Chat

<button href="https://vimeo.com/737977605">Video</button>

Talking about the tools for mobility data analysis in [Unfolded Studio](https://studio.unfolded.ai/)  together with [Xun Li](https://www.linkedin.com/in/xun-li-794a5b18/) who spoke about cluster and outlier analysis at the [Foursquare webinar](https://connect.foursquare.com/2022-08-Unfolded-Toolbox-Geospatial-Solutions.html).



<iframe src="https://player.vimeo.com/video/737977605?h=1b6540aac5&color=F9CA48&title=0&byline=0&portrait=0" width="640" height="360" frameborder="0" allow="autoplay; fullscreen; picture-in-picture" allowfullscreen></iframe>


[![](fsq-webinar.jpg)](https://vimeo.com/737977605)
![](fsq-webinar2.jpg)

FSQ/Unfolded: Mobility data analysis

<button href="https://drive.google.com/file/d/1jeuCsF8dkGh476PbKQr_4Pdf7RO3eyw2/view">Video</button>

"Einführung in Unfolded" presented at [CartoHack #07](https://visualisierung.dgfk.net/de/events/cartohack/07-unfolded/)
organized by the [German cartographic society](https://visualisierung.dgfk.net/en/).

Here's the abstract of the talk:

> <p>Moderne WebGL-basierte Lösungen ermöglichen es seit einiger Zeit auch größere Datenmengen performant und ansehnlich in Web-Kartenanwendungen darzustellen. Ilya Boyandin von <a href="https://www.unfolded.ai/">Unfolded.ai</a> wird zeigen, was <a href="https://deck.gl/">Deck.gl</a>, <a href="https://kepler.gl/">Kepler.gl</a> und <a href="https://www.unfolded.ai/studio">Unfolded Studio</a> so können und auch einen Einblick in sein speziell für aggregierte Bewegungsdaten entwickeltes Tool <a href="https://flowmap.blue/">FlowmapBlue</a> geben.</p>


![](cartohack1.jpg)


Introduction to Unfolded (in German)

<button href="https://www.youtube.com/watch?v=BduSKMaMAsg&t=215s">Video</button>
<button href="https://docs.google.com/presentation/d/1SXsvvx9ePPcIo26jLA-8SD9EVohIBe9srR0ykQIs93M/embed?start=false&loop=false&delayms=3000" variant=outline>Slides</button>


"Tools for Geo Data Visualization from the Unfolded team" presented at [Geo.Hackmin Week](https://cividi.ch/geohackmin-en/).

<iframe width="560" height="315" src="https://www.youtube.com/embed/BduSKMaMAsg?start=215" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>


Slides:
<iframe src="https://docs.google.com/presentation/d/1SXsvvx9ePPcIo26jLA-8SD9EVohIBe9srR0ykQIs93M/embed?start=false&loop=false&delayms=3000" frameborder="0" width="960" height="569" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>


Geo Visualization Tools from Unfolded

<button href="https://docs.google.com/presentation/d/1U8mybyOWGlgen8w4hsLm0Br_xOQb6W9N-fOvHK46IBg/embed?start=false&loop=false&delayms=3000" variant=outline>Slides</button>

 Presenting [FlowmapBlue](http://flowmap.blue) at 
 the [Urban Computing Foundation](https://uc.foundation/) Technical Advisory Council meeting.

Slides:
<iframe src="https://docs.google.com/presentation/d/1U8mybyOWGlgen8w4hsLm0Br_xOQb6W9N-fOvHK46IBg/embed?start=false&loop=false&delayms=3000" frameborder="0" width="960" height="569" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>


FlowmapBlue at Urban Computing Foundation

<button href="https://docs.google.com/presentation/d/15peaRD9ccPx9LfE1OC5ktpU4ChDKkhqCSLTPd00LWLQ/embed?start=false&loop=false&delayms=3000" variant=outline>Slides</button>


The talk was given in German at the [AGIT](https://agit.at/) symposium.

Here's the [abstract](https://www.conftool.com/giweek2020/index.php?page=browseSessions&form_session=156):
> FlowmapBlue ist eine Open-Source Webapplikation mit der man einfach interaktive geografische Flow Maps erstellen kann, mit Daten, die auf Google Sheets heraufgeladen werden. Das Tool hilft dabei wichtige Erkenntnisse über Mobilitätsdaten zu gewinnen. Es wird für sehr unterschiedliche Use-Cases verwendet: z.B. Migration, Flüchtlingsdaten, Pendlerverkehr, öV-Nutzung, Bikesharing, Vogelwanderung, Güterverkehr, Liefer- und Handelsdaten, epidemiologische Daten. Die Darstellung von vielen Flows auf einer Karte ist keine einfache Aufgabe. Damit das Tool gut skaliert und auch für grössere Datensätze brauchbar ist, musste ich bei der Entwicklung einige innovative Lösungen finden. Im Vortrag werde ich darüber berichten wie das Tool entstanden ist, wie es verwendet wird und wie die Herausforderungen gelöst wurden.

Slides:
<iframe src="https://docs.google.com/presentation/d/15peaRD9ccPx9LfE1OC5ktpU4ChDKkhqCSLTPd00LWLQ/embed?start=false&loop=false&delayms=3000" frameborder="0" width="960" height="569" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>


AGIT Symposium talk (in German)

<button href="https://www.youtube.com/watch?v=9vcELfXdp6I">Video</button>
<button href="https://docs.google.com/presentation/d/1MV51jJJX9Q0lYusd-35u1VhFeXs0ivmvdV2ximYtddM/embed?start=false&loop=false&delayms=3000" variant=outline>Slides</button>


The talk was presented at 
the [DataCouncil Zurich](https://www.meetup.com/fr-FR/DataCouncil-AI-Zurich-Data-Engineering-Science/events/267081855/) meetup.

How ClickHouse enables us at Teralytics to develop products for interactive exploration and visualization of data representing aggregated movements of people.

<iframe width="560" height="315" src="https://www.youtube-nocookie.com/embed/9vcELfXdp6I?rel=0" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

Slides:
<iframe src="https://docs.google.com/presentation/d/1MV51jJJX9Q0lYusd-35u1VhFeXs0ivmvdV2ximYtddM/embed?start=false&loop=false&delayms=3000" frameborder="0" width="960" height="569" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>




ClickHouse talk at DataCouncil

<button href="https://www.youtube.com/watch?v=BEkvW5cB3XA">Video</button>
<button href="https://docs.google.com/presentation/d/1NLrWQCfOSvZXlpmCeOOvMe6bJD1nUzCp40JTp9uCmEk/embed?start=false&loop=false&delayms=3000" variant=outline>Slides</button>


The talk ”Flow Maps” was presented online at 
the [Data Visualization Zurich](https://www.meetup.com/datavis-zurich/events/270384574/) meetup.

What are flow maps? Where do they come from and what are they used for? How can they help understanding mobility patterns or migration? What specific challenges do they represent and what are the alternatives? How do they scale to very large datasets?

<iframe width="560" height="315" src="https://www.youtube-nocookie.com/embed/BEkvW5cB3XA?rel=0" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

Slides:
<iframe src="https://docs.google.com/presentation/d/1NLrWQCfOSvZXlpmCeOOvMe6bJD1nUzCp40JTp9uCmEk/embed?start=false&loop=false&delayms=3000" frameborder="0" width="960" height="569" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>


