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

  • 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
  • Better Essays

    We also see a plan designed to not only implement a new system but also a designed plan to make sure that the system will be adequate for the expected development of this organization. Shown also in this briefing is how the growth of this organization is demanding a growth in the information technology that this organization will need to move forward into the future. The stakeholders’ influence is also covered in this briefing. Showing the benefit of our stakeholders and examples of these benefits gives proof that the move to a new system is beneficially for us all. That being said the belief is that a new system is necessary and needs to be implemented soon. Employees have the important part of implementing the changes that will take place. They are to try and show how using the new information system will benefit the organization, and possibly save money. Investors relay information between the other organizations. The community within which an organization operates shows support to the organization and allows the community to make their decisions, what they want to take place, and what they know about the new…

    • 948 Words
    • 4 Pages
    Better Essays
  • Best Essays

    Enterprise Resource Planning (ERP) is identified as the essential platform upon which companies are building their competitive business process upgrades (Caruso 2003). An ERP system is an integrated software solution that spans the range of business processes that enables companies to gain a holistic view of the business enterprise. It promises one database, one application, and a unified interface across the entire enterprise (Bingi, Sharma & Godla 1999). Due to the fact that ERP systems provide companies with a means to have an integrated and unified business process, companies have not been swayed from investing large amounts of money on…

    • 1829 Words
    • 8 Pages
    Best 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
  • Satisfactory Essays

    chapter 6 case study

    • 387 Words
    • 2 Pages

    There are many things Wal-Mart has done to improve its data communications systems for suppliers. Their chief improvement was the implementation of the sales and inventory data to their suppliers. Suppliers could log in and gain access to all of the sales and inventory data to more efficiently stock Wal-Mart with their products. A key component of data security was also implemented with the vendor data site to prevent vendors from accessing each other’s data and compromising proprietary information (Viskovich, 2008, p. 1).…

    • 387 Words
    • 2 Pages
    Satisfactory 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