Using Microsoft Power Bi and the attached Excel Data set;

Choose the best graph from the following questions and summarize your findings and Insert a screenshot if your chosen graph below

1. How profitable are we in each region?

1. How much are we spending on shipping costs per product container and ship mode?

List of Graphs

1. Area chart
2. Bar chart
3. Card
4. Column chart
5. Funnel
6. Gauge or KPI
7. Line and column chart
8. Line chart
9. Pie or donut chart
10. Ribbon chart
11. Scatter chart
12. Table
13. Tree map
14. Waterfall chart

I could not upload the excel file for this question :(

L B C D F G H K A E Order Priority Discount % Unit Selling Price Shipping Cost Customer ID Customer Name Ship Mode Customer Segment Product Category Product Sub-Category Product Container Product Name Medium 0.08 124.49 51.94 553 Kristine Connolly Delivery Truck Corporate Furniture Tables Jumbo Box Bevis 36 x 72 Conference Tables 0.02 6.48 5.9 3106 Alexander O'Brien Regular Air Home Office Office Supplies Pape Small Box Xerox 1976 Critical Small Box Avery 481 4 Critical 0.04 3.08 0.99 3106 Alexander O'Brien Regular Air Home Office Office Supplies Labels 0.04 125.9 4.2 3106 Alexander O'Brien Regular Air Home Office Technology Telephones and Communication Small Box V3682 5 Critical 6 High 0.01 9.31 3.98 1106 Maxine Collier Grady Regular Air Small Business Office Supplies Scissors, Rulers and Trimmers Small Pack Acme@ Forged Steel Scissors with Black Enamel Handles Small Box GBC Therma-A-Bind 250T Electric Binding System 7 Low 0.06 122.9 19.90 2382 Geoffrey Saunders Regular Air Small Business Office Supplies Binders and Binder Accessories 8 Not Specified 0.07 2036.48 14.7 553 Kristine Connolly Delivery Truck Corporate Technology Office Machines Jumbo Drum Lexmark 4227 Plus Dot Matrix Printer Dixon PrangR Watercolor Pencils, 10-Color Set with Brush 9 Medium 0. 1 4.26 1.2 699 Jenny Gold Regular Air Consumer Office Supplies Pens & Art Supplies Wrap Bag 10 Not Specified 0.07 179.9 19.9 171 Ross Simpson Express Air Consumer Technology Computer Peripherals Small Box Motorola SB4200 Cable Modem 11 Critical 0.0 3.26 1.86 342 _Jacqueline Noble Regular Air Corporate Office Supplies Pens & Art Supplies Wrap Bag Avery Hi-Liter GlideStik Fluorescent Highlighter, Yellow Ink 12 Medium 19.98 4 102 Caroline Johnston Regular Air Consumer Technology Computer Peripherals Small Box Belkin 105-Key Black Keyboard 13 Medium 0.09 2.88 1.49 102 Caroline Johnston Regular Air Consumer Office Supplies Binders and Binder Accessories Small Box Avery Durable Binders 14 High 0.07 1.68 .57 181 Wesley Waller Regular Air Corporate Office Supplies Pens & Art Supplies Wrap Bag Newell 323 15 Not Specified 0.02 1270.99 19.99 1733 Nina Horne Kelly Regular Air Small Business Office Supplies Binders and Binder Accessories Small Box Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind Small Box Xerox 227 16 Critical 0.05 5.48 3.73 2882 Andrew Gonzalez Regular Air Consumer Office Supplies Pape 0.02 5.3 272 Eleanor Swain Regular Air Home Office Office Supplies Envelopes Small Box Staples Brown Kraft Recycled Clasp Envelopes 17 Low 5.58 18 Low 0.03 40.89 18.98 272 Eleanor Swain Regular Air Home Office Furniture Office Furnishings Small Box Eldon Executive Woodline II Cherry Finish Desk Accessories 7.07 2431 Troy Cassidy Regular Air Consumer Office Supplies Storage & Organization Small Box Dual Level, Single-Width Filing Carts 19 High ).07 155.06 10.64 5.16 1193 Louis Parrish Regular Air Consumer Furniture Office Furnishings Small Box Eldon Expressions Punched Metal & Wood Desk Accessories, Pewter & Cherry 20 Low 0.03 Small Box Staples Plastic Wall Frames 21 Low 0.03 7.96 4.95 1193 Louis Parrish Regular Air Consumer Furniture Office Furnishings Okidata ML395C Color Dot Matrix Printer 22 Critical 0.02 1360.14 14.7 491 Toni Swanson Delivery Truck Consumer Technology Office Machines Jumbo Drum Envelopes Small Box Brown Kraft Recycled Envelopes 23 High 0.09 16.98 12.39 2189 Frank Cross Regular Air Corporate Office Supplies 24 Critical 0.06 49.9 19.99 3011 Tammy Raynor Regular Air Corporate Technology Computer Peripherals Small Box US Robotics 56K V.92 Internal PCI Faxmodem Paper Small Box Xerox 1941 25 Critical 0.1 104.85 4.65 3011 Tammy Raynor Regular Air Corporate Office Supplies 0.03 300.65 24.49 3011 Tammy Raynor Regular Air Corporate Office Supplies Appliances Large Box Honeywell Enviracaire Portable HEPA Air Cleaner for 17' x 22' Room 26 Critical Wrap Bag Dixon Prang@ Watercolor Pencils, 10-Color Set with Brush 27 High 0.03 4.26 1.2 117 Linda Weis Regular Air Home Office Office Supplies Pens & Art Supplies all Box Xerox 1922 28 Low 0.01 4.98 7.44 553 Kristine Connolly Regular Air Corporate Office Supplies Pape 48.04 5.09 949 Ernest Oh Consumer Office Supplies Paper Xerox 1910 29 Low 0.02 Regular Air Small Box 30 Medium 0.08 2.94 0.96 491 Toni Swanson Regular Air Consumer Office Supplies Pens & Art Supplies Wrap Bag Newell 343 40.48 19.99 698 Nelson Hensley Regular Air Corporate Technology Computer Peripherals Small Box Keytronic Designer 104- Key Black Keyboard 31 Low 0. 1 32 Critical ).06 10.98 2.99 949 Ernest Oh Regular Air Consumer Office Supplies Binders and Binder Accessories Small Box Avery Trapezoid Ring Binder, 3" Capacity, Black, 1040 sheets 33 Not Specified 0.07 5.18 2.04 398 Harriet Hodges Express Air Small Business Office Supplies Paper Wrap Bag Array@ Memo Cubes 34 Not Specified 0.02 12.5 0.49 898 Harriet Hodges Regular Air Small Business Office Supplies Labels Small Box Round Specialty Laser Printer Labels 520 35 Medium 65.99 5.26 1413 Pamela Wiley Regular Air Corporate Technology Telephones and Communication Small Box 36 Critical 0.01 4.98 5.07 491 Toni Swanson Regular Air Consumer Office Supplies Pape Small Box Xerox 1897 37 Low 0.06 160.98 35.02 640 Neal Wolfe Delivery Truck Consumer Furniture Bookcases nbo Box Rush Hierlooms Collection Rich Wood Bookcases 49.9 19.99 1 193 Louis Parrish Regular Air Small Business Technology Computer Peripherals Small Box Zoom V.92 USB External Faxmodem 38 Low 0.09 39 Low 0.03 28.53 1.49 1193 Louis Parrish Regular Air Small Business Office Supplies Binders and Binder Accessories Small Box Lock-Up Easel 'Spel-Binder' 0.04 99.23 8.99 349 Kim Weiss Regular Air Home Office Furniture Office Furnishings Small Pack GE 48" Fluorescent Tube, Cool White Energy Saver, 34 Watts, 30/Box 40 Medium 41 Low 0.06 4.28 0.94 2491 Sean N Boyer Regular Air Consumer Office Supplies Pens & Art Supplies Wrap Bag Newell 336 42 High 0.1 35.99 1745 Herbert Holden Regular Consumer Technology Telephones and Communication Wrap Bag Accessory 17 43 High 0.04 124.49 51.94 1745 Herbert Holden Delivery Truck Consumer Furniture Tables Jumbo Box Bevis 36 x 72 Conference Tables 44 Medium 137.48 32.18 3079 Andrew Levine Delivery Truck Small Business Furniture Bookcases Jumbo Box O'Sullivan Cherrywood Estates Traditional Barrister Bookcase 45 Low 0.04 60.65 12.23 1745 Herbert Holden Regular Air Home Office Furniture Office Furnishings Medium Box Tenex Traditional Chairmats for Medium Pile Carpet, Standard Lip, 36" x 48" 46 Not Specified 0.07 3.38 0.85 2382 Geoffrey Saunders Regular Air Small Business Office Supplies Pens & Art Supplies Wrap Bag Avery Hi-Liter@ Fluorescent Desk Style Markers 47 Medium ).02 7.64 1.39 1129 Pam Patton Regular Air Home Office Office Supplies Envelopes Small Box #10- 4 1/8" x 9 1/2" Security-Tint Envelopes 1 17 Linda Weiss Hor Small Box very 493 48 Medium 4.91 Office S Labels 0.0L M N O P Q R S T U V W X Product Name Contribution Margin Rat Country Region State City Postal Code Order Date Ship Date Profit of Order Quantity ordered Sales Order ID Bevis 36 x 72 Conference Tables 0.63 United States West California Los Angeles 90008 2015-06-18 2015-06-19 500.38 56 6413.7248 359 Xerox 1976 0.37 Unite Central Texas Houston 77041 2015-03-20 2015-03-21 -50. 64 53 336.5712 548 4 Avery 481 0.37 United States Central Texas Houston 77041 2015-03-20 2015-03-21 36.02 75 221.76 548 V3682 0.59 United States Central Texas Houston 7041 2015-03-20 2015-03-22 510.489 47 5684.6688 548 AcmeR Forged Steel Scissors with Black Enamel Handles 0.56 United States Central Texas Dallas 75220 2015-05-21 2015-05-22 -10.9 61 562.2309 646 GBC Therma-A-Bind 250T Electric Binding System 0.37 United States East New York New York City 10024 2015-05-05 2015-05-07 1408. 1865 48 5549.3088 962 8 Lexmark 4227 Plus Dot Matrix Printer 0.55 United States West California Los Angeles 0008 2015-02-21 2015-02-21 4073.25 25 47348.16 2433 9 Dixon Prang@ Watercolor Pencils, 10-Color Set with Brush 0.44 United States West California Los Angeles 90041 2015-05-20 2015-05-2 15.42 88 337.392 304 10 Motorola SB4200 Cable Modem 0.48 United State South Georgia Atlanta 30318 2015-02-08 2015-02-08 -568.5351 4 669.5628 3138 11 Avery Hi-Liter GlideStik Fluorescent Highlighter, Yellow Ink 0.41 United States South Florida Miami 3181 2015-05-04 2015-05-06 4.6683 20 64.548 3332 12 Belkin 105-Key Black Keyboard 0.68 United States East Massachusetts Boston 2129 2015-06-22 2015-06-24 -20.25 65 1 168.83 339 13 Avery Durable Binders 0.36 United States East Massachusetts Boston 2129 2015-06-22 2015-06-23 3.381 17 44.5536 3397 14 Newell 323 0.59 United States West California San Francisco 4122 2015-05-22 2015-05-23 -35.75 116 181.2384 3585 15 Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 0.35 United States East District of Columbia Washington 20012 2015-04-04 2015-04-06 9228.2256 36 44840.527 384 16 Xerox 227 0.37 United States South North Carolina Charlotte 28206 2015-05-09 2015-05-09 -160.3847 35 215.46 4839 17 Staples Brown Kraft Recycled Clasp Envelopes 0.35 United States South North Carolina Charlotte 28204 2015-04-07 2015-04-12 -29.8984 11 60.1524 5509 18 Eldon Executive Woodline II Cherry Finish Desk Accessories 0.57 United States South North Carolina Charlotte 28204 2015-04-07 2015-04-14 52.9166 21 832.9293 5509 19 Dual Level, Single-Width Filing Carts 0.59 United States West California Los Angeles 0004 2015-05-19 2015-05-19 -121.75 14 2018.8812 5920 20 Eldon Expressions Punched Metal & Wood Desk Accessories, Pewter & Cherry 0.57 United States East District of Columbia Washington 20016 2015-06-17 2015-06-22 14.48 63 650.2104 5984 21 Staples Plastic Wall Frames 0.41 United States East District of Columbia Washington 20016 2015-06-17 2015-06-19 22.25 17 131.2604 5984 22 Okidata ML395C Color Dot Matrix Printer 0.59 United States Eas New York New York City 10154 2015-06-20 2015-06-22 2028.12 22 29324.618 6562 23 Brown Kraft Recycled Envelopes 0.35 United States Eas New York New York City 10177 2015- 48.57 22 339.9396 7364 24 US Robotics 56K V.92 Internal PCI Faxmodem 0.45 United States East Massachusetts Boston 2113 2015-04-28 2015-04-30 17.2 67 3148.3702 762 25 Xerox 1941 0.37 United States East Massachusetts Boston 2113 2015-0 5-04-29 1184.12 58 5473.17 7623 26 Honeywell Enviracaire Portable HEPA Air Cleaner for 17' x 22' Room 0.52 United States East Massachusetts Boston 2113 2015-04-28 2015-04-30 1282.496 32 9332. 176 7623 27 Dixon Prang@ Watercolor Pencils, 10-Color Set with Brush 0.44 United States West Washington Seattle 8103 2015-01-03 2015-01-04 9.82 29 119.8338 7909 28 Xerox 1922 0.36 United States West California Los Angeles 90008 2015-04-1 -179.592 63 310.6026 8165 29 Xerox 1910 0.37 United States West California Los Angeles 90049 2015-03-22 2015-03-26 245.312472 18 847.4256 8257 30 Newell 343 0.58 United States East New York New York City 0154 2015-05-15 2015-05-17 -2.12 23 62.2104 835 31 Keytronic Designer 104- Key Black Keyboard 0.77 United States West Washington Seattle 98105 2015-04-07 2015-04-09 -580.32 36 1311.552 8994 32 Avery Trapezoid Ring Binder, 3" Capacity, Black, 1040 sheets 0.36 United States West California Los Angeles 0049 2015-01-02 2015-01-04 19.0992 3 115.5636 285 33 ArrayR Memo Cubes 0.36 United States East New York New York City 10039 2015-01-27 2015-01-29 37.31 44 211.9656 9606 34 Round Specialty Laser Printer Labels 0.38 United States East New York New York City 10039 2015-01-27 2015-01-27 151.075084 577.1318 960 35 520 0.59 United States East Massachusetts Boston 2113 2015-04-07 2015-04-08 $42.25 36 2375.64 1027 36 Xerox 1897 0.36 United States East New York New York City 10154 2015-02-10 2015-02-11 69.07 41 202.1382 10464 37 Rush Hierlooms Collection Rich Wood Bookcases 0.72 United States West Washington Seattle 8119 2015-03-20 2015-03-24 229.68 30 4539.636 1107 38 Zoom V.92 USB External Faxmodem 0.41 United States East District of Columbia Washington 20016 2015-06-28 2015-06-30 -17.03 48 2183.5632 1120 39 Lock-Up Easel 'Spel-Binder' 0.38 United States East District of Columbia Washington 20016 2015-06-28 2015-07-01 39.627 11 304.4151 11206 40 GE 48" Fluorescent Tube, Cool White Energy Saver, 34 Watts, 30/Box 0.35 United State South Florida Miam 33132 2015-01-02 2015-01-04 1732. 19412 144.0832 11527 41 Newell 336 0.56 United States West California Los Angeles 90045 2015-04-26 2015-04-28 0.37 9 36.2088 11712 42 Accessory 17 0.82 United States South Georgia Atlanta 30305 2015-06-12 2015-06-12 -277.20924 54 1749.114 2224 43 Bevis 36 x 72 Conference Tables 0.63 United States South Georgia Atlanta 30305 2015-06-12 2015-06-14 -247.55157 4 478.0416 1222 44 O'Sullivan Cherrywood Estates Traditional Barrister Bookcase 0.78 United States East Pennsylvania Philadelphia 19112 2015-01-07 2015-01-08 -203.27 10 1374.8 12480 45 Tenex Traditional Chairmats for Medium Pile Carpet, Standard Lip, 36" x 48" 0.64 United States South Georgia Atlanta 30305 2015-02-14 2015-02-16 116.5063 4 232.896 13408 46 Avery Hi-Liter@ Fluorescent Desk Style Markers 0.48 United States East New York New York City 10024 2015-04-26 2015-04-28 19.04 34 106.8756 13606 47 #10- 4 1/8" x 9 1/2" Security-Tint Envelopes 0.36 United States East Massachusetts Boston 2118 2015-05-21 2015-05-23 117.38 52 389.3344 13735 48 Avery 493 0.36 United State Wes Washing Seattle 98103 2015-04-04 2015-04-06 14.011428 47 228.4623 13959