Photo credit: Rachel Andrew

Noah Veltman, OpenNews Fellow at the BBC, wrote a series of Learning Lunches and generously allowed School of Data to republish them.

These Learning Lunches are series of tutorials that aim to bridge the context gap and to demystify technical topics that come up often in newsroom development. They are a high-level but concrete discussion of technologies intended to foster more productive collaboration among developers, journalists, and designers. They involve as little code as possible but provide ample guidance for those who want to learn more.

• SQL: The Prequel (Excel vs. Databases)
• So you want to make a map…
• Avoiding mistakes when cleaning your data
• Web APIs for non-programmers
• XML and JSON: the tale of the tape
• Scraping the web

Image: Table and contents, pivoted. By Tom Longley. Using a spreadsheet to pivot a table helps you see your data clearly and from different angles

We’re pleased to announce a new course: A gentle introduction to exploring and understanding your data. This is Tactical Tech’s second course for the School of Data, building on our earlier course about cleaning data.

We probably shouldn’t tell you this, but the course title is a bit misleading. This course is actually a boot-camp on how to use a powerful spreadsheet feature called the pivot table. If we called it “Pivot table bootcamp” or “Pivot tables made easy” nobody would click the link. This is because they’ve seen the pivot table feature in their spreadsheet and they’ve been gripped by fear.

The pivot table has all the hallmarks of something that is not intended for civilian use:

• a name that suggests you’re about to do something dangerous: flick safety catch, break seal, pivot table, adopt brace position.
• a tedious interface of blank white rectangles, unhelpful labels and seemingly endless combinations of drop-down menus.
• the initially inexplicable effect that it has on the data that you process with it.

We understand this fear, friends, and we’ve written this course to help you overcome it. Despite having the human friendliness of a sleep-deprived tiger, pivot tables will save you considerable time and effort in understanding and processing your data:

• They quickly summarise a complete dataset, so you can see at a glance what’s in it.
• Using something called cross-tabulation pivot tables re-arrange a dataset without changing the original data.
• You can make lots of them at once, allowing you to see lots of different views of your dataset at the same time.
• All the other useful features of spreadsheets, like sorting, filtering and formulae also work on datasets presented in pivot tables.

In this course, we gradually work through the four steps it takes to build pivot tables that answer questions about your data. We illustrate each step with lots of simple and more extensive examples that you can recreate from downloadable sample datasets.

We hope you find this course useful. Please tweet or leave comments here or on the course page to let us know how you get on, and what we can make better in the course. Now… get started with a gentle introduction to exploring and understanding your data.