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

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 1 & Product Name & Contribution Margin Rat & t. Country & Region & State & City & Postal Code & Order Date & Ship Date & Profit of Order & Quantity ordered & Sales & Order ID \\ \hline 2 & Bevis 3672 Conference Tables & 0.63 & United States & West & California & Los Angeles & 90008 & 201506182 & 2015-06-19 & -500.38 & 56 & 6413.7248 & 35 \\ \hline 3 & Xerox 1976 & 0.37 & United States & Central & Texas & Houston & 77041 & 20150320 & 2015-03-21 & -50.64 & 53 & 336.5712 & 548 \\ \hline 4 & Avery 481 & 0.37 & United States & Central & Texas & Houston & 77041 & 20150320 & 2015-03-21 & 36.02 & 75 & 221.76 & 54 \\ \hline 5 & V3682 & 0.59 & United States & Central & Texas & Houston & 77041 & 2015-03-20 & 2015-03-22 & 510.489 & 47 & 5684.6688 & 54 \\ \hline 6 & Acme R Forged Steel Scissors with Black Enamel Handles & 0.56 & United States & Central & Texas & Dallas & 75220 & 201505212 & 20150522 & -10.9 & 61 & 562.2309 & 646 \\ \hline 7 & GBC Therma-A-Bind 250T Electric Binding System & 0.37 & United States & East & New York & New York City & 10024 & 201505052 & 2015-05-07 & 1408.1865 & 48 & 5549.3088 & 962 \\ \hline 8 & Lexmark 4227 Plus Dot Matrix Printer & 0.55 & United States & West & California & Los Angeles & 90008 & 201502212 & 20150221 & 4073.25 & 25 & 47348.16 & 2433 \\ \hline 9 & Dixon Prang R Watercolor Pencils, 10-Color Set with Brush & 0.44 & United States & West & California & Los Angeles & 90041 & 20150520 & 2015-05-21 & 15.42 & 88 & 337.392 & 3042 \\ \hline 10 & Motorola SB4200 Cable Modem & 0.48 & United States & South & Georgia & Atlanta & 30318 & 201502082 & 20150208 & -568.5351 & 4 & 669.5628 & 3138 \\ \hline 11 & Avery Hi-Liter GlideStik Fluorescent Highlighter, Yellow Ink & 0.41 & United States & South & Florida & Miami & 33181 & 201505042 & 2015-05-06 & -4.6683 & 20 & 64.548 & 3332 \\ \hline 12 & Belkin 105-Key Black Keyboard & 0.68 & United States & East & Massachusetts & Boston & 2129 & 201506222 & 2015-06-24 & -20.25 & 65 & 1168.83 & 3397 \\ \hline 13 & Avery Durable Binders & 0.36 & United States & East & Massachusetts & Boston & 2129 & 20150622 & 20150623 & -3.381 & 17 & 44.5536 & 3397 \\ \hline 14 & Newell 323 & 0.59 & United States & West & California & San Francisco & 94122 & 20150522 & 20150523 & -35.75 & 116 & 181.2384 & 3585 \\ \hline 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 & 3841 \\ \hline 16 & Xerox 227 & 0.37 & United States & South & North Carolina & Charlotte & 28206 & 2015-05-09 2 & 2015-05-09 & -160.3847 & 35 & 215.46 & 4839 \\ \hline 17 & Staples Brown Kraft Recycled Clasp Envelopes & 0.35 & United States & South & North Carolina & Charlotte & 28204 & & 2015-04-12 & -29.8984 & 11 & 60.1524 & 5509 \\ \hline 18 & Eldon Executive Woodline II Cherry Finish Desk Accessories & 0.57 & United States & South & North Carolina & Charlotte & 28204 & 201504072 & 2015-04-14 & 52.9166 & 21 & 832.9293 & 5509 \\ \hline 19 & Dual Level, Single-Width Filing Carts & 0.59 & United States & West & California & Los Angeles & 90004 & 201505192 & 2015-05-19 & -121.75 & 14 & 2018.8812 & 5920 \\ \hline 20 & Eldon Expressions Punched Metal \& Wood Desk Accessories, Pewter \& Cherry & 0.57 & United States & East & District of Columbia & Washington & 20016 & 201506172=2 & 2015-06-22 & 14.48 & 63 & 650.2104 & 5984 \\ \hline 21 & Staples Plastic Wall Frames & 0.41 & United States & East & District of Columbia & Washington & 20016 & 201506172 & 2015-06-19 & 22.25 & 17 & 7131.2604 & 5984 \\ \hline 22 & Okidata ML395C Color Dot Matrix Printer & 0.59 & United States & East & New York & New York City & 10154 & 201506202 & 20150622 & 2028.12 & 22 & 29324.618 & 6562 \\ \hline 23 & Brown Kraft Recycled Envelopes & 0.35 & United States & East & New York & New York City & 10177 & 20150508 & 2015-05-10 & -48.57 & 22 & 339.9396 & 7364 \\ \hline 24 & US Robotics 56K V.92 Internal PCI Faxmodem & 0.45 & United States & East & Massachusetts & Boston & 2113 & 201504282 & 20150430 & 17.2 & 67 & 3148.3702 & 7623 \\ \hline 25 & Xerox 1941 & 0.37 & United States & East & Massachusetts & Boston & 2113 & 20150428 & 2015-04-29 & 1184.12 & 58 & \begin{tabular}{|l|l|} 3 & 5473.17 \end{tabular} & 7623 \\ \hline 26 & Honeywell Enviracaire Portable HEPA Air Cleaner for 17' x 22' Room & 0.52 & United States & East & Massachusetts & Boston & 2113 & 20150428 & 2015-04-30 & 1282.496 & 32 & 9332.176 & 7623 \\ \hline 27 & Dixon Prang R Watercolor Pencils, 10-Color Set with Brush & 0.44 & United States & West & Washington & Seattle & 98103 & 201501032 & 2015-01-04 & 9.82 & 29 & 119.8338 & 7909 \\ \hline 28 & Xerox 1922 & 0.36 & United States & West & California & Los Angeles & 90008 & 20150415 & 20150424 & -179.592 & 63 & 310.6026 & 8165 \\ \hline 29 & Xerox 1910 & 0.37 & United States & West & California & Los Angeles & 90049 & 20150322 & 2015-03-26 & 245.312472 & 18 & \begin{tabular}{l} 847.4256 \\ \end{tabular} & 8257 \\ \hline 30 & Newell 343 & 0.58 & United States & East & New York & New York City & 10154 & 201505152 & 2015-05-17 & -2.12 & 23 & 62.2104 & 8353 \\ \hline 31 & Keytronic Designer 104- Key Black Keyboard & 0.77 & United States & West & Washington & Seattle & 98105 & 201504072 & 2015-04-09 & -580.32 & 36 & 1311.552 & 8994 \\ \hline 32 & Avery Trapezoid Ring Binder, 3" Capacity, Black, 1040 sheets & 0.36 & United States & West & California & Los Angeles & 90049 & 201501022 & 2015-01-04 & -19.0992 & 3 & 115.5636 & 9285 \\ \hline 33 & Array Memo Cubes & 0.36 & United States & East & New York & New York City & 10039 & 201501272 & 2015-01-29 & 37.31 & 44 & 211.9656 & 9606 \\ \hline 34 & Round Specialty Laser Printer Labels & 0.38 & United States & East & New York & New York City & 10039 & 201501272 & 2015-01-27 & 151.075084 & 47 & 7577.1318 & 9606 \\ \hline 35 & g520 & 0.59 & United States & East & Massachusetts & Boston & 2113 & 201504072 & 2015-04-08 & 542.25 & 36 & 2375.64 & 10277 \\ \hline 36 & Xerox 1897 & 0.36 & United States & East & New York & New York City & 10154 & 201502102 & 2015-02-11 & -69.07 & 41 & 202.1382 & 10464 \\ \hline 37 & Rush Hierlooms Collection Rich Wood Bookcases & 0.72 & United States & West & Washington & Seattle & 98119 & 201503202 & 2015-03-24 & -229.68 & 30 & 4539.636 & 11077 \\ \hline 38 & Zoom V.92 USB External Faxmodem & 0.41 & United States & East & District of Columbia & Washington & 20016 & 20150628 & 2015-06-30 & -17.03 & 48 & 2183.5632 & 11206 \\ \hline 39 & Lock-Up Easel 'Spel-Binder' & 0.38 & United States & East & District of Columbia & Washington & 20016 & 20150628 & 2015-07-01 & 39.627 & 11 & 304.4151 & 11206 \\ \hline 40 & GE 48" Fluorescent Tube, Cool White Energy Saver, 34 Watts, 30/Box & 0.35 & United States & South & Florida & Miami & 33132 & 2015-01-02 & 2015-01-04 & 1732.19412 & 54 & 5144.0832 & 11527 \\ \hline 41 & Newell 336 & 0.56 & United States & West & California & Los Angeles & 90045 & 201504262 & 20150428 & 0.37 & 9 & 36.2088 & 11712 \\ \hline 42 & Accessory 17 & 0.82 & United States & South & Georgia & Atlanta & 30305 & 20150612 & 2015-06-12 & -277.20924 & 54 & 1749.114 & 12224 \\ \hline 43 & Bevis 3672 Conference Tables & 0.63 & United States & South & Georgia & Atlanta & 30305 & 20150612 & 2015-06-14 & -247.55157 & 4 & 478.0416 & 12224 \\ \hline 44 & O'Sullivan Cherrywood Estates Traditional Barrister Bookcase & 0.78 & United States & East & Pennsylvania & Philadelphia & 19112 & 2015-01-07 2 & 2015-01-08 & -203.27 & 10 & 1374.8 & 12480 \\ \hline 45 & Tenex Traditional Chairmats for Medium Pile Carpet, Standard Lip, 36" x 48" & 0.64 & United States & South & Georgia & Atlanta & 30305 & 201502142 & 20150216 & 116.5063 & 4 & 232.896 & 13408 \\ \hline 46 & Avery Hi-Liter Fluorescent Desk Style Markers & 0.48 & United States & East & New York & New York City & 10024 & 201504262 & 20150428 & 19.04 & 34 & 106.8756 & 13 \\ \hline 47 & \#10- 4 1/8" x 9 1/2" Security-Tint Envelopes & 0.36 & United States & East & Massachusetts & Boston & 2118 & 201505212 & 20150523 & 117.38 & 52 & 389.3344 & 13735 \\ \hline & Avery 493 & 0.36 & United States & West & Washington & Seattle & 98103 & 2015-04-04 2 & 2015-04-06 & 14.011428 & 47 & 7228.4623 & \\ \hline \end{tabular}