Exercise Files

You can download all Monarch exercise files here: Monarch Sample Files for Exercises

• Composers.txt

 

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?

 

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.