Chi-Squared Innovations Blog Discover Data Blog Series Top 12 Tips - What To Do With Data Data is information collected from the 'Real World' and transformed into a form that is amenable to analysis. The analysis can then tell us 'What The World Is Like' and even predict the future - if done properly.... Data Types 101 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 right place. Here is our guide to data types and how to deal with them... 11 Essential Tips for Effective Data Collection Collecting data is serious business. Get it right and your analysis can go relatively smoothly, but get it wrong and you're in for a world of pain. Here are 11 essential and completely painless tips that'll get you off to a great start 5 Productivity Tips for Efficient Data Cleansing Now that you've collected your data, your next job is to clean it. This is a job that can be painful, thankless and can take you weeks, so it pays to be organised. Here are 5 tips that will help you get through it quickly and easily Top 3 Tips for Data Classification You've collected and cleaned your data, so you now have a perfectly clean dataset. You still have some work to do before you can start analysing it - you need to learn how to classify data, and that is what we’ll learn here How to Clean Your Data Quickly in 5 Steps Data cleaning is all about getting organised, and this blog post will introduce you to the 5 steps that will help you put the basics in place. Once you've got these, the rest will follow How to Clean Text Data Without Manual Data Manipulation In this blog post I will show you how to combine Remove Duplicates and VLOOKUP in a way that is different to what Microsoft intended but which is actually a lot more powerful. How to Clean Numerical Data in Excel Using COUNT & COUNTIF In this blog post I will show you how to use COUNT & COUNTIF to get a good 'feel' for your data, and use them to help you to get your numerical data clean in double quick time.