Monarch Learning Series 2023 Exercise 10 Solution: National Stock Number Analysis

Baba_Majekodunmi_703

 

Exercise Info

• Application (Classic vs Data Prep Studio): Data Prep Studio
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
• Skills/Features Tested: Append, Join (Inner Join), Negative Join, Analyze
  
• Systems of Record: Not Applicable
  
• Estimated Time to Solve: 10 mins
• Exercise files required are attached in the Zip File Below;
  
  • National Stock Number Extract-2-21-23.xlsx
  • National Stock Number Extract-3-17-21.xlsx

Exercise Overview

You are a Budget Analyst at a Federal Agency and you want to analyze National Stock Number data to help prepare for budget season by answering the following questions:

1. What is the Total Number of items grouped by "rep_office" for both Excel files?
2. How many items exist on both Excel files?
3. How many items don't exist on the both files? (ie, what items are on the 2-21-23 file, that are not on the 3-17-21 file, and vice versa)

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.

 

 

 

Monarch Learning Series Exercise 10 - National Stock Number Analysis.dpwx

National Stock Number Extract-2-21-23.xlsx

National Stock Number Extract-3-17-21.xlsx