Category: How To
-
OpenRefine Part 3: Fixing inconsistencies with the cluster and edit tool
If you’re still on the fence about using OpenRefine or feel intimidated by its features, this tutorial will walk you through two of its most powerful tools: clustering and editing. These tools will help you clean and standardise your dataset, saving hours of work.
-
OpenRefine Part 2: Removing duplicates and using version history
OpenRefine is one of The Outlier’s favourite tools when working with large datasets. This powerful open-source program is ideal for cleaning messy data. In this post, we focus on two essential features: removing duplicates and using version history to keep track of your changes.
-
OpenRefine Part 1: Installing and merging datasets
If you find yourself getting bogged down when you’re working with large datasets in Excel or Google Sheets, OpenRefine might be the solution you’ve been looking for.
-
-
-
The tools we use to make our charts and dashboards
We often get asked what tools power the hundreds of charts and dashboards we produce at The Outlier. From data crunching in Google Sheets to designing with Flourish and Figma, we’ve fine-tuned a process for creating both static and interactive visuals. Our special data deep dives are built with Svelte and D3.js to help bring…
-
Unlock the power of colour
To help you supercharge your stories, we’ve put together a quick guide to colour that distills our insights into how to use colour effectively in data visualisation, complete with real examples, practical tips as well as some of our favourite tools. 🔗 Get your free copy of The Outlier’s guide to colour
-
How to make custom maps — even if you don’t know how to code
When programs such as Flourish or Datawrapper don’t have the map format you need, you can make your own custom map. Here’s how.
-
Building projects with Leaflet and SvelteKit
If you’re planning on building projects in SvelteKit, it needs a slightly different set-up to Leaflet.js. Here’s what you need to do to get it to work.
-
5 reasons to switch to OpenRefine to clean data
It has a pretty steep learning curve but it’s definitely worth the effort to learn OpenRefine if you need to clean large amounts of very messy data.