Discover Data

Recent Post

19 Essential Tips to Clean Your Dirty Data

19 Essential Tips to Clean Your Dirty Data

Data cleaning is a waste of time. If the data had been collected properly in the first place there wouldn’t be any cleaning to do, and you wouldn’t now be faced with the prospect of weeks of cleaning to get your dataset analysis-ready. Worse still, your boss won’t understand why your analysis report isn’t on his desk…

Getting Your Data Organised – 7 Secrets You Wished You Knew Before

Getting Your Data Organised – 7 Secrets You Wished You Knew Before

​Let’s face it, we’ve all been there. We’ve had a dataset that needed cleaning before we could start analysing it, so we started eyeing the data and fixing errors as we spot them. We convinced ourselves that it wouldn’t take long before we could get it done, then we can get on to the real…

3 Crucial Tips for Data Processing and Analysis

3 Crucial Tips for Data Processing and Analysis

Let’s say you have collected your data and have a nice, clean dataset. You’re ready to start doing your analysis. Hold on there cowboy, not so fast. You wouldn’t start building your house without putting the foundations in place, would you? The last thing you need is for all your hard work to come crashing down because…

How to Clean Data Quickly in Just 5 Steps

How to Clean Data Quickly in Just 5 Steps

Here’s a joke about how to clean data: Did you know that Data Scientists spend 80% of their time cleaning data and the other 20% complaining about it? Yeah, you’re right – it’s not funny. But then there isn’t anything funny about data cleaning. It’s not just the Data Scientists that complain about it though, it’s pretty…

How to Clean Data Using Excel COUNTIF

How to Clean Data Using Excel COUNTIF

​Cleaning numerical data can take a ridiculous amount of time​, but learning to use ​Excel COUNTIF can save you a lot of time and 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 the dataset! Bless him, he doesn’t understand. He…

Do NOT follow this link or you will be banned from the site!