Member of the orgies Data? Clean Sweep.

By Melanie DG Kaplan / June 1, 2014 (Getty RF)

Elisabeth Engel, CEO and chief strategist of Spark Consulting, co-author of the recently published White Paper "Introduction to the good stuff. Associations decision based on evidence" to download here .

Tips on how to deal with cleaning the old data, the members of the dining rooms.

Faulty. Orgies. Inconsistent. Dirty. Call it what you want but a large amount of data is collected over the years, is not clean. This is where one of the biggest challenges for companies, says Peter Houstle, CEO of Mariner Management and Marketing. "It means that the data does not compare the chaotic analysis," he said. "This complicates the process of data management."

What exactly is data mess? This is data that does not beat (for example, is a member is 150 years old, or that someone completed their residence in the previous year of medical school, he completed); Data has an incorrect or inconsistent formatting (such abbreviated report defined by Maryland MD); outdated addresses; and records.

Often the data are results in disorder the absence of rules: What is a current member who is a member of the past, which is a view, and what a person against a member?

If these rules are not documented, the staff everything else. "There are rules that you need to strengthen them, and you need a review mechanism," says Elisabeth Engel, CAE, Executive Director and Chief Strategy Consulting Spark.

If you find that colleagues make mistakes, and they will, because the less frequent usage not know the rules and the employees who want an audit trail, Angel said, so you can see which users have difficulty governed.

Often, when leaders of the Association to discover the extent of their data in the disease, are discouraged. "Partnerships simply throw up their hands right now, even before you start," said Engel. But she warns that he not give up easily. Taken in small doses, and starting with the biggest problems, clean the housing data should not be so scary. "The biggest mistake to make the organizations," she said, "say it's too hard."

Share this article

We will not sell your email address.

Sift skills: The value of Big Data for clubs Melanie DG Kaplan

Data Security: Keep the lid on Mark Athitakis

Four steps to enhance the security associations database for Mark Athitakis

This entry passed through the Full-Text RSS service - if this is your content and read on the website of another person, please read the FAQ at fivefilters.org / content / faq.php # publishers only.