Data Tools

Some tools that make my job as an analyst a little easier.

Tool guides

Excel shortcuts

Big list of useful shortcuts for Excel

Data gathering

Websites to get data from:

Data cleaning

NimbleText

Quick in-browser text manipulation: add line numbers, remove empty lines, add prefixes, remove smart quotes, etc. The paid, downloadable version is well worth it too.

Data visualisation

Datawrapper

Make charts in the browser. Also has an API/python library for making charts

Choosing colours

datawrapper blogs: color in data vis

A group of blog posts about data vis colours, well worth checking out before planning a colour scheme.

Coolers

A website for generating colour schemes that work

Colorbrewer

Colour pallets for maps

Color-blindness simulator

Upload an image to check how legible it will be for users with colour blindness

color oracle

Program that applies a full screen filter to simulate colour blindness

Data visuals in action

Datawrapper: weekly charts

Datawrapper make a new chart every week and tell us about the information

Datawrapper: vis dispatch

Datawrapper also share the new charts they find in the wild that impress them

Books and learning

Hands on data viz

Book by Jack Dougherty & Ilya Ilyankou, can be read online

Fundamentals of Data Visualization

Book by Claus O. Wilke, can be read online

Statistics by Jim

Blog and books by Jim Frost - good posts about data types and statistics

Teaching statistics resources

A wonderful compilation of learning resources sourced by Nicola Rennie

Calculator soup

A range of calculators for many uses, with their algorithms explained with examples

Maths symbols list

A table of mathematical symbols and their meanings

Maths is fun : maths tools

A list of useful maths tools with a Data section for stddev and correlation measurements

The data fundamentals

NEVER: