ACCORDING TO CHEGG POLICIES WE CAN'T SHARE EXCEL FILE IF ANY EXPERT WANT EXCELL FILE THEN SEND ME THEIR EMAIL ON COMMENT

Question-4 Marks [10]

You have to create a Sales dashboard (1 pager snapshot graphical report) with Power BI from the data provided to you in the 5 Excel files.

1. Customer
2. Order
3. Product
4. Region
5. Sales

The dashboard must contain the following components:

1. Total Sales
2. Gross Profit
3. Product Category Wise Sales, Quantity, Gross Profit
4. Sales by State and Country
5. Sales and Gross Profit by Year
6. Sales by Month
7. Units sold by State
8. Sub-Category of Products

The solution will be evaluated based on appropriate visualizations used, the design and organization of the dashboard components.

= 5 HOME FILE INSERT PAGE LAYOUT FORMULAS DATA i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unle A1 foc Customer ID B D E F 1 Customer IC Customer Name 2 CG-12520 Claire Gute 3 WG-45983 Henry Stalin 4 DV-13045 Darrin Van Huff 5 SO-20335 Sean O'Donnell 6 BH-11710 Brosina Hoffman 7 AA-10480 Andrew Allen 8 IM-15070 Irene Maddox 9 HP-14815 Harold Pawlan 10 PK-19075 Pete Kriz 11 AG-10270 Alejandro Grove 12 ZD-21925 Zuschuss Donatelli 13 KB-16585 Ken Black 14 SF-20065 Sandra Flanagan 15 EB-13870 Emily Burns 16 RV-8346 Matt Damon 17 18 19 XV FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it H14 X D E F G A 1 Order ID Order Date 2 CA-2016-152156 08-11-2017 3 CA-2016-138688 12-06-2017 4 US-2015-108966 11-01-2019 5 CA-2014-115812 09-05-2019 6 CA-2017-114412 15-04-2017 7 CA-2016-161389 05-12-2017 8 US-2015-118983 22-11-2018 9 CA-2014-105893 11-11-2018 10 CA-2014-167164 13-05-2018 11 CA-2014-143336 27-08-2018 12 CA-2014-143452 20-02-2019 13 CA-2016-137330 09-12-2018 14 US-2016-137330 20-12-2017 15 US-2017-156909 16-07-2018 16 CA-2015-106320 25-04-2019 17 18 19 20 X Product (Protected View] - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A1 : fox Product ID B D E F G A 1 Product ID Category Sub-Category Product Name 2 FUR-BO-10001798 Furniture Bookcases Bush Somerset Collection Bookcase 3 FUR-CH-10000454 Furniture Chairs Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back 4 OFF-LA-10000240 Office Supplie Labels Self-Adhesive Address Labels for Typewriters by Universal 5 FUR-TA-10000577 Furniture Tables Bretford CR4500 Series Slim Rectangular Table 6 FUR-FU-10001487 Furniture Furnishings Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood 7 TEC-PH-10002275 Technology Phones Mitel 5320 IP Phone VoIP phone 8 OFF-BI-10002215 Office Supplie Binders Wilson Jones Hanging View Binder, White, 1" 9 OFF-AP-10001492 Office Supplie Appliances Acco Six-Outlet Power Strip, 4' Cord Length 10 FUR-CH-10002774 Furniture Chairs Global Deluxe Stacking Chair, Gray 11 FUR-TA-10000577 Furniture Tables Bretford CR4500 Series Slim Rectangular Table 12 TEC-AC-10003027 Technology Accessories Imation 8GB Mini TravelDrive USB 2.0 Flash Drive 13 FUR-BO-10004834 Furniture Bookcases Riverside Palais Royal Lawyers Bookcase, Royale Cherry Finish 14 FUR-FU-10004848 Furniture Furnishings Howard Miller 13-3/4" Diameter Brushed Chrome Round Wall Clock 15 OFF-EN-10001509 Office Supplie Envelopes Poly String Tie Envelopes 16 OFF-AR-10004042 Office Supplie Art BOSTON Model 1800 Electric Pencil Sharpeners, Putty/Woodgrain 17 18 19 X 5 = FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it' A1 : X fox Place ID D E F G I B C 1 Place ID City State 2 1 Henderson Kentucky 3 2 Los Angeles California 4 3 Los Angeles California 5 4 Concord North Carolina 65 Seattle Washington 76 Fort Worth Texas 8 7 Madison Wisconsin 98 West Jordan Utah 10 9 San Francisco California 11 10 Fremont Nebraska 12 11 Fremont Nebraska 13 12 Philadelphia Pennsylvania 14 13 Orem Utah 15 14 Los Angeles California 16 15 Philadelphia Pennsylvania 17 18 19 20 21 22 23 X] 5 = Sales [Protected View] - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing M16 X fox J K L M A B C D E F G H 1 1 Order ID Customer ID Place ID Product ID Sales ID Sales Quantity Discount Cost 2 CA-2016-152156 CG-12520 1 FUR-BO-10001798 1 122261 200 0 120000 3 CA-2016-138688 WG-45983 2 FUR-CH-10000454 2 173100 389 0 170000 4 US-2015-108966 DV-13045 3 OFF-LA-10000240 3 98652 422 0 92000 5 CA-2014-115812 SO-20335 4 FUR-TA-10000577 4 95700 501 0.45 90000 6 CA-2017-114412 BH-11710 5 FUR-FU-10001487 5 223682 290 0.2 215000 7 CA-2016-161389 AA-10480 6 TEC-PH-10002275 6 488600 720 0 485000 8 US-2015-118983 IM-15070 7 OFF-BI-10002215 7 728202 450 0 728202 9 CA-2014-105893 HP-14815 8 OFF-AP-10001492 8 907152 650 0.2 890000 10 CA-2014-167164 PK-19075 9 FUR-CH-10002774 9 180504 320 0.2 170000 11 CA-2014-143336 AG-10270 10 FUR-TA-10000577 10 114900 560 0 108900 12 CA-2014-143452 ZD-21925 11 TEC-AC-10003027 11 170684 900 0.2 150000 13 CA-2016-137330 KB-16585 12 FUR-BO-10004834 12 911424 410 0.2 908500 14 US-2016-137330 SF-20065 13 FUR-FU-10004848 13 155520 0.2 140000 15 US-2017-156909 EB-13870 14 OFF-EN-10001509 14 407976 310 0.2 400976 16 |CA-2015-106320 RV-8346 15 OFF-AR-10004042 15 688100 540 0.8 680100 17 305 18 19 = 5 HOME FILE INSERT PAGE LAYOUT FORMULAS DATA i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unle A1 foc Customer ID B D E F 1 Customer IC Customer Name 2 CG-12520 Claire Gute 3 WG-45983 Henry Stalin 4 DV-13045 Darrin Van Huff 5 SO-20335 Sean O'Donnell 6 BH-11710 Brosina Hoffman 7 AA-10480 Andrew Allen 8 IM-15070 Irene Maddox 9 HP-14815 Harold Pawlan 10 PK-19075 Pete Kriz 11 AG-10270 Alejandro Grove 12 ZD-21925 Zuschuss Donatelli 13 KB-16585 Ken Black 14 SF-20065 Sandra Flanagan 15 EB-13870 Emily Burns 16 RV-8346 Matt Damon 17 18 19 XV FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it H14 X D E F G A 1 Order ID Order Date 2 CA-2016-152156 08-11-2017 3 CA-2016-138688 12-06-2017 4 US-2015-108966 11-01-2019 5 CA-2014-115812 09-05-2019 6 CA-2017-114412 15-04-2017 7 CA-2016-161389 05-12-2017 8 US-2015-118983 22-11-2018 9 CA-2014-105893 11-11-2018 10 CA-2014-167164 13-05-2018 11 CA-2014-143336 27-08-2018 12 CA-2014-143452 20-02-2019 13 CA-2016-137330 09-12-2018 14 US-2016-137330 20-12-2017 15 US-2017-156909 16-07-2018 16 CA-2015-106320 25-04-2019 17 18 19 20 X Product (Protected View] - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A1 : fox Product ID B D E F G A 1 Product ID Category Sub-Category Product Name 2 FUR-BO-10001798 Furniture Bookcases Bush Somerset Collection Bookcase 3 FUR-CH-10000454 Furniture Chairs Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back 4 OFF-LA-10000240 Office Supplie Labels Self-Adhesive Address Labels for Typewriters by Universal 5 FUR-TA-10000577 Furniture Tables Bretford CR4500 Series Slim Rectangular Table 6 FUR-FU-10001487 Furniture Furnishings Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood 7 TEC-PH-10002275 Technology Phones Mitel 5320 IP Phone VoIP phone 8 OFF-BI-10002215 Office Supplie Binders Wilson Jones Hanging View Binder, White, 1" 9 OFF-AP-10001492 Office Supplie Appliances Acco Six-Outlet Power Strip, 4' Cord Length 10 FUR-CH-10002774 Furniture Chairs Global Deluxe Stacking Chair, Gray 11 FUR-TA-10000577 Furniture Tables Bretford CR4500 Series Slim Rectangular Table 12 TEC-AC-10003027 Technology Accessories Imation 8GB Mini TravelDrive USB 2.0 Flash Drive 13 FUR-BO-10004834 Furniture Bookcases Riverside Palais Royal Lawyers Bookcase, Royale Cherry Finish 14 FUR-FU-10004848 Furniture Furnishings Howard Miller 13-3/4" Diameter Brushed Chrome Round Wall Clock 15 OFF-EN-10001509 Office Supplie Envelopes Poly String Tie Envelopes 16 OFF-AR-10004042 Office Supplie Art BOSTON Model 1800 Electric Pencil Sharpeners, Putty/Woodgrain 17 18 19 X 5 = FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it' A1 : X fox Place ID D E F G I B C 1 Place ID City State 2 1 Henderson Kentucky 3 2 Los Angeles California 4 3 Los Angeles California 5 4 Concord North Carolina 65 Seattle Washington 76 Fort Worth Texas 8 7 Madison Wisconsin 98 West Jordan Utah 10 9 San Francisco California 11 10 Fremont Nebraska 12 11 Fremont Nebraska 13 12 Philadelphia Pennsylvania 14 13 Orem Utah 15 14 Los Angeles California 16 15 Philadelphia Pennsylvania 17 18 19 20 21 22 23 X] 5 = Sales [Protected View] - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing M16 X fox J K L M A B C D E F G H 1 1 Order ID Customer ID Place ID Product ID Sales ID Sales Quantity Discount Cost 2 CA-2016-152156 CG-12520 1 FUR-BO-10001798 1 122261 200 0 120000 3 CA-2016-138688 WG-45983 2 FUR-CH-10000454 2 173100 389 0 170000 4 US-2015-108966 DV-13045 3 OFF-LA-10000240 3 98652 422 0 92000 5 CA-2014-115812 SO-20335 4 FUR-TA-10000577 4 95700 501 0.45 90000 6 CA-2017-114412 BH-11710 5 FUR-FU-10001487 5 223682 290 0.2 215000 7 CA-2016-161389 AA-10480 6 TEC-PH-10002275 6 488600 720 0 485000 8 US-2015-118983 IM-15070 7 OFF-BI-10002215 7 728202 450 0 728202 9 CA-2014-105893 HP-14815 8 OFF-AP-10001492 8 907152 650 0.2 890000 10 CA-2014-167164 PK-19075 9 FUR-CH-10002774 9 180504 320 0.2 170000 11 CA-2014-143336 AG-10270 10 FUR-TA-10000577 10 114900 560 0 108900 12 CA-2014-143452 ZD-21925 11 TEC-AC-10003027 11 170684 900 0.2 150000 13 CA-2016-137330 KB-16585 12 FUR-BO-10004834 12 911424 410 0.2 908500 14 US-2016-137330 SF-20065 13 FUR-FU-10004848 13 155520 0.2 140000 15 US-2017-156909 EB-13870 14 OFF-EN-10001509 14 407976 310 0.2 400976 16 |CA-2015-106320 RV-8346 15 OFF-AR-10004042 15 688100 540 0.8 680100 17 305 18 19