Skip to Main Content
Databases for Small Business: Essentials of Database Management, Data Analysis,and Staff Training for Entrepreneurs and Professionals
book

Databases for Small Business: Essentials of Database Management, Data Analysis,and Staff Training for Entrepreneurs and Professionals

by Anna Manning
November 2015
Intermediate to advanced content levelIntermediate to advanced
336 pages
7h
English
Apress
Content preview from Databases for Small Business: Essentials of Database Management, Data Analysis,and Staff Training for Entrepreneurs and Professionals

CHAPTER  10

Cleansing Your Data

Every set of data contains some errors. Detecting and removing these oversights, known as data cleansing, can often be a lengthy process. However, efficient data cleansing is essential in order to be able to come to accurate conclusions from data analysis. In addition, one of the principles of the Data Protection Act (described in Chapter 8) is to ensure that your data is accurate and, when necessary, is up to date.

Overview

Data cleansing comprises three main steps:

  1. Detecting the errors
  2. Selecting and applying the most appropriate methods to correct the errors
  3. If possible, preventing the errors from happening again

The process of data cleansing is usually open-ended, as some errors are hard to find and eliminate. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Business Intelligence Tools for Small Companies: A Guide to Free and Low-Cost Solutions

Business Intelligence Tools for Small Companies: A Guide to Free and Low-Cost Solutions

Albert Nogués, Juan Valladares
Express Learning: Database Management Systems

Express Learning: Database Management Systems

ITL Education Solutions Limited

Publisher Resources

ISBN: 9781484202777Purchase book