Monarch Learning Series 2023 Exercise 2 - Grocery Analysis
Baba_Majekodunmi_703
Altair Employee
Altair EmployeeExercise 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.
0
Comments
-
-
-
Shelton Vance_22282 said:
Submission attached.
SV
You got both question 1 and 2 correct. There is a Question 3, are you able to answer to too? I forgot to update it, just did it now.
0 -
Susan DeWitt said:
Both questions answered with one summary.
You got both question 1 and 2 correct. There is a Question 3, are you able to answer to too? I forgot to update it, just did it now.
0 -
-
Attached Spreadsheets containing Total Revenue, Bakery Revenue, and Department Revenue.
0 -