Data Cleaning News

Survey Data Analysis

So you have designed your survey, collected your data and now its time to analyze your survey results. So where do you start? What techniques do you use? How to represent your insights? This post will show you how to get the most of your survey. Starting Survey Analysis: Before you begin the analysis, you…

Making SEO work for your business in 2019

With there being almost 2 billion websites on the internet at the start of 2019 (webitehostingrating.com), businesses can ill afford not to be found via search engines. For those that are starting out, marketing budgets tend to be tight and it simply isn’t possible to compete with the deep pockets of the competition which makes…

What is Data Standardization?

Data standardization is the process of fixing data into a common format. Not all data can be standardized and it is different than data normalization, which focuses on the formatting of data rather than the actual data content. Below is what you need to know about data standardization. Example of Data Standardization: For example, your…

The importance of phone verification

At a time where customers can communicate via several channels, the quality of the contact data a business holds is heavily important. Although some organizations are beginning a digital transformation journey (deploying processes online), there is still a reliance on offline activities such as call centers to deliver a superior customer service. More than three…

Duplicate Definition – For De-duping

Part of data cleaning is de-duping. But before you can begin your de-duping process you need to define what a duplicate is. Duplicate definition is the most important part of any deduping process, and therefore it is usually step one. Here is what will happen if you do NOT define what makes a record a…

How to dedupe in Excel

Deduplication is a method used to eliminate redundant copies of data from a database with the objective of reducing storage and cost whilst improving customer experience and loyalty. Something like 2.5 quintillion bytes of data are produced each day and that is only accelerating with the growth and buzz around Big Data and the Internet…

Data Cleansing Prior to Migrating to Ad Sales Genius

Migrating to a new CRM is a great time to review your advertiser and leads data. While busy managing your day to day, it is easy to add incomplete information, forget about maintaining records for years ago and create duplicates. However, migrating to ad sales genius (ASG) is a great opportunity to get your data…

How to Measure Data Quality Metrics

In the digital world and with the rise of Big Data, it has never been more important for a business to keep on top of their data quality. Whether it be consumer behaviour, predictive analytics, product information or even compliance and risk related tasks, companies need to store and analyze vast amounts of data every…

Data Quality Assessment

What is Data Quality Assessment? Data quality assessment also known as a data audit. Is an assessment or analysis of the quality of your data. Data should be complete, current, correct and consistent, and not include duplicates. While no database can be 100%, it can come close. To measure the quality of data some companies…