Data View 1 Dla: Use Snipping Tool to take a screenshot of your data view, and then copy and paste it to your answer sheet. Qla: Which of the regions had the highest percentage of the total orders that were delayed? Which of the regions had the highest number of orders that were delayed? Explain your conclusion based on the data view. Q1b: Which of the regions had the best shipment records? How is the region different from the other three region in terms of the number of orders processed? Explain your conclusion based on the data view. Data View 2 D2a: Use Snipping Tool to take a screenshot of your data view, and then copy and paste it to your answer sheet. Q2a: Is there a particular shipping method that you would recommend customers of SuperStoreUS to use more frequently? Is there any shipping method that you would NOT recommend them to use? Explain your conclusion based on the dashboard. 1 Category Number o Order Date Sales Targe Segment 2 Office Sup 1 1/3/2014 15 Consumer B Office Sup 1 1/4/2014 300 Home Office 4 Office Sup 1 1/5/2014 21 Consumer 5 Furniture 1 1/6/2014 2316 Home Office 6 Office Sup 1 1/6/2014 17 Consumer 7 Office Sup 1 1/6/2014 14 Corporate 8 Office Sup 1 1/6/2014 699 Home Office 9 Technolog 1 1/6/2014 1068 Home Office 10 Furniture 1 1/7/2014 81 Consumer 11 Office Sup 1 1/7/2014 11 Consumer 12 Office Sup 1 1/9/2014 9 Consumer 13 Technolog 1 1/9/2014 29 Consumer 14 Furniture 1 ######## 47 Corporate Office Sup 1 ######## 3 Corporate 16 Furniture 1 ### 9 Consumer 17 Furniture 1 #### 792 Consumer 18 Office Sup 1 #### ### 1387 Consumer 19 Office Sup 1 ### 570 Corporate 20 Technolog 1 ######## 595 Corporate 21 Furniture 1 ######## 66 Corporate 22 Technolog 1 ######## 144 Consumer 23 Furniture 1 ######## 109 Consumer H T B C D E F K M Order ID Category City Country Customer Discount Number o Order Date Postal Cod Product Ni Profit Quantity Region CA-2016-1 Furniture Hendersor United Sta Claire Gute 0.00% 1 ######## 42420 Bush Some $42 2 South CA-2016-1 Furniture Hendersor United Sta Claire Gute 0.00% 1 ######## 42420 Hon Delux $220 3 South CA-2016-1 Office Sup Los Angele United Sta Darrin Van 0.00% 1 ######## 90036 Self-Adhes $7 2 West US-2015-1 Furniture Fort Laude United Sta Sean O'Do 45.00% 1 ######## 33311 Bretford C -$383 5 South US-2015-1 Office Sup Fort Laude United Sta Sean O'Do 20.00% 1 ######## 33311 Eldon Fold $3 2 South CA-2014-1 Furniture Los Angele United Sta Brosina Ho 0.00% 1 6/9/2014 90032 Eldon Expr $14 7 West CA-2014-1 Office Sup Los Angele United Sta Brosina Ho 0.00% 1 6/9/2014 90032 Newell 32. $2 4 West CA-2014-1 Technolog Los Angele United Sta Brosina Ho 20.00% 1 6/9/2014 90032 Mitel 5320 $91 6 West 10 CA-2014-1 Office Sup Los Angele United Sta Brosina Ho 20.00% 1 6/9/2014 90032 DXL Angle $6 3 West CA-2014-1 Office Sup Los Angele United Sta Brosina Ho 0.00% 1 6/9/2014 90032 Belkin F5C $34 5 West 12 CA-2014-1 Furniture Los Angele United Sta Brosina Ho 20.00% 1 6/9/2014 90032 Chromcraf $85 9 West 13 CA-2014-1 Technolog Los Angele United Sta Brosina HC 20.00% 1 6/9/2014 90032 Konftel 25 $68 4 West 14 CA-2017-1 Office Sup Concord United Sta Andrew Al 20.00% 1 ######## 28027 Xerox 196 $5 3 South 15 CA-2016-1 Office Sup Seattle United Sta Irene Mad 20.00% 1 ######## 98103 Fellowes P $133 3 West 16 US-2015-1 Office Sup Fort Worth United Sta Harold Pay 80.00% 1 ######## 76106 Holmes Re -$124 5 Central 17 US-2015-1 Office Sup Fort Worth United Sta Harold Pay 80.00% 1 ######## 76106 Storex Dur -$4 3 Central CA-2014-1 Office Sup Madison United Sta Pete Kriz 0.00% 1 ######## 53711 Stur-D-Sto $13 6 Central 19 CA-2014-1 Office Sup West Jordi United Sta Alejandro 0.00% 1 ######## 84084 Fellowes S $10 2 West 0.00% 20 CA-2014-1 Office Sup San Franci United Sta Zuschuss 1 ######## 94109 Newell 34 $2 2 West 20.00% 1 ######## 94109 Cisco SPA! $16 CA-2014-1 Technolog San Franci United Sta Zuschuss [ 3 West 20.00% 22 CA-2014-1 Office Sup San Franci United Sta Zuschuss 1 ######## $7 4 West 94109 Wilson Jor Sou Bdown- N Q R S Sales Segment Ship Date Ship Mode State Sub-Category $262 Consumer ######## Second Cla Kentucky Bookcases $732 Consumer ######## Second Cle Kentucky Chairs $15 Corporate ######## Second Cla California Labels $958 Consumer ######## Standard Florida Tables $22 Consumer ######## Standard (Florida Storage $49 Consumer ######### Standard (California Furnishings $7 Consumer ######## Standard (California Art $907 Consumer ######## Standard (California Phones $19 Consumer ######## Standard (California Binders $115 Consumer ######## Standard (California Appliances $1,706 Consumer ######## Standard (California Tables $911 Consumer ######## Standard (California Phones $16 Consumer ######## Standard (North Care Paper $408 Consumer ######## Standard Washingto Binders $69 Home Offi ######## Standard (Texas Appliances ome Offi #### Standard (Texas Binders $666 Consumer ######## Standard Wisconsin Storage $56 Consumer ######## Second ClaUtah Storage $9 Consumer 9/1/2014 Second Cl. California Art $213 Consumer 9/1/2014 Second Cl California Phones $23 Consumer 9/1/2014 Second Cla California Binders