Customer	Product	Order Amount	Quarter	Order Date	Sales Person
Rubio's Coastal Grill	Jujube	$8,182.56	Q2	6/13/2018	Tasha Yang
Dog House Grill	Lime	$4,801.29	Q2	5/15/2017	Ron Soares
Straw Hat Pizza	Jicama	$9,111.77	Q2	4/19/2017	Ron Soares
Don Pepe Taqueria	Fennel	$1,180.93	Q2	5/23/2017	JIll Kim
Straw Hat Pizza	Lemon	$1,240.81	Q3	8/9/2018	Alison Martinez
The Habit Burger Grill	Clementine	$3,664.13	Q3	7/27/2018	Ron Soares
Don Pepe Taqueria	Watermelon	$552.58	Q3	8/2/2018	Alison Martinez
Yard House	Jicama	$1,272.24	Q2	4/7/2017	Alison Martinez
Samoa Cookhouse	Lemon	$4,574.51	Q2	4/27/2018	Bob James
Dog House Grill	Star Fruit	$853.64	Q2	5/2/2017	Alison Martinez
Yard House	Orange	$7,050.41	Q2	5/3/2017	Ron Soares
Straw Hat Pizza	Broccoli	$2,851.16	Q2	5/3/2017	Alison Martinez
Rubio's Coastal Grill	Cherry	$934.46	Q2	5/3/2018	Ron Soares
Yard House	Arugula	$7,692.49	Q2	4/23/2018	Bob James
Sabor MX	Tangerine	$662.21	Q2	4/10/2017	Bob James
Yard House	Huckleberry	$1,394.03	Q2	4/9/2018	Alison Martinez
Samoa Cookhouse	Lemon	$10,457.75	Q2	5/30/2017	Tasha Yang
Dog House Grill	Strawberry	$5,472.67	Q1	2/20/2018	Bob James
Yard House	Kiwi	$3,068.03	Q3	8/30/2018	Alison Martinez
Don Pepe Taqueria	Watermelon	$4,799.64	Q2	4/25/2017	Alison Martinez
Rubio's Coastal Grill	Fennel	$4,208.27	Q2	4/10/2017	Ron Soares
Samoa Cookhouse	Beets	$6,536.81	Q2	5/18/2017	Tasha Yang
The Habit Burger Grill	Cabbage	$1,315.80	Q1	2/9/2018	Ron Soares
Sabor MX	Plum	$7,571.78	Q4	11/1/2018	JIll Kim
Straw Hat Pizza	Mango	$5,783.83	Q2	4/11/2017	Alison Martinez
The Annex Kitchen	Cherry	$5,253.87	Q2	5/9/2017	Tasha Yang
Straw Hat Pizza	Tomato	$6,191.86	Q2	5/26/2017	Bob James
Sabor MX	Cherry	$625.23	Q2	5/15/2017	Ron Soares
Sabor MX	Papaya	$8,749.50	Q4	11/21/2018	Alison Martinez
Sabor MX	Guava	$2,110.33	Q2	4/16/2018	Ron Soares
Samoa Cookhouse	Arugula	$9,733.95	Q2	4/28/2017	Alison Martinez
Straw Hat Pizza	Corn	$9,642.86	Q1	1/24/2018	Alison Martinez
Yard House	Blackberry	$5,913.75	Q3	7/2/2018	Ron Soares
Sabor MX	Grapefruit	$951.75	Q3	7/11/2018	Ron Soares
The Habit Burger Grill	Cauliflower	$7,639.75	Q2	4/7/2017	Ron Soares
Don Pepe Taqueria	Fennel	$718.86	Q2	4/5/2017	JIll Kim
Rubio's Coastal Grill	Lime	$5,171.42	Q2	5/12/2017	Ron Soares
The Habit Burger Grill	Jicama	$5,091.21	Q2	4/6/2017	Ron Soares
Don Pepe Taqueria	Broccoli	$10,574.79	Q2	5/5/2017	Bob James
Dog House Grill	Corn	$4,977.08	Q1	3/20/2018	Ron Soares
Straw Hat Pizza	Jicama	$7,834.33	Q2	4/19/2017	Tasha Yang
Yard House	Apricot	$9,672.71	Q3	9/27/2018	Ron Soares
Rubio's Coastal Grill	Leeks	$947.43	Q2	4/27/2017	Bob James
Dog House Grill	Broccoli	$2,137.05	Q2	5/16/2017	Alison Martinez
Don Pepe Taqueria	Watermelon	$6,791.53	Q2	4/20/2017	Ron Soares
Rubio's Coastal Grill	Blueberry	$5,953.80	Q2	5/17/2017	Alison Martinez
The Habit Burger Grill	Jicama	$4,077.08	Q2	5/31/2017	Alison Martinez
Samoa Cookhouse	Watermelon	$5,727.21	Q4	12/27/2018	JIll Kim
Rubio's Coastal Grill	Clementine	$138.29	Q2	4/24/2017	JIll Kim
The Annex Kitchen	Beets	$9,105.92	Q2	5/29/2017	Ron Soares
Samoa Cookhouse	Broccoli	$676.30	Q4	12/31/2018	JIll Kim
Samoa Cookhouse	Peach	$8,748.99	Q1	1/24/2018	Ron Soares
Sabor MX	Grape	$8,740.86	Q2	4/11/2017	Ron Soares
Don Pepe Taqueria	Mango	$1,086.49	Q1	1/16/2018	Ron Soares
Rubio's Coastal Grill	Fennel	$9,089.19	Q4	10/18/2018	Bob James
Yard House	Watermelon	$5,727.86	Q2	6/25/2018	JIll Kim
Sabor MX	Pomegranate	$5,791.71	Q2	4/3/2017	Bob James
Dog House Grill	Arugula	$1,313.99	Q2	4/26/2017	Ron Soares
The Habit Burger Grill	Fig	$3,549.79	Q2	5/10/2017	Alison Martinez
Sabor MX	Banana	$7,933.26	Q2	4/28/2017	JIll Kim
Straw Hat Pizza	Mango	$10,352.18	Q2	5/12/2017	Alison Martinez
Dog House Grill	Lime	$4,533.93	Q2	4/27/2017	Ron Soares
Sabor MX	Corn	$8,348.91	Q4	10/23/2018	Alison Martinez
Yard House	Pomegranate	$3,378.68	Q1	2/28/2018	Bob James
Rubio's Coastal Grill	Clementine	$10,314.01	Q2	5/25/2017	JIll Kim
Straw Hat Pizza	Pomegranate	$7,000.79	Q2	5/23/2017	Alison Martinez
Samoa Cookhouse	Arugula	$2,809.35	Q2	4/17/2017	Ron Soares
Yard House	Watermelon	$10,364.49	Q2	5/2/2017	Ron Soares
Don Pepe Taqueria	Watermelon	$994.09	Q2	5/19/2017	Alison Martinez
Samoa Cookhouse	Arugula	$3,363.96	Q4	10/15/2018	Alison Martinez
Dog House Grill	Corn	$1,867.40	Q2	5/1/2018	Ron Soares
Straw Hat Pizza	Cauliflower	$4,578.09	Q2	5/16/2017	Tasha Yang
Rubio's Coastal Grill	Watermelon	$10,662.89	Q4	10/11/2018	Ron Soares
The Annex Kitchen	Beets	$1,964.96	Q2	5/24/2017	JIll Kim
The Habit Burger Grill	Cauliflower	$10,116.58	Q4	11/29/2018	Ron Soares
The Annex Kitchen	Arugula	$3,899.79	Q2	4/5/2018	Ron Soares
Sabor MX	Beets	$7,564.74	Q2	5/4/2017	JIll Kim
The Habit Burger Grill	Corn	$10,433.89	Q2	5/18/2017	Tasha Yang
Don Pepe Taqueria	Broccoli	$9,631.35	Q2	4/14/2017	Ron Soares
The Annex Kitchen	Pear	$3,324.86	Q4	11/28/2018	Ron Soares
Sabor MX	Passon_Fruit	$8,112.63	Q2	4/3/2017	Bob James
Rubio's Coastal Grill	Fennel	$5,381.27	Q1	3/23/2018	JIll Kim
Dog House Grill	Beets	$6,184.99	Q2	6/26/2018	Ron Soares
Rubio's Coastal Grill	Pineapple	$9,764.94	Q2	4/18/2017	JIll Kim
Samoa Cookhouse	Apple	$9,480.62	Q2	5/4/2017	Alison Martinez

Create a set of Pivot Tables that will be used in an executive dashboard to help users find the answers to the business questions below (see detailed instructions below).

In this scenario, you are a reporting tool designer. You will use MS Excel Pivot Tables to help the business answer activity and performance questions. Keep in mind you are not only asked to find answers but to build a table that will help others find answers to similar questions. As such, your Pivot Table must be set up to be reusable. For example, if your boss is looking for the best-selling product in 2020, your report design allows them to also find the best-selling product in 2023 (hint: use slicers on a dimension; what is this?)

Note: Your boss is a senior and needs to be able to read the screenshots you take. Crop screenshots and enlarge them to remove empty/blank spaces.

In presenting the answer, the Pivot Tables must show the proper dimensions as rows and measures as columns that will be most relevant to answer the question.

In what quarters did our customer Sabor MX order the two highest dollar amounts of products? (Hint: dimension (row) Customer, measure (columns) dollar amount) Who is the best performer among our sales force (Sales rep with the highest order amount)? (Think: what is the dimension (row)? and what is the measure (column)?) Bob James did not bring orders in what quarter? What is our best-selling product and how much revenue (order amount) did it generate? What products were sold in Quarter 1 and only in Quarter 1? (use Quarter) Excel adds two new columns (fields) to the PivotTable Fields Using slicers and sorting is mandatory in at least the two questions that need them. Use Slicers and Sorting to your advantage in finding answers. For example, if you need to find the highest amount, sort descending by amount. Doing this will show the answer at the top. Let MS Excel do the work for you. Although finding the answers visually in this exercise is possible, you would not be able to do it if you had thousands of products or customers. Be resourceful :) Make sure that for each question and answer, you include the following: Question Answer A brief explanation of what you did to find the answer (be brief, ok to use numbered bullet list of steps) Cropped screenshot (see tips below) of the specific Pivot Table view where you found the answer to the question. Include slicers and/or field panel to show your work. Crop and paste only the focus area in the screen (not all your computer screen). This will render a readable shot and will make it easier to grade accurately. In finding answer slicers, sorting and filtering MUST be used when needed. Points will be deducted if these tools are expected but not used. Type your name on the top left corner of your spreadsheet (Cell A1), so it shows in all screenshots Do not screenshot all of your computer screen, screenshot only the section of your screen that shows the work you did.