Blog

Recent Post

Who Wants to be Normal Anyway?

Who Wants to be Normal Anyway?

“In the 21st Century it is unacceptable that almost 50% of school leavers fail to achieve average grades”Quote from a British Politician, circa 2010-ish​​​​When I heard this live on BBC News 24, I almost fell off my chair. Even with the most rudimentary understanding of data and statistics this is a really stupid thing to say – and these are…

Statistics – The Last Dark Art?

Statistics – The Last Dark Art?

In the first post in our ‘Discover Stats’ Blog Series we explain what stats is, what it isn’t and why you should take the time to learn the basics… No, wait, stop running – it’s really not that difficult. Honest! Come back and let me explain… Continue Reading

How to Clean Numerical Data in Excel Using COUNT and COUNTIF

How to Clean Numerical Data in Excel Using COUNT and COUNTIF

Cleaning numerical data can take a ridiculous amount of time – if you’re cleaning it manually, that is. Learning to use a few simple formulae in Excel can save you time, hassle and having to explain to your boss why that analysis report isn’t on his desk yet, a mere 2 weeks after he gave you…

How to Clean Text Data Without Manual Data Manipulation

How to Clean Text Data Without Manual Data Manipulation

There is plenty of information in Excel’s help files about the way Microsoft suggests that you use them. You can learn a lot from them but did you know that there are actually alternative uses of these functions and formulae? It’s actually these alternative uses that turn out to be the most valuable because they can help…

Top 3 Tips for Data Classification

Top 3 Tips for Data Classification

This is the third blog post in the series, following hot on the heels of 11 Essential Tips for Effective Data Collection and 5 Productivity Tips for Efficient Data Cleansing. Here we deal with the classification of data, and I’m going to give you my Top 3 Tips. Continue Reading

5 Productivity Tips for Efficient Data Cleansing

5 Productivity Tips for Efficient Data Cleansing

The previous blog post in this series 11 Essential Tips for Effective Data Collection dealt with practical data collection methods. This blog post is the second in the series and deals with data cleaning (aka data cleansing or data scrubbing). Data cleaning may not be everyone’s favourite part of working with data, but it’s definitely one of the…