Question

Outline some specific steps an organization might take to perform data cleansing to ensure the accuracy...

Outline some specific steps an organization might take to perform data cleansing to ensure the accuracy and completeness of its customer database before adding this data to a data warehouse. How would you decide when the data is accurate enough?

Homework Answers

Answer #1

Answer: Introduction:

Associations need to have a refreshed database, both for guaranteeing productive contact with their clients and keeping up consistency gauges. Data Cleansing or data scouring is the way toward distinguishing and remedying mistaken data from a data set. Regarding client data, data cleansing is the way toward keeping up reliable and exact (clean) client database through ID and evacuation of erroneous (filthy) data. Here, off base data represents any data that is off base, fragmented, obsolete, or wrongly designed.

A definitive objective of data cleansing and keeping up a perfect client database is to make a "solitary client see" implying that there is just one record for every client that contains all their significant data. This procedure of data cleansing and keeping up a clean client database offers different advantages to business, including:

  • Data cleansing is a basic instrument that helps in keeping up consistency with the Data Protection Act
  • Data cleansing assists with lessening wastage as off base messages and saves money on mailing costs.
  • Keeping up a perfect database takes into account a quick area of significant client data and diminishes administration reaction time.
  • It additionally improves the administration quality as every single significant datum is situated at the same spot and results in better client experience.
  • Clean client data can give increasingly precise possibility data prompting better deals focusing on and the executives.

Methodology to Cleanse Customer Data:

  • Data Auditing: The initial move towards data cleansing, is the finished examining of all client databases. The reviewing ought to be finished utilizing factual and database techniques to recognize irregularities and mistakes. The data ought to be utilized to induce qualities and areas of inconsistencies, which can prompt the underlying driver of the issue.
  • Utilize Multiple Methods: The procedure of reviewing a database ought not to be restricted to investigation through measurable or database techniques and extra advances like purchasing outer data and looking at it against inside data can be utilized. Also, if an association has imperatives of time and staff, it can utilize the administrations of outside selling organization. In any case, in this methodology, the association should be wary of regard to their image picture and the method of working of the outer organization.
  • Unite Data: The way toward cleansing the database ought not to be restricted to simply the recognizable proof and expulsion of grimy (wrong) data from the client database. It ought to be utilized as a chance to unite client data and extra data like email addresses, telephone numbers or extra contacts ought to be joined at whatever point conceivable.
  • Criticism: The association ought to set up a control system where any erroneous data gets announced and gets refreshed into the database. For instance, there ought to be a control and input system for messages, and any email which is undelivered inferable from an erroneous location, ought to be accounted for and the invalid email address purified from the client data.
  • Rehash: Individuals' lives are progressively getting dynamic thus related subtleties like locations, phone numbers, organization email-id, change now and again. Along these lines, the procedure of data cleansing ought not to be thought of as a one-time process; rather, it should make a piece of the normal work process. Standard wedding of mistaken data and refreshing client database is the main course towards guaranteeing a clean client database.

Conclusion:

Data cleansing is a troublesome yet basic procedure and requires devotion of submitted time and assets. The methodology referenced above would unquestionably help in the making of a spotless client database which offers numerous advantages across capacities and fills in as a basic factor in the development of business. Thus, organizations should make an interest in data cleansing and data management the first concern.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Outline some specific steps an organization might take to perform data cleansing to ensure the accuracy...
Outline some specific steps an organization might take to perform data cleansing to ensure the accuracy and completeness of its customer database before adding this data to a data warehouse. How would you decide when the data is accurate enough?
You are a nurse caring for a 47-year-old patient who is homeless. He is admitted to...
You are a nurse caring for a 47-year-old patient who is homeless. He is admitted to your unit two to three times per year. His medical history includes diabetes mellitus (type 2), hypertension, and alcoholism. After extensive hygienic interventions (to decrease his body odor, wash his hair, and perform oral care), you complete your assessment and find that he is not in compliance with any of his dietary and medication instructions from his last admission. Considering his history, what types...
passage require analysis and breakdown Workforce scheduling is huge in hospitals, especially at this time. An...
passage require analysis and breakdown Workforce scheduling is huge in hospitals, especially at this time. An influx of traveling nurses has sprouted from this pandemic due to the rates that hospitals are willing to pay for contracted employees to come in and help with the relief effort. With this, it is important to know the lengths of the contracts and the amount of capital it is going to take to secure each of the temporary employees. Form there, the needs...
CASE STUDY: DATA WAREHOUSING AT VOLVO Every Volvo car has hundreds of microprocessors and sensors. Their...
CASE STUDY: DATA WAREHOUSING AT VOLVO Every Volvo car has hundreds of microprocessors and sensors. Their data is used in diagnosis and repair. It is also captured by Volvo, integrated with the company's CRM, dealership and product data stores, and stored for analysis. This enables Volvo to spot design and construction flaws early, enable proactive correction of faults, and see how its cars respond in accidents. Volvo sells about 400,000 cars per year. Each generates 100–150 kB of data per...
Response for those questions please,  "Resumes and Other Employment Materials" in Strategies for Technical Communication . (...
Response for those questions please,  "Resumes and Other Employment Materials" in Strategies for Technical Communication . ( please don't copy from any website, your own word) Despite the many online job search tools available, why does our textbook say that "The human connection is always the best way to start looking for a job" (133)? Who are some people you could talk to on campus for job search help? Are there people you know outside of campus that could be resources...
CASE STUDY: DATA WAREHOUSING AT VOLVO Every Volvo car has hundreds of microprocessors and sensors. Their...
CASE STUDY: DATA WAREHOUSING AT VOLVO Every Volvo car has hundreds of microprocessors and sensors. Their data is used in diagnosis and repair. It is also captured by Volvo, integrated with the company's CRM, dealership and product data stores, and stored for analysis. This enables Volvo to spot design and construction flaws early, enable proactive correction of faults, and see how its cars respond in accidents. Volvo sells about 400,000 cars per year. Each generates 100–150 kB of data per...
CASE STUDY: DATA WAREHOUSING AT VOLVO Every Volvo car has hundreds of microprocessors and sensors. Their...
CASE STUDY: DATA WAREHOUSING AT VOLVO Every Volvo car has hundreds of microprocessors and sensors. Their data is used in diagnosis and repair. It is also captured by Volvo, integrated with the company's CRM, dealership and product data stores, and stored for analysis. This enables Volvo to spot design and construction flaws early, enable proactive correction of faults, and see how its cars respond in accidents. Volvo sells about 400,000 cars per year. Each generates 100–150 kB of data per...
Draw an E-R diagram pls Required Data The data items required for the train reservation database...
Draw an E-R diagram pls Required Data The data items required for the train reservation database can be classified into six categories: trains, stations, train schedules, reservations, customers and employees. The above classification does not imply any particular table arrangement. You are responsible for arranging the data items into tables, determining the relationships among tables and identifying the key attributes. Finally, you should specify and enforce integrity constraints on the data, including referential integrity constraints. You will first create an...
Case Study Big Data Stewart Clegg Radically changing your business due to disruptive innovation requires a...
Case Study Big Data Stewart Clegg Radically changing your business due to disruptive innovation requires a different approach. When dealing with disruptive innovation, the alignment and/or realignment of an organization’s assets might not be enough to sustain competitive advantage. When newcomers use the latest technology to disrupt an entire industry, the incumbents will need to take drastic measures to change their organization. The emergence of strategies driven by Big Data means a transition to a data-driven, information-centric organization consisting of...
American Water, founded in 1886, is the largest public water utility in the United States. Headquartered...
American Water, founded in 1886, is the largest public water utility in the United States. Headquartered in Voorhees, N.J., the company employs more than 7,000 dedicated professionals who provide drinking water, wastewater and other related services to approximately 16 million people in 35 states, as well as Ontario and Manitoba, Canada. Most of American Water’s services support locally-managed utility subsidiaries that are regulated by the U.S. state in which each operates as well as the federal government. American Water also...