Exercise Files

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

• 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?

 

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.