We love exploring the world through data. Our goal is to help tell engaging stories that ignite interest in data.
Resources
Our team has compiled a list of resources to help you bring data stories to life.
An easy guide to VLOOKUP in Google Sheets
VLOOKUP is important and incredibly useful in spreadsheet applications like Google Sheets because it provides a straightforward and efficient way to retrieve specific information from large datasets.
Getting started with Pandas library
Pandas is a powerful Python library that is commonly used by data scientists and data analysts to explore, clean, and process their data. Here are five common methods that you can expect to use when working with Pandas.
Scraping data to create a custom dataset
What do you do when you can’t find a dataset for your project? Well, one option is to scrape websites for the data you need. Here’s an example of how it’s done.
Cleaning your data with Google Sheets
Google Sheets makes it easy to clean data. Let’s explore three Google Sheets data cleaning features — Cleanup Suggestions, Remove Duplicates and Trim Whitespace.
How to use the IMPORT functions in Google Sheets
Google Sheets Import Functions provide a hassle-free way for users to import data from a wide range of online sources, including other Google Sheets, with ease.
Using Open Data for projects
Looking for data for your next project? Check out Open Data sources like Statistics Canada, Data.gov, and the CDC for datasets. They’re free to access, reuse, and distribute. Check out the list we’ve assembled.
Selecting the right chart to visualize your data
With a multitude of chart types available, it's essential to match the data's characteristics and the story you want to tell with the appropriate visualization.
Creating charts with Datawrapper
Datawrapper is a popular data visualization tool trusted by journalists, educational institutions, finance companies, government institutions, and think tanks. It’s a useful application for those seeking to build interactive, responsive charts, tables, and maps, but have limited coding skills or time.
Improving your workflow with ImportHTML
We spend a lot of time working in Google Sheets and we are pleasantly surprised when we learn something new that improves our workflow. It’s pretty unbelievable that we hadn’t come across this before. One thing we recently discovered is the ImportHTML function.
Data science reading list
Books on data science, data analytics, and data visualization are indispensable companions for anyone looking to harness the power of data to make informed decisions in an increasingly data-driven world.
Where to find datasets for projects
From open government sites to subscription services and everything in between – use this as your go-to reference point when searching for data for your next project.