Altair Monarch Exercise 3 - Composers Analysis

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Classic
• Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate
• Skills/Features Tested: Report Trapping, Multi-Column Region, Summary
  
• Systems of Record: Not Applicable
• Estimated Time to Solve: 15 mins
• Exercise files required are attached
  • Composers.prn

Exercise Overview

You are an Operations Analyst, and you need to analyze the most popular composers by customers. Your manager wants you to answer the following questions using Altair Monarch Classic:

1. What is the total count of Composers by Contact & Account Number?
2. Who are the top 5 Composers for the following Contacts; Betty Yoder, Bill Saxman, and Howie Franklin?
3. Who are the bottom 5 Composers for the following Contacts; Alain Lebon, Lidia Rosado, and Maria Seefeld?

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

Composers.txt