Task:
You have done such a good job with forecasting and cleaning data from Vandelay Industries that they have asked you to do some further cleaning of their data. The sales group is suspicious that there might be errors in the data for January.
You will be working with a new set of 3,296 orders with 5,182 line items from January 2014. The data is in a file called “VandelayJan2014.xlsx.” A “line item” is just an order for a specified number of a particular product – there can be multiple line items per order.
You’ll be looking for errors in the data in several places:
- Errors in the product names.
- Errors in the promotional codes.
- Errors in the total product price.
You will find, document, and correct the errors in the Excel workbook.
Use these files for the assignment: