Order custom papers, masters thesis and dissertation in 3 guided steps; human written!
Posted: March 4th, 2021
Assessment 2: Data Cleansing & Conversion (20%)
Overview of Tasks
Task: Data Cleansing and Conversion
Individual or Team 2/3
Due Date: See VU collaborate
Details of the task
During software implementations data transfer and the set-up of periodic/permanent interfaces is one of the most costly and time-intensive work packages. Several market studies have shown that, on average, data transfer accounts for 20% of implementation costs. In individual cases it can exceed that amount. In order to perform the initial data transfer from non-SAP systems, you need to efficiently carry out the following steps:
1. Identify data to be transferred in the legacy system and, if possible, eliminate (Clean up/filter) obsolete data and inconsistent data records at the same time.
2. Extract relevant data and write it to an ASCII file.
3. Convert the data from ASCII format to the object-specific data format required by SAP.
4. Process the converted data file based on BAPI, batch input or direct input technologies using SAP Load Programs (load).
5. Run your own check programs (if available) to further examine the results of the data transfer. You can compare information such as the number of open items or the number of materials in both systems. Basic consistency checks are run during loading, as R/3 does not allow the creation of inconsistent data sets.
You will be given two files (both in the single spreadsheet file), the first a file containing 199 records (File 1) of customer data. This is the file that will be converted. The second file contains about 10 records (File2) and becomes the template file. Using a package cleanse the 199 customer records. Use another package to convert the customer data into the same format as your template file.
What to hand-in
Student declaration form with % participation included and team number. File of cleansing
File of conversion
Word file with assumptions and screen captures describing the process of cleansing and conversion in full.
Final output file (in xls or txt or csv format) after cleansing and conversion
Introduction
KKAE is an industrial company that is undergoing an SAP implementation The rollout has reached the phase of data conversion and migration. This deliverable aims to show the procedures of how KKAE Pte. Ltd handled the data cleansing and data mapping based on a list of employees who were using SAP system in KKAE. The conversion is based upon a set of business assumptions.
Details
Two files are used in this activity. The first file is a list of employees who are using SAP system. The list contains their contact and SAP access information. Some of the information is duplicated, and some
file:///C:/Users/Komal/AppData/Local/Temp/Temp1_Assessment 2.html.zip/Assessment 2.html 1/2 13/09/2020 Template styles
information contains human-unreadable characters or invalid data. The other file is a template that shows the required layout format of the final output list.
The main objectives of this activity were as follows:
Mark all the duplicated data with proper error flags.
Mark all the missing data with proper error flags.
Verify the human-unreadable characters, then take proper action on it; either remove the humanunreadable character or correct the unreadable character.
Verify and mark all the invalid data with proper error flags, then correct it.
Once the data is cleansed, map the data based on the template’s pre-defined layout and create the final list.
Preparation
Download Mapforce or become familiar with the software package you are using to complete this task
Assessment Criteria and Submission
I need help writing my essay - research paper read the rubric set up for this assessment task carefully. These are the criteria that you will be assessed against for this task. It is important that you read and understand the rubric before you attempt to write this essay. Understanding the criteria written in this rubric will help you clarify what we are looking for in this assessment.
The rubric for this task can be viewed in unit guide.
You will be able to submit multiple files per submission and submit your files more than once.
file:///C:/Users/Komal/AppData/Local/Temp/Temp1_Assessment 2.html.zip/Assessment 2.html 2/2
You Want Quality and That’s What We Deliver
We’ve put together our writing team with care, choosing talented writers who shine in their fields. Each one goes through a tough selection process, where we look for folks with deep expertise in specific subjects and a solid history of academic writing. They bring their own mix of know-how and flair to the table, making sure our content hits the mark—packed with info, easy to read, and perfect for college students like you.
We don’t do AI-written essays or copycat work—everything’s original. Competitive pricing is a big deal for us; we keep costs fair while delivering top-notch quality. Our writers are some of the best out there, and we charge rates that stack up well against other services. This means you get stellar content without draining your wallet. Our pricing is straightforward and honest, built to give you real value for your money. That’s why students turn to us for high-quality writing services that won’t break the bank.
Academic integrity is at the heart of what we do. Every paper starts from scratch, with original research and writing tailored just for you. We write 100% authentic—no plagiarism research essays. Our strict quality control process includes scanning every draft with top tools like SafeAssign and Turnitin, so you get a similarity score and proof of originality. We’re obsessive about proper citation and referencing too, crediting every source to keep things legit. It’s all about giving you peace of mind with content that meets the highest standards.
When you decide to place an order with Dissertation Writer, here is what happens: