Understanding what story the numbers are telling is the most important thing when doing #ddj, but getting there is hard. Facing data is a messy business. Datasets are mostly never clean, neat or organized.They have errors, missing values, wrong formatting… most of the times it’s a nightmare.
In order to face this challenge, journalist and people working with data need to learn how to use tools to clean and structure the information. When datasets include multiple cells and numbers, this process can’t be made manually because you risk making errors and you will waste too much time.
Thus, if you don’t know any programming tool, Excel is a great option for you. This Learno.Net course is a great way to learn how to clean, transform and analyse data using this tool. You’ll also learn some strategies and tricks for managing data cleaning processes.
The course instructor is the data journalist, data designer and visualization consultant Maarten Lambrechts, who has worked with MO* magazine and was later hired as a data and multimedia journalist by Mediafin, the publisher of Belgian newspapers De Tijd and L’Echo.
The course is free, online and the total running time is 84 minutes divided in 4 different modules. No prior knowledge is needed, but a little knowledge of Microsoft Excel will come in handy.
You can sign up here.