Altair Monarch Learning Series 2023 Exercise 7 Solution: Order Status Analysis

Exercise Info

Exercise Overview

You are a Sales Operations Analyst, and you need to analyze sales data of recent Orders by Customer to answer the following questions:

  1. What is the Total Sale Amount by Store ID?
  2. Using the DiscountCode spreadsheet, determine the Total Discounted Sale Amount by Store ID
  3. Determine How many records contain the word 'BACKORDER'?

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.