Your task is to use the dataset below (YOU MUST USE THIS DATASET - IT IS DIFFERENT FROM OTHER PRACTICE FILES) to create a Tableau chart for each of the following tasks. Be sure to save each chart on a new sheet in Tableau and submit your completed Tableau project file at the end of this quiz. We will review your Tableau project file to make sure that you completed each chart used to answer the questions so please don't forget to upload it. Also, please make sure that you use only the Orders sheet (this should be the only sheet available if you are using the correct dataset).

Tableau tasks:

1. Using a bubble chart, determine the average profit for each product category. Show the product category name, average profit, and quantity sold as labels, where average profit is also indicated by size.

2. Using a continuous line graph, determine the trend in total sales on a monthly basis for all recorded orders. Show the sum of sales as a label.

3. Using a filled geographical map, determine the average discount we offer to each state of the United States (ignore Hawaii and Alaska). Indicate average discount by color (ten steps). Show average discount as a label. Hint: filter by country first, then by state.

4. Using a symbol map, determine the average shipping costs for each country (not state). Increase the size of the symbols (circles) by one tick and make their opacity 75% with a black border.

5. Using a highlighted table, determine profitability by region. The sum of profit should be indicated by color and should be shown as a label.

6. Using a vertical bar chart (horizontal flipped 90 degrees), determine the profitability of each product category across each region. Indicate the sum of profit by color and show it as a label on each bar.

7. Using a continuous line graph, and considering only data from 2/1/2011 5/30/2014 in the region (not country) of Africa, determine the average shipping costs by month (by shipping date). Show the average shipping cost as a label.

8. Using a continuous line graph, and considering all data (do not ignore last month), forecast the sum of sales by month for two years using a 99% confidence level. Show the sum of sales as a label.

9. Using a side-by-side vertical bar chart, determine the sum of profit for the product sub-categories of Appliances and Storage, for all states in Australia. Indicate sum of profit by color.

Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Commen Calibri (Body) ~ A A 12 Insert v a General E W 28. Or 4 ie Thx Delete Peste BIU CA 3 Ideas Sensitivity Tasks Conditional Format Cell Formatting es Table Styles Sort & Filter Format v Find & Select T Y Z S 35.48 17.89 2004 47.142 49.302 30.44 12.96 1.344 4 2 8 2 3 4 2 1 1 2 H51275 x fx Consumer A B D E 6 H 1 K L M 51265 6367 MX-2011- 12/22/11 12/26/11 Standard (BP-11230 Henjamin Consumer Toluca Mxico Mexico IATAM 51266 13800 ES-2014-58/5/14 8/11/14 Standard (NM-18520 Neoma M Consumer Chartres Centre France EU 51267 15975 E5-2011-45/10/11 5/14/11 Standard (MM-1805! Michelle Consumer Dudley England United Kingdom EU 51268 22589 IN 2014 3 11/25/14 11/20/14 Standard (AO 10910 Anthony Corporate Perth Western Australia APAC 51269 27081 ID-2012-34 8/10/12 8/11/12 First Class EK-13795 Eileen Kie Horne Olli Pasis National Philippines APAC 51270 34657 US-2012-1/4/12 6/8/12 Second ClETC-21535 Tracy Colli Home Offi New York New York United Sta 10074 US 51271 36834 US-2013-1 6/7/13 6/8/12 First Cass CK-12595 Clytie Kelt Consumer Little Rock Arkansas United Sta 72209 US 51272 38414 CA-2011-1 10/18/11 10/23/11 Second CE 15-15085 Ivan Gibs Consumer Seattle Washingt: United Sta 98103 Us 51273 47274 SA 2014 1 4/9/14 4/13/14 Standard CW 607S Julia West Consumer Riyadh Ar Riyad Saudi Arabia EMEA 51274 5465 MX-2014- 4/17/14 4/20/14 Second CIE NA-10480 Andrew A Consumer San Jos Mayabecu Cube LATAM 51275 5596 MX-2013- 9/30/13 10/7/13 Second CI: SS-20410 Shahid S. Consumer Acayucan Veracruz Mexico LATAM 51276 9309 MX-2014- 5/11/14 9/12/14 First Class SL-20155 Sara Luver Horne Offi Vespasian Minas Ger Brazil LATAM 51277 10410 E5-2011-1 12/3/11 12/3/11 Same Day LR-17035 Lisa Ayan Corporate Hamburg Hamburg Germany EU 51278 31559 US 2014 1 6/9/14 6/13/14 Standard Dl 13600 Darris lich Corporate Pasadena Texas United Sta 72506 Us 51279 37361 CA-2012-1 12/25/12 12/30/12 Second CIERA-19285 Ralph Ar Consumer San Diego California United Sta 92037 US 51280 43818 NI-7011-4 9/8/11 9/10/11 Second Cl: P0-8865 Patrick O' Consumer Lagos lagos Nigeria Africa 51281 46231 ZI-2011-4. 3/21/11 3/26/11 Standard (AS-205 Alejandro Corporate Harare Harare Zimbabwe Africa 51282 45582 TU-2014-E 11/29/14 11/30/14 First Class KF-5285 Karen Fere Home Offi Midyat Mardin Turkey EMEA 51283 6039 MX 2014 6/9/14 6/11/14 First dass HG-15025 Hunter Gl: Consumer Bragana So Paulo Brazil LATAM 51284 9922 MX-2012- 12/28/12 12/31/12 First Class KM-16375 Katherine Horne Olli Maragua Managua Nicaragua LATAM 51285 24105 IN-2014-7 5/80/14 5/30/14 Same Day KH-16330 Katharine Corporate Lucknow Uttar Prad India APAC 51286 24175 IN-2014-5 8/5/14 8/10/14 Standard (D0-13270 Deborah 2 Home Offi Townsville Queenslar Australia APAC 51287 29002 IN-2014-6 6/19/14 6/19/14 Same Day KE-16420 Katrina Ed Corporate Kure Hiroshima Japan APAC 51288 35999 US 2014. 6/20/14 6/24/14 Standard 2C-21910 Zuschuss Consumer Houston Texas United Sta 72095 US 51289 40470 US-2013-1 12/2/13 12/2/13 Same Day LB-16795 Laurel Bel Horne Olli Oxnard California United Sta 93030 US 51290 4596 MX-2012- 2/18/12 2/22/12 Standard (RB-19795 Rass Bairr Home Offi Valinhos Ssa Paulo Brazil LATAM 51291 6147 MX-2012- 5/22/12 5/26/12 Second Cl: MC-18100 Mick Crebs Consumer Tipitapa Managua Nicaragua LATAM 51292 51293 N 0 P P R North OFF-B1-10 Office Sun Binders Arco Hindi Central OFF-LA-1 Office Sup Labels Avery File North OFF-AR-1 Office Sup Art Stanley Pe Oceania OFF EN 1 Office Sup Envelopes Globe Wei Southeast OFF-PA-1 Office Sup Paper Enermax Fast OFF.PA-1 Office Sup Paper Wireboun South OFF-PA-1 Office Sup Paper Xerox 230 West OFF-11-10 Office Sup Binders Computer -10 EMEA OFF CAR Office SupBinders Cardinal H Caribbean OFF-AR-1 Office Sup Art Boston Pe North OFF-B1-10 Office SunRinders Ibico Index South OFF-LA-1 Office Sup Labels Navimex Central OFF-BI-10 Office Sup Binders Acco Bindi Central OFF AP 1 Office Sup Aapliance: Eureka Dis West OFF-PA-1 Office Sup Paper Great Whi Africa OFF-STA- Office Sun Art Stanley HI Africa OFF-SAN- Office Sup Art Sanford EMEA OFF-B05- Office Sup Art Boston Pe Sauth OFF-PA 1 Office Sup Papar Green Bar Central OFF-PA-1 Office Sup Paper SanDisk Central 4 OFF.PA-1 Office Sun Paper Faton Part Oceania OFF-BI-10 Office Sup Dinders Avery Dinc North Asia OFF-FA-1 Office Sup Fasteners Advantus Central OFF AP 1 Office Sup Aapliance: Hoover Re West OFF-EN-1 Office Sup Envelopes 410-41/8 South OFF-B1-10 Office Supinders Arce Index Central OFF-PA-1 Office Sup Paper Caton Corr 5.34 19.32 41.64 5.92 52.59 1.624 17.94 5.364 9.612 34.128 1 1 2 3 3 1 2 3.78 0 5.89 0 0 12 0.1 8.862 0.45 -18.828 0 14.3068 0 6.2209 DA704 0 2.16 0 0.56 3.72 0 0.04 0 12.5 4.466 0 8.073 -6.455 0.7 -21.169 0.6 -49.572 9.2 0 B 0 1.86 0.1 19.95 0 4.5 -1.11 0 11.2305 o 2.4 0 1.9 W X 0.04 Medium 0.03 Medium 0.03 Medium 0.03 Medium 0.03 Medium 0.03 Medium 0.03 High 0.03 Medium 0.03 Medium 0.03 Medium 0.02 High 0.02 High 0.02 Medium 0.02 Medium 0.02 High 0.02 High 0.02 Medium 0.02 Medium 0.02 High 0.01 Medium 0.01 High 0.01 Medium 0.01 Medium 0.01 Medium 0.01 Hich 0.00 Medium 0.00 High 6 S 1 2 5 5 18.64 26.94 59.05 55 1 0.444 22.92 13.44 61.39 1 3 2 3 Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Commen Calibri (Body) ~ A A 12 Insert v a General E W 28. Or 4 ie Thx Delete Peste BIU CA 3 Ideas Sensitivity Tasks Conditional Format Cell Formatting es Table Styles Sort & Filter Format v Find & Select T Y Z S 35.48 17.89 2004 47.142 49.302 30.44 12.96 1.344 4 2 8 2 3 4 2 1 1 2 H51275 x fx Consumer A B D E 6 H 1 K L M 51265 6367 MX-2011- 12/22/11 12/26/11 Standard (BP-11230 Henjamin Consumer Toluca Mxico Mexico IATAM 51266 13800 ES-2014-58/5/14 8/11/14 Standard (NM-18520 Neoma M Consumer Chartres Centre France EU 51267 15975 E5-2011-45/10/11 5/14/11 Standard (MM-1805! Michelle Consumer Dudley England United Kingdom EU 51268 22589 IN 2014 3 11/25/14 11/20/14 Standard (AO 10910 Anthony Corporate Perth Western Australia APAC 51269 27081 ID-2012-34 8/10/12 8/11/12 First Class EK-13795 Eileen Kie Horne Olli Pasis National Philippines APAC 51270 34657 US-2012-1/4/12 6/8/12 Second ClETC-21535 Tracy Colli Home Offi New York New York United Sta 10074 US 51271 36834 US-2013-1 6/7/13 6/8/12 First Cass CK-12595 Clytie Kelt Consumer Little Rock Arkansas United Sta 72209 US 51272 38414 CA-2011-1 10/18/11 10/23/11 Second CE 15-15085 Ivan Gibs Consumer Seattle Washingt: United Sta 98103 Us 51273 47274 SA 2014 1 4/9/14 4/13/14 Standard CW 607S Julia West Consumer Riyadh Ar Riyad Saudi Arabia EMEA 51274 5465 MX-2014- 4/17/14 4/20/14 Second CIE NA-10480 Andrew A Consumer San Jos Mayabecu Cube LATAM 51275 5596 MX-2013- 9/30/13 10/7/13 Second CI: SS-20410 Shahid S. Consumer Acayucan Veracruz Mexico LATAM 51276 9309 MX-2014- 5/11/14 9/12/14 First Class SL-20155 Sara Luver Horne Offi Vespasian Minas Ger Brazil LATAM 51277 10410 E5-2011-1 12/3/11 12/3/11 Same Day LR-17035 Lisa Ayan Corporate Hamburg Hamburg Germany EU 51278 31559 US 2014 1 6/9/14 6/13/14 Standard Dl 13600 Darris lich Corporate Pasadena Texas United Sta 72506 Us 51279 37361 CA-2012-1 12/25/12 12/30/12 Second CIERA-19285 Ralph Ar Consumer San Diego California United Sta 92037 US 51280 43818 NI-7011-4 9/8/11 9/10/11 Second Cl: P0-8865 Patrick O' Consumer Lagos lagos Nigeria Africa 51281 46231 ZI-2011-4. 3/21/11 3/26/11 Standard (AS-205 Alejandro Corporate Harare Harare Zimbabwe Africa 51282 45582 TU-2014-E 11/29/14 11/30/14 First Class KF-5285 Karen Fere Home Offi Midyat Mardin Turkey EMEA 51283 6039 MX 2014 6/9/14 6/11/14 First dass HG-15025 Hunter Gl: Consumer Bragana So Paulo Brazil LATAM 51284 9922 MX-2012- 12/28/12 12/31/12 First Class KM-16375 Katherine Horne Olli Maragua Managua Nicaragua LATAM 51285 24105 IN-2014-7 5/80/14 5/30/14 Same Day KH-16330 Katharine Corporate Lucknow Uttar Prad India APAC 51286 24175 IN-2014-5 8/5/14 8/10/14 Standard (D0-13270 Deborah 2 Home Offi Townsville Queenslar Australia APAC 51287 29002 IN-2014-6 6/19/14 6/19/14 Same Day KE-16420 Katrina Ed Corporate Kure Hiroshima Japan APAC 51288 35999 US 2014. 6/20/14 6/24/14 Standard 2C-21910 Zuschuss Consumer Houston Texas United Sta 72095 US 51289 40470 US-2013-1 12/2/13 12/2/13 Same Day LB-16795 Laurel Bel Horne Olli Oxnard California United Sta 93030 US 51290 4596 MX-2012- 2/18/12 2/22/12 Standard (RB-19795 Rass Bairr Home Offi Valinhos Ssa Paulo Brazil LATAM 51291 6147 MX-2012- 5/22/12 5/26/12 Second Cl: MC-18100 Mick Crebs Consumer Tipitapa Managua Nicaragua LATAM 51292 51293 N 0 P P R North OFF-B1-10 Office Sun Binders Arco Hindi Central OFF-LA-1 Office Sup Labels Avery File North OFF-AR-1 Office Sup Art Stanley Pe Oceania OFF EN 1 Office Sup Envelopes Globe Wei Southeast OFF-PA-1 Office Sup Paper Enermax Fast OFF.PA-1 Office Sup Paper Wireboun South OFF-PA-1 Office Sup Paper Xerox 230 West OFF-11-10 Office Sup Binders Computer -10 EMEA OFF CAR Office SupBinders Cardinal H Caribbean OFF-AR-1 Office Sup Art Boston Pe North OFF-B1-10 Office SunRinders Ibico Index South OFF-LA-1 Office Sup Labels Navimex Central OFF-BI-10 Office Sup Binders Acco Bindi Central OFF AP 1 Office Sup Aapliance: Eureka Dis West OFF-PA-1 Office Sup Paper Great Whi Africa OFF-STA- Office Sun Art Stanley HI Africa OFF-SAN- Office Sup Art Sanford EMEA OFF-B05- Office Sup Art Boston Pe Sauth OFF-PA 1 Office Sup Papar Green Bar Central OFF-PA-1 Office Sup Paper SanDisk Central 4 OFF.PA-1 Office Sun Paper Faton Part Oceania OFF-BI-10 Office Sup Dinders Avery Dinc North Asia OFF-FA-1 Office Sup Fasteners Advantus Central OFF AP 1 Office Sup Aapliance: Hoover Re West OFF-EN-1 Office Sup Envelopes 410-41/8 South OFF-B1-10 Office Supinders Arce Index Central OFF-PA-1 Office Sup Paper Caton Corr 5.34 19.32 41.64 5.92 52.59 1.624 17.94 5.364 9.612 34.128 1 1 2 3 3 1 2 3.78 0 5.89 0 0 12 0.1 8.862 0.45 -18.828 0 14.3068 0 6.2209 DA704 0 2.16 0 0.56 3.72 0 0.04 0 12.5 4.466 0 8.073 -6.455 0.7 -21.169 0.6 -49.572 9.2 0 B 0 1.86 0.1 19.95 0 4.5 -1.11 0 11.2305 o 2.4 0 1.9 W X 0.04 Medium 0.03 Medium 0.03 Medium 0.03 Medium 0.03 Medium 0.03 Medium 0.03 High 0.03 Medium 0.03 Medium 0.03 Medium 0.02 High 0.02 High 0.02 Medium 0.02 Medium 0.02 High 0.02 High 0.02 Medium 0.02 Medium 0.02 High 0.01 Medium 0.01 High 0.01 Medium 0.01 Medium 0.01 Medium 0.01 Hich 0.00 Medium 0.00 High 6 S 1 2 5 5 18.64 26.94 59.05 55 1 0.444 22.92 13.44 61.39 1 3 2 3