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:
- What is the Total Sale Amount by Store ID?
- Using the DiscountCode spreadsheet, determine the Total Discounted Sale Amount by Store ID
- 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.
