Monarch Learning Series 2023 Exercise 7 - Order Status Analysis

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited June 2023 in Altair RapidMiner

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.
Tagged:

Comments

Categories