Monarch Learning Series 2023 Exercise 10 - 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)

Answer

• Please upload your answers below in the comment section for the exercise
• A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.

Altair_CommunityBlog_Default-15.jpg

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

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

Matthew Morris

Hello, All.

Here is my attempt for Exercise 10.

Thanks,

Matthew

National_Stock_Number.xlsx