Exercise Info

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

Exercise Overview

You are a Sales Operations Analyst working at a Grocery chain and your manager has asked you to answer the following questions using Altair Monarch Classic by analyzing the Grocery.txt file:

1. What is the Total Sales for the day?
2. Which Department (Produce, Bakery, Dairy) generated the most sales?
3. Which Department (Produce, Bakery, Dairy) generated the most sales?

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.