Exercise Info

• Application (Classic vs Data Prep Studio): Data Prep Studio
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
• Skills/Features Tested: Join (LookUp), Template End Field On Settings, Formula Field, Analyze
  
• Systems of Record: Not Applicable
• Estimated Time to Solve: 10 mins
• Exercise files required are attached
  • Order Status.txt
  • DiscountCode.xlsx

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.