Sleep Easy Hotel is a boutique hotel, and they are committed to community development. They want...

Transcribed Image Text:

Sleep Easy Hotel is a boutique hotel, and they are committed to community development. They want to initiate a "buy local" strategy to support the local businesses. You are a managerial accountant, and you need to analyze their existing vendors to determine if they are local businesses. You are performing ETL on vendor data. For each data preparation pattern, discuss the data problem, discuss how the data issue can be detected, and discuss how to correct the following problems: irrelevant data inconsistent values incomplete values VendorID Customer Street City State ZIP 81110 Better Bags null Dallas Texas 75225 81112 Coffee Stop 342 First St. Fort Worth TX C76164 81114 Office Plus 234 Main Street Austin Tx 81116 Green Plus 99 Broadway Ave Atlanta GA 3038 Sleep Easy Hotel is a boutique hotel, and they are committed to community development. They want to initiate a "buy local" strategy to support the local businesses. You are a managerial accountant, and you need to analyze their existing vendors to determine if they are local businesses. You are performing ETL on vendor data. For each data preparation pattern, discuss the data problem, discuss how the data issue can be detected, and discuss how to correct the following problems: irrelevant data inconsistent values incomplete values VendorID Customer Street City State ZIP 81110 Better Bags null Dallas Texas 75225 81112 Coffee Stop 342 First St. Fort Worth TX C76164 81114 Office Plus 234 Main Street Austin Tx 81116 Green Plus 99 Broadway Ave Atlanta GA 3038