Monarch Learning Series 2023 Exercise 7 - Order Status 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: Join (LookUp), Template End Field On Settings, Formula Field, Analyze
  
• Systems of Record: Not Applicable
• Estimated Time to Solve: 10 mins
• Exercise files required are attached
  • Order Status.txt
  • DiscountCode.xlsx

Exercise Overview

You are a Sales Operations Analyst, and you need to analyze sales data of recent Orders by Customer to answer the following questions:

1. What is the Total Sale Amount by Store ID?
2. Using the DiscountCode spreadsheet, determine the Total Discounted Sale Amount by Store ID
3. Determine How many records contain the word 'BACKORDER'?

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-11.jpg

DiscountCode.xlsx

Order Status.txt

Susan DeWitt

Is there a way to name a filter like in Monarch Classic?

Order status.xlsx