Cleansing Client Data The client has provided you with the following data files: a. unsold ticket sales
Fantastic news! We've Found the answer you've been seeking!
Question:
- Cleansing Client Data The client has provided you with the following data files:
a. unsold ticket sales revenue
b. champion's club ticket revenue
d. single-game ticket sales, by game
e. issued tickets, by game
Required:
When using the above information for the purposes of performing analytical procedures, data must be cleansed prior to use. Consider the following common issues found in cleansing data and provide documentation of the number of instances of the following. You may also provide documentation of any other data anomalies you find.
i. Duplicate listings- ii. Missing items from a sequence
- iii. Dates outside of appropriate range
- iv. Characters in a numeric column
- v. Apparent issues with data truncation, either missing rows, or limited characters in a column
Related Book For
Introduction To Federal Income Taxation In Canada
ISBN: 9781554965021
33rd Edition
Authors: Robert E. Beam, Stanley N. Laiken, James J. Barnett
Posted Date: