70.2K

Verified Solution

Link Copied!

1. Obtain the raw data from the source system and the migrated data from the ERP system. 2. Ensure that the two files are joined by an XLOOKUP on the field Transaction ID. 3. Answer the following questions to reconcile the two files. Now it's your tum to evaluate, analyze, and communicate the results! Questions 1. What was the total dollar amount of sales recorded in the source system for the selected day? 2. What was the total dollar amount of sales recorded in the ERP system for the selected day? 3. How many transactions match in the source system and the ERP system from the data. chosen for testing? 4. When comparing the source system and ERP system data, how many transactions were recorded in the source system but not in the ERP system? (Hint: Listed as "\#N/A.") 5. For the transactions recorded in the source system but not in the ERP system, in which states were the missing transactions? 6. What was the total dollar amount of the transactions that were missing from the ERP system? (Hint: Round up.) 7. When analyzing the dollar amount in the ERP system, what was the largest order of the day for the southwest region? In which state was that order placed? 8. When analyzing the dollar amount in the ERP system, what was the lowest order of the day for the southwest region? In which state was that order placed? Take it to the next level! 9. For the transactions that matched in the source system and the ERP system (not "\#N/A"), how many transactions differed in dollar amount? 10. For the transactions that matched in the source system and the ERP systern (not "\#N/A") in the state of Texas (TX), how many transactions differed in dollar amount? 1. Obtain the raw data from the source system and the migrated data from the ERP system. 2. Ensure that the two files are joined by an XLOOKUP on the field Transaction ID. 3. Answer the following questions to reconcile the two files. Now it's your tum to evaluate, analyze, and communicate the results! Questions 1. What was the total dollar amount of sales recorded in the source system for the selected day? 2. What was the total dollar amount of sales recorded in the ERP system for the selected day? 3. How many transactions match in the source system and the ERP system from the data. chosen for testing? 4. When comparing the source system and ERP system data, how many transactions were recorded in the source system but not in the ERP system? (Hint: Listed as "\#N/A.") 5. For the transactions recorded in the source system but not in the ERP system, in which states were the missing transactions? 6. What was the total dollar amount of the transactions that were missing from the ERP system? (Hint: Round up.) 7. When analyzing the dollar amount in the ERP system, what was the largest order of the day for the southwest region? In which state was that order placed? 8. When analyzing the dollar amount in the ERP system, what was the lowest order of the day for the southwest region? In which state was that order placed? Take it to the next level! 9. For the transactions that matched in the source system and the ERP system (not "\#N/A"), how many transactions differed in dollar amount? 10. For the transactions that matched in the source system and the ERP systern (not "\#N/A") in the state of Texas (TX), how many transactions differed in dollar amount

Answer & Explanation Solved by verified expert

See Answer