Visualisation

Joining data using Metabase

Learn how to join data for powerful visualisations in Metabase

Joshua

4 minute read

Joining data using Metabase

A powerful new feature in Metabase version 0.33 allows you to join data together from your datasources to answer questions and create visualisations. This comes along with a complete refresh of the query builder within Metabase, which more than ever provides an easy way of exploring your data without having to rely on SQL. In this post, I’ll show you a quick example of how you can use these new features to join, aggregate and visualise some product usage data.

Generating Sankey diagrams using Python

Visualising household expenditure with a Sankey diagram

Joshua

4 minute read

Generating Sankey diagrams using Python

Sankey diagrams are a great data visualisation named after Matthew Henry Phineas Riall Sankey following his usage of this type of diagram when communicating the efficiency steam engine components. They can be useful for visualising the flow of users through a process or application, where the width of the arrow is proportional to the number of users who follow that route. If you’ve used Google Analytics, you’ll be familiar with this as the “Behaviour Flow” chart.