Working with Budgets and Spending Data
In this course, we will take you through the steps involved working with budget and spending data. In the process, you’ll learn how to wrangle and clean up some of the most common errors which we see in spending and budget data, as well as doing some dataset gymnastics, such as transposition and cleanup before creating a simple visualisation at the end. If you don’t have your data yet, or don’t have it in machine-readable format – take a look at the two courses above on extracting data, we start from cleaning up and formatting your data.
Curriculum
- 4 Sections
- 20 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Categorization and reference dataNeed to put your data on a map but it doesn't contain Latitude and Longitude values? Read on!5
- Choosing an audience and classifying your dataSometimes you will need to classify your financial data, for example, to reflect services that people care about or to conform to internationally recognised standards.5
- What is the difference between budgets and spending?Before we begin working with the data, let's take a closer look at the difference between budgets and spending data - what questions is it possible to answer with this data?7
- Cleaning spending dataA quick introduction to why spending data often needs cleaning, following into a recipe for cleaning spending data with Open Refine.3