Discover Data

Recent Post

How to Clean Text Data Using Excel VLOOKUP

How to Clean Text Data Using Excel VLOOKUP

​In this blog post I’m going to show you how you can combine Excel VLOOKUP with Remove Duplicates ​to clean text data.​​​It’s interesting that there is plenty of information in Excel’s help files about the way Microsoft suggests that you use ​these functions, but nowhere do they mention that you can use them to clean text…

Data Coding – Top 3 Data Classification Tips

Data Coding – Top 3 Data Classification Tips

​This blog post is all about data coding, and will give you our top 3 tips on how best to code your data. ​It is the third blog post in the series, following hot on the heels of 11 Essential Tips for Effective Data Collection and 5 Data Cleaning Techniques You Need To Learn. Here we deal with coding…

5 Data Cleaning Techniques You Need To Learn

5 Data Cleaning Techniques You Need To Learn

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 will teach you the 5 most important data cleaning techniques that you’ll ever need​. Data cleaning may not be everyone’s favourite part of working with data, but…

Data Collection Techniques – 11 Essential Tips

Data Collection Techniques – 11 Essential Tips

​This blog post will deal with data collection techniques and good data management practices in Excel, and will give you some great tips on how to get organised and avoid making the kind of mistakes that will make you prematurely grey!Over the next couple of weeks I will deal with other important issues such as…

4 Types of Data in Statistics. What Are They?

4 Types of Data in Statistics. What Are They?

Did you know that there are only 4 types of data in statistics? Do you know what they are and what you can do with them? Have you ever looked at your data and wondered how and where to get started? If you don’t know the difference between quantitative data and qualitative data then you’re in the…

What Do Data Scientists Do With Data?

What Do Data Scientists Do With Data?

Have you ever wondered ‘what do Data Scientists do with data’? Well, we’ve got the answer for you. In this blog post we ask (and answer) the questions what is data?, why is data so important?, what can you do with data? and what do Data Scientists do with data? Better still, we give you our Top 12…

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