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:
- What is the total quantity (count) and total sales (USD) by month?
- Which Media type had the most sales (USD)?
- Who are the top 5 Customers based on total sales (USD)?
- What are the top 5 Media Description Products by quantity (count)?
- 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.
