Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Monarch Learning Series 2023 Exercise 2 - Grocery Analysis

Baba_Majekodunmi_703 · 2023-01-31T04:01:37+00:00

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 *…

Baba_Majekodunmi_703

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:

What is the Total Sale for the day?
Which Department (Produce, Bakery, Dairy) generated the most sales?
Which Product in Bakery generated the most sales?

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 Learning Series Solution' section.