Altair Monarch Exercise 2 - Classic

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited January 2023 in Altair RapidMiner

Exercise Info

  • Application (Classic vs Data Prep Studio): Classic
  • Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
  • Skills/Features Tested: Report Trapping, Filters, Calculated Fields, Summary
  • Systems of Record: Not Applicable
  • Estimated Time to Solve: 15 mins
  • Exercise files required are attached
    • Classic.txt
    • ClassFeb.txt
    • ClassJan.txt
    • Class.Mar.txt

Exercise Overview

You are a Sales Operations Analyst, and you need to analyze sales for Media types over a 4-month period (Jan-Apr). Your manager wants you to answer the following questions using Altair Monarch Classic:

  1. What is the total quantity (count) and total sales (USD) by month?
  2. Which Media type had the most sales (USD)?
  3. Who are the top 5 Customers based on total sales (USD)?
  4. What are the top 5 Media Description Products by quantity (count)?
  5. What was the total quantity (count) and dollar amount (USD) for returns?

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:

Categories