Preview

4 Critical Success Factors to Cleansing Data

Powerful Essays
Open Document
Open Document
2574 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
4 Critical Success Factors to Cleansing Data
4 Critical Success Factors to Cleansing Data

Abstract:
This article briefly recaps the value of quality data in the supply chain and the challenges with today’s automated mass sharing of information with internal and external customers.
This article addresses how we all got here and what we can do about it. There are four critical success factors of 1) Scope, 2) Team, 3) Process and 4) Technology and this article will give you the stepping stones to be successful in cleaning your critical data.

Executive Summary of the issue: Think of data cleansing as system immunization.

Competition for business has fuelled system complexities. We are clearly in the information age. There is more data being sent around the world today than ever, and this is only going to grow exponentially. To have the competitive edge today you have to be able to share clean, accurate data quickly. It’s not enough just to have a good product, your customers have to recognize the right product, color and size from a internet catalogue, the system has to process the correct item on the order and send the information to distribution systems, distribution has to pick and ship the right item. All of this is dependent on each system being able to share and communicate the same product item data.
The pace with which companies are forced to operate and to compete globally has taxed existing systems and increased their inefficiencies. Mergers and Acquisitions have introduced new ERP implementations, forced incorporation of legacy systems, merged processes, combined products, and consolidated customers. Technology has moved forward but so has the creativity of the humans forcing the data requirements into fields and applications to meet their business needs to keep existing customers satisfied or to capture new sales. Gartner research firm indicates that the average Fortune 100 organization has more than eight data stores, 15 information platforms, 10 critical systems, and

You May Also Find These Documents Helpful

  • Powerful Essays

    Bjb Business Plan

    • 2427 Words
    • 10 Pages

    Foster, T. S. (2007). Managing quality; integrating the supply chain (3rd ed.). Upper Saddle River, NJ: Pearson, Prentice Hall…

    • 2427 Words
    • 10 Pages
    Powerful Essays
  • Powerful Essays

    Dcsn Case

    • 3448 Words
    • 14 Pages

    This case indicates that WoodSynergy Inc. is a midsize corporation in the fine woods supplier business, and the enterprise had lately launched Information technology based supply chain management schemes and was concerned in evaluating the development. They realized that efficiency can be improved by integrating information technology into their systems. They were capable of figuring out the importance of having information which is aligned with their business data. Enhanced data sharing would allow the company to meet order demand and deliver on time with the highest quality.…

    • 3448 Words
    • 14 Pages
    Powerful Essays
  • Better Essays

    Not using the proper information system can mean the difference between success and failure. Information systems are costly, but the costs incurred by not having such as system can be detrimental. The world 's largest retailer, Wal-Mart, uses the Smart Inventory System in its business dealings. (Walmart 2011) Walmart 's system uses the bar code scanner to enter an…

    • 1258 Words
    • 6 Pages
    Better Essays
  • Satisfactory Essays

    Case Study

    • 599 Words
    • 3 Pages

    A common issue in all three organizations is they had grown out of the systems that help build their enterprises, however they were now dealing with a global economy and the need to have a system where information was easily stored and viewed was necessary in order to stay completive in their markets. Customer demands were now more demanding where the need for many combinations and variety of their products had to be available and ready to deliver at very short lead times. In order to do this, the ERP systems had to be able to track all orders from order entry to delivery to the customer. At the same time, inventories had to be maintained, production schedules had to be accurate and business processes needed had to be foolproof.…

    • 599 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    R.L.Polk Case Study

    • 1399 Words
    • 6 Pages

    The analysis of the article “SOA Case study: How R.L. Polk revved their data engine” reveals a similar dilemma faced by a company whose core business of data aggregation depends on Information Technology. The Southfield, Mich.-based company’s Chief Information Officer Kevin Vasconi realized in 2004 that their existing technology infrastructure was unable to support their business needs in the coming decade. Although the executives at R.L. Polk agreed with Vasconi’s assessment, they were afraid of the risks that came with undertaking massive technology projects. It was this reluctance that resulted in failure during two previous scaled down attempts to upgrade the infrastructure.…

    • 1399 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    With changing times, systems need to have data energy uses calculated into the core processes to retain more accurate data. Measuring impact is the recognized way in which you show the value your organization is delivering to its recipients and the general public as a whole. Often, companies feel the need to cut internal energy use; therefore, they outsource data processing duties. Businesses must be cautious when outsourcing data. This outsourcing can cause serious issues if the outsourced work is inaccurate or worse, manipulated to cause intentional damage to the company. It is difficult to have patience with outsourced companies that produce inaccurate work, as that is the main objective: they were hired to do the job proficiently and accurately. Having internal processes in place for data formulas can cut down significantly on misuse and incorrect data entry, as well as cut back on security breaches. Making sure that the data is properly reduced and not just passed on to another person. Data accuracy is essential, we must heed caution when reviewing others data, how do we know the information is accurate and correct. Unfortunately, there are unethical practices within data processing, and there are companies who are more into financial gain rather than upholding moral responsibilities.…

    • 348 Words
    • 2 Pages
    Good Essays
  • Better Essays

    Nibco

    • 1087 Words
    • 5 Pages

    NIBCO’s Inc. is a midsized manufacturer of values and pipe fitting headquartered in Elkhart, Indiana (Brown, Dehayes, Hoffer, Martin & Perkins, 2012, p.468). NIBCO had over 3000 employees and reported $461 million annual revenue. The company implemented SAP R/3 among its ten plants and four new distribution centers. Top management did not take the advice of their consultants concerning taking a slower approach instead of the BIG Bang approach, instead they decided to go along with Boston Consulting Group (BCG) to eliminate the legacy system and replace them with integrated systems. There were four different types of legacy systems that supported the order entry, manufacturing, distribution and accounting functions (Brown et.al 2012, p.470). Different sections in the organization were using their own versions of manufacturing software package with separate database. NIBCO’s decided they needed standardized software across the company that’s how ERP package came about.…

    • 1087 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Homework

    • 750 Words
    • 3 Pages

    the network is overloaded. sellers and buyers have the same information. one party in a transaction has more important information than the other. manufactures provide online data to customers.…

    • 750 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Mis Assingment 2

    • 330 Words
    • 2 Pages

    The University of Pittsburgh Medical Center (UPMC) relies on information systems to operate 19 hospitals, a network of other care sites, and international and commercial ventures. Demand for additional servers and storage technology was growing by 20 per-cent each year. UPMC was setting up a separate server for every application, and its servers and other computers were running a number of different operating systems, including several versions of Unix and Windows. UPMC had to manage technologies from many different vendors, including Hewlett-Packard (HP), Sun Microsystems, Microsoft, and IBM. Assess the impact of this situation on business performance. What factors and management decisions must be considered when developing a solution to this problem?…

    • 330 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Data cleaning is the thorough and extensive checking for consistency and treatment of missing responses. This cleaning process includes consistency checks and treatment of missing responses. While preliminary consistency checks have been made during editing, the checks at this stage are more thorough and extensive, since these are made by computer. Consistency checks are a part of the data cleaning process that identify data that are out of range or logically inconsistent, or that have extreme values. Data with values not defined by the coding scheme are inadmissible. Missing…

    • 631 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Data Digitization is an inevitability in this age of information due to it vitality for any organization. In our current day competitive world technology is continuously altering in order to improve and smoothen our lives. For a business to operate effectively information needs to be easily available. Most information or data is stored in the form of paper files or reports, which accumulates over the years, leading to data damage and loss. It is a cumbersome procedure to obtain necessary data when it's really required.…

    • 354 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Kenya Airways Case Study

    • 1706 Words
    • 7 Pages

    Business information systems are the foundation for conducting business activities today. In most industries, the survival and even existence of an enterprise is difficult without extensively incorporating information technology. Information systems have thus become a crucial requirement in helping organizations operate in the global economy. On the other hand, organizations are trying to gain a competitive advantage and efficiency by transforming themselves into digital firms where nearly all core business processes and relationships with suppliers, employees and customers are digitally enabled. Businesses today use information systems for the achievement of six major objectives: gain operational excellence, create new products, services and support new business models, promote customer/supplier intimacy, improve decision making, gain competitive advantage and for day-to-day business survival.…

    • 1706 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    First of all, we believe that manage customer data in a responsible way requires an organizational culture strongly established with an ethic politics. If we don’t have a clear culture, each of the company members is going to have their own standards, habits and values that will create a huge hurdle in the data life cycle because we wouldn’t know how can be handle the information of our customers...…

    • 272 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    How to Sell Tampons

    • 28516 Words
    • 115 Pages

    Abstract As the business complexity, number of customers continues to grow and customers evolve into multinational organisations that operate across borders, many companies are faced with great challenges in the way they manage their customer data. In today’s business, a single customer may have a relationship with several entities of an organisation, which means that the customer data is collected through different channels. One customer may be described in different ways by each entity, which makes it difficult to obtain a unified view of the customer. In companies where there are several sources of data and the data is distributed to several systems, data environments become heterogenic. In this state, customer data is often incomplete, inaccurate and inconsistent throughout the company. This thesis aims to study how organisations with heterogeneous customer data sources implement the Master Data Management (MDM) concept to achieve and maintain high customer data quality. The purpose is to provide recommendations for how to achieve successful customer data management using MDM based on existing literature related to the topic and an interview-based empirical study. Successful customer data management is more of an organisational issue than a technological one and requires a top-down approach in order to develop a common strategy for an organisation’s customer data management. Proper central assessment and…

    • 28516 Words
    • 115 Pages
    Good Essays
  • Good Essays

    Another issue seen in the Costa Rican environment in level 1 companies, is the tendency to ignore data quality problems that are obvious and expect that they will disappear on their own accord. The moment one identifies a data quality issue one…

    • 903 Words
    • 4 Pages
    Good Essays