how do i insert a power pivot to insert a pivottable based on data from 2021_orders table

3. 5 Go to the Stores worksheet. Jacob wants to display information about lighting products purchased according to store and manufacturer. He has been tracking this data in an Access database. Import the data from the Access database as follows: a. Create a new query that imports data from the Support_EX19_10a_LD.accdb database. b Select the 2021_Orders, Products, and Purchases tables for the import. Only create a connection to the data and add the data to the Data Model. 6 8 9 10 11 On the Stores worksheet, Jacob wants to show the categories of products sold in each of the company's five stores during 2021. In cell A2 of the Stores worksheet, Use Power Pivot to insert a Pivot Table based on the data in the 2021 Orders table. d. 12 13 14 . 3 Import Data in Share 1 This PC Downloads Organize New folder De Name Due mode Type * Quick access Desktop Downloads Documents Pictures Music Videos Today (2) Support EX19 104 LD Support E(10 Duta 4142071 SPM Micro Microsoft Acom ell C2 brkbook Queries oducts n an Microsoft Excel This PC ccdb Network sold in File name: Support EX19,108_LD ased on 15 16 17 18 19 next Connections Advanced Columns Sort & Fiter Data Tools Navigator corn P Purchases abol rackin follo Select multiple items Show All | Show Selected [3] OrderID Itemi a re ItemQty EXI 13378 14040 13071 2 bles fd Support EX19_10a_LD.accdb 161 2021 Orders Employees 1 Orders 129 Products Purchases Stores 10685 14091 1 1 the 2 10474 10474 ories 17997 13175 4 sert a 10463 14040 1 D6087 LD6087 LD6087 LD6086 LD6087 LD6087 LD6088 LD6088 LD6088 LD6089 LD6090 LD6090 LD6091 LD6092 LD6093 LD6093 LD6094 LD6094 LD6122 L6095 L16096 L6097 LD6093 L6098 14564 1 acob: 13175 1 he Pivd 12355 1 10744 13725 1 13183 2 17536 1 Items elsan 2 1 17536 14508 10509 10926 2 1 1 ing prog 11414 15175 1 rom the nge A12 Hayden Chord 1 - Excel Page Layout Formales Data Review View Acrobat Show deres Connections 2.97 From Table New Properties Refresh Hog Filter What Foreca Query. Recent Sources All Edit Links Ace Columns.AnalysisDet Get & Transform Connections Sort & Data Tools Forca Get External Data Son H7 aren B D G Lighting Designs: Products Sold by Store Workbook Queries Order 4 Pro Blue 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 five 24 25 27 -ble. 30 red to 92 Home Page Layout Fema Cart N_009, 1. del- A From tot Get temal New Duta Oy Recent Source Getaan All din 3 Sot 2. AZ Lighting Designs: Products Sold by Store 1 Workbook Quedes 2 3 5 6 7 9 10 11 12 13 on 15 16 17 18 20 five 22 20 24 25 26 27 28 29 20 31 able sed to 34 35 100