Tableau Assignment BUSI 650 – Business Analytics The provided dataset “Walmart Sales” contains the sales for different categories of products (i.e., Furniture, Office Supplies, and Technology) across...

1 answer below »
Subject: Business Analytics


Tableau Assignment BUSI 650 – Business Analytics The provided dataset “Walmart Sales” contains the sales for different categories of products (i.e., Furniture, Office Supplies, and Technology) across with the profit, the quantity sold along with the geographical location of the sales (Country, state, city, and postal code). Use the data provided to create a profit dashboard using Tableau that contains the following: a) A histogram of the profit, marginal profit, sales and discount per category and sub- category. b) A weekday and monthly sales trends. c) A geographical representation of the profit for the cities. d) A geographical representation of the profit for the states. e) A histogram for the quantity of the returned items, showing the return reasons. f) An interactive profit dashboard (i.e., dynamic filtering applied) g) A filter on the side for the following: i. Order date (Yearly) ii. City iii. Product category iv. Product sub-category h) Create story telling about the business performance, highlighting the important things obtained from the analysis. i) Based on the previous analysis, which provinces are not generating revenue? What is the reasons behind this? j) Based on the previous analysis, what are the reasons behind the losses in Roseville city and how that can be mitigated? Support your answers with Tableau analytics. k) Based on the previous analysis, how we can maximize the profit in San Antonio City? Support your answers with Tableau analytics. Submission Format: answers in PDF/ MS word file, and the original Tableau files. Sheet1 order_idorder_info_idorder_id_numberreturn_reasonorder_dateorder_weekdayorder_monthship_dateship_modeproduct_iddays_to_shipcategorysub_categoryproduct_nameunit_costsalessales_volumeprofitprofit_marginquantitydiscountdiscount_over_30region_idpostal_codecitystate sub_regionsalespersoncustomer_idcustomer_namesegmentCountry AE-2019-1231682AE-20191231682Not Returned12/18/19WednesdayDecember12/23/19Second ClassTEC-MOT-100015355TechnologyPhonesMotorola Headset, VoIP$ 23.95$ 95.80Low$ 0.330.34%40.41148847374RichmondIndianaCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-1263608AE-20191263608Not Returned12/26/19ThursdayDecember12/31/19Second ClassOFF-AVE-100048275Office SuppliesBindersAvery Binder Covers, Recycled$ 11.43$ 3.43Low$ 0.339.62%10.41148878745AustinTexasCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-303016AE-2019303016Not Returned12/18/19WednesdayDecember12/23/19Second ClassTEC-MOT-100015355TechnologyPhonesMotorola Headset, VoIP$ 23.95$ 95.80Low$ 0.330.34%40.41148852402Cedar RapidsIowaCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-304471AE-2019304471Not Returned12/27/19FridayDecember12/31/19Second ClassTEC-MOT-100015354TechnologyPhonesMotorola Headset, VoIP$ 23.95$ 95.80Low$ 0.330.34%40.41148860653ChicagoIllinoisCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-3123605AE-20193123605Not Returned11/30/19SaturdayNovember12/5/19Second ClassOFF-ROG-100013405Office SuppliesStorageRogers File Cart, Industrial$ 141.60$ 42.48Low$ 0.280.66%10.351148855901RochesterMinnesotaCentral United StatesAnnelise WilliamsPG-8820Patrick GardnerConsumerUnited States AE-2019-3179243AE-20193179243Not Returned11/18/19MondayNovember11/19/19Second ClassTEC-MOT-100015351TechnologyPhonesMotorola Headset, VoIP$ 23.95$ 95.80Low$ 0.330.34%40.41148875220DallasTexasCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-3323423AE-20193323423Not Returned12/6/19FridayDecember12/11/19Second ClassOFF-ELD-100022975Office SuppliesStorageEldon Lockers, Blue$ 197.91$ 59.37Low$ 0.280.47%10.351148878745AustinTexasCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-3371820AE-20193371820Not Returned12/26/19ThursdayDecember12/31/19Second ClassOFF-ELD-100022975Office SuppliesStorageEldon Lockers, Blue$ 197.91$ 59.37Low$ 0.280.47%10.351148849505Grand RapidsMichiganCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-350473AE-2019350473Not Returned3/25/19MondayMarch3/29/19Same DayOFF-HON-100046214Office SuppliesLabelsHon Color Coded Labels, Adjustable$ 10.71$ 6.43Low$ 0.243.73%20.30148878577PharrTexasCentral United StatesAnnelise WilliamsJD-5790John DryerConsumerUnited States AE-2019-4073208AE-20194073208Not Returned1/13/19SundayJanuary1/18/19Second ClassOFF-TEN-100028175Office SuppliesStorageTenex Folders, Blue$ 23.22$ 6.97Low$ 0.284.02%10.351148852402Cedar RapidsIowaCentral United StatesAnnelise WilliamsMY-7380Maribeth YedwabCorporateUnited States AE-2019-4135578AE-20194135578Not Returned3/22/19FridayMarch3/23/19Same DayOFF-HON-100046211Office SuppliesLabelsHon Color Coded Labels, Adjustable$ 10.71$ 6.43Low$ 0.243.73%20.30148878745AustinTexasCentral United StatesAnnelise WilliamsJD-5790John DryerConsumerUnited States AE-2019-4220600AE-20194220600Not Returned3/24/19SundayMarch3/26/19Same DayOFF-HON-100046212Office SuppliesLabelsHon Color Coded Labels, Adjustable$ 10.71$ 6.43Low$ 0.243.73%20.30148877095HoustonTexasCentral United StatesAnnelise WilliamsJD-5790John DryerConsumerUnited States AE-2019-4244209AE-20194244209Not Returned12/18/19WednesdayDecember12/20/19Second ClassOFF-ROG-100039932Office SuppliesStorageRogers File Cart, Single Width$ 141.63$ 42.49Low$ 0.280.66%10.351148847201ColumbusIndianaCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-447833AE-2019447833Not Returned12/26/19ThursdayDecember12/26/19Second ClassOFF-AVE-100003570Office SuppliesBindersAvery Binder Covers, Clear$ 10.53$ 3.16Low$ 0.3310.44%10.41148875023PlanoTexasCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-4984367AE-20194984367Not Returned12/10/19TuesdayDecember12/11/19Second ClassOFF-ELD-100022971Office SuppliesStorageEldon Lockers, Blue$ 197.91$ 59.37Low$ 0.280.47%10.351148848310Sterling HeightsMichiganCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-5077525AE-20195077525Not Returned12/6/19FridayDecember12/8/19Second ClassOFF-AVE-100048272Office SuppliesBindersAvery Binder Covers, Recycled$ 11.43$ 3.43Low$ 0.339.62%10.41148853209MilwaukeeWisconsinCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-5351828AE-20195351828Not Returned11/19/19TuesdayNovember11/21/19Second ClassOFF-AVE-100003572Office SuppliesBindersAvery Binder Covers, Clear$ 10.53$ 3.16Low$ 0.3310.44%10.41148852302MarionIowaCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-5740368AE-20195740368Not Given12/30/19MondayDecember1/1/20Standard ClassOFF-BIC-100022702Office SuppliesArtBIC Pencil Sharpener, Water Color$ 32.19$ 77.26Low$ 0.330.43%80.41148860174Saint CharlesIllinoisCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-5941050AE-20195941050Not Given11/27/19WednesdayNovember11/30/19Second ClassOFF-ELD-100022973Office SuppliesStorageEldon Lockers, Blue$ 197.91$ 59.37Low$ 0.280.47%10.351148862301QuincyIllinoisCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AE-2019-633725AE-2019633725Not Given12/28/19SaturdayDecember1/2/20Second ClassOFF-AVE-100048275Office SuppliesBindersAvery Binder Covers, Recycled$ 11.43$ 3.43Low$ 0.339.62%10.41148877803BryanTexasCentral United StatesAnnelise WilliamsGH-4665Greg HansenConsumerUnited States AG-2019-1011961AG-20191011961Not Given11/30/19SaturdayNovember12/5/19Standard ClassTEC-STA-100006995TechnologyMachinesStarTech Phone, Red$ 71.67$ 143.34Low$ 0.240.17%20.30148847905LafayetteIndianaCentral United StatesAnnelise WilliamsDR-2940Daniel RaglinHome OfficeUnited States AG-2019-1031598AG-20191031598Not Given5/4/19SaturdayMay5/6/19Second ClassTEC-CIS-100030172TechnologyPhonesCisco Signal Booster, with Caller ID$ 151.83$ 151.83Low$ 0.100.07%10.150148860653ChicagoIllinoisCentral United StatesAnnelise WilliamsCR-2820Cyra ReitenHome OfficeUnited States AG-2019-1110396AG-20191110396Not Given1/3/19ThursdayJanuary1/6/19Same DayOFF-STI-100003053Office SuppliesSuppliesStiletto Shears, High Speed$ 48.09$ 48.09Low$ 0.050.10%10.10148875220DallasTexasCentral United StatesAnnelise WilliamsIL-5100Ivan ListonConsumerUnited States AG-2019-1153827AG-20191153827Not Given2/3/19SundayFebruary2/4/19Second ClassOFF-ROG-100033001Office SuppliesStorageRogers Box, Wire Frame$ 23.04$ 92.16Low$ 0.050.05%40.10148848234DetroitMichiganCentral United StatesAnnelise WilliamsCA-2310Christine AbelmanCorporateUnited States AG-2019-1231908AG-20191231908Not Given1/23/19WednesdayJanuary1/24/19Standard ClassFUR-RUB-100028171FurnitureFurnishingsRubbermaid Door Stop, Durable$ 40.83$ 40.83Low$ 0.050.12%10.10148849505Grand RapidsMichiganCentral United StatesAnnelise WilliamsJG-5160James GalangConsumerUnited States AG-2019-1275697AG-20191275697Not Given12/13/19FridayDecember12/14/19Standard ClassTEC-STA-100045421TechnologyMachinesStarTech Calculator, Durable$ 40.08$ 160.32Low$ 0.240.15%40.30148878745AustinTexasCentral United StatesAnnelise WilliamsYS-11880Yana SorensenCorporateUnited States AG-2019-1310837AG-20191310837Not Given6/10/19MondayJune6/15/19Second ClassOFF-FEL-100041175Office SuppliesStorageFellowes Trays, Blue$ 22.96$ 229.56Low$ 0.050.02%40.10148860653ChicagoIllinoisCentral United StatesAnnelise WilliamsDL-2865Dan LaweraConsumerUnited States AG-2019-1352224AG-20191352224Not Given5/15/19WednesdayMay5/20/19Second ClassTEC-CIS-100030175TechnologyPhonesCisco Signal Booster, with Caller ID$ 151.83$ 151.83Low$ 0.100.07%10.150148875220DallasTexasCentral United StatesAnnelise WilliamsCR-2820Cyra ReitenHome OfficeUnited States AG-2019-1366085AG-20191366085Not Given10/16/19WednesdayOctober10/21/19Standard ClassTEC-SHA-100000525TechnologyCopiersSharp Copy Machine, Color$ 240.84$ 481.68Low$ 0.190.04%20.250148848234DetroitMichiganCentral United StatesAnnelise WilliamsCC-2100Chad CunninghamHome OfficeUnited States AG-2019-1400544AG-20191400544Not Given1/29/19TuesdayJanuary1/29/19Standard ClassFUR-SAU-100022550FurnitureBookcasesSauder Classic Bookcase, Pine$ 437.34$ 874.68High$ 0.190.02%20.250148847374RichmondIndianaCentral United StatesAnnelise WilliamsSB-10170Sarah BernConsumerUnited States AG-2019-1557147AG-20191557147Not Given1/11/19FridayJanuary1/15/19First ClassOFF-AME-100008704Office SuppliesEnvelopesAmes Peel and Seal, Recycled$ 5.25$ 17.49Low$ - 00.00%10.050148876706WacoTexasCentral United StatesAnnelise WilliamsPO-8865Patrick O'DonnellConsumerUnited States AG-2019-1588096AG-20191588096Not Given5/23/19ThursdayMay5/27/19Standard ClassFUR-DEF-100028654FurnitureFurnishingsDeflect-O Light Bulb, Erganomic$ 7.04$ 17.61Low$ 0.050.28%10.10148849201JacksonMichiganCentral United StatesAnnelise WilliamsCL-2565Clay LudtkeConsumerUnited States AG-2019-1635797AG-20191635797Not Given2/3/19SundayFebruary2/8/19Same DayOFF-FIS-100000635Office SuppliesSuppliesFiskars Shears, High Speed$ 19.06$ 47.64Low$ 0.050.10%10.10148853209MilwaukeeWisconsinCentral United StatesAnnelise WilliamsPO-8865Patrick O'DonnellConsumerUnited States AG-2019-1691731AG-20191691731Not Given9/11/19WednesdaySeptember9/15/19Second ClassOFF-AVE-100047084Office SuppliesBindersAvery Binder, Recycled$ 5.30$ 13.26Low$ 0.100.75%10.150148855407MinneapolisMinnesotaCentral United StatesAnnelise WilliamsCD-2790Cynthia DelaneyHome OfficeUnited States AG-2019-179206AG-2019179206Not Given4/24/19WednesdayApril4/25/19Second ClassOFF-ROG-100018181Office SuppliesStorageRogers Folders, Single Width$ 30.72$ 122.88Low$ 0.050.04%40.10148879424LubbockTexasCentral United StatesAnnelise WilliamsBD-1605Brian DahlenConsumerUnited States AG-2019-1957110AG-20191957110Not Given8/31/19SaturdayAugust9/1/19Second ClassOFF-IBI-100000801Office SuppliesBindersIbico Binder, Recycled$ 15.84$ 15.84Low$ 0.100.63%10.150148846203IndianapolisIndianaCentral United StatesAnnelise WilliamsCC-2220Chris CortesConsumerUnited States AG-2019-1958395AG-20191958395Not Given5/16/19ThursdayMay5/16/19Second ClassOFF-TEN-100003600Office SuppliesStorageTenex Folders, Wire Frame$ 22.29$ 22.29Low$ 0.050.22%10.10148860653ChicagoIllinoisCentral United StatesAnnelise WilliamsSL-10155Sara LuxemburgHome OfficeUnited States AG-2019-2056925AG-20192056925Not Given10/28/19MondayOctober11/2/19Second ClassOFF-WIL-100006045Office SuppliesBindersWilson Jones Binder, Clear$ 12.48$ 24.96Low$ 0.100.40%20.150148877095HoustonTexasCentral United StatesAnnelise WilliamsJL-5835John LeeConsumerUnited States AG-2019-2066119AG-20192066119Not Given7/8/19MondayJuly7/11/19Standard ClassTEC-PAN-100009793TechnologyMachinesPanasonic Receipt Printer, Wireless$ 120.90$ 241.80Low$ 0.240.10%20.30148865807SpringfieldMissouriCentral United StatesAnnelise WilliamsDL-2865Dan LaweraConsumerUnited States AG-2019-2198541AG-20192198541Not Given9/7/19SaturdaySeptember9/11/19Second ClassTEC-NOK-100045414TechnologyPhonesNokia Office Telephone, Cordless$ 67.98$ 67.98Low$ 0.100.15%10.150148848234DetroitMichiganCentral United StatesAnnelise WilliamsCD-2790Cynthia DelaneyHome OfficeUnited States AG-2019-2231275AG-20192231275Not Given8/28/19WednesdayAugust8/29/19Second ClassTEC-MEM-100025241TechnologyAccessoriesMemorex Mouse, USB$ 11.35$ 56.76Low$ - 00.00%20.050148878521BrownsvilleTexasCentral United StatesAnnelise WilliamsCD-2790Cynthia DelaneyHome OfficeUnited States AG-2019-2332510AG-20192332510Not Given12/1/19SundayDecember12/6/19Second ClassOFF-TEN-100007945Office SuppliesStorageTenex Shelving, Wire Frame$ 53.73$ 53.73Low$ 0.050.09%10.10148877095HoustonTexasCentral United StatesAnnelise WilliamsMS-7980Michael StewartCorporateUnited States AG-2019-2333770AG-20192333770Not Given6/22/19SaturdayJune6/27/19Second ClassTEC-APP-100011085TechnologyPhonesApple Headset, with Caller ID$ 73.26$ 73.26Low$ 0.100.14%10.150148877642Port ArthurTexasCentral United StatesAnnelise WilliamsAM-360Alice McCarthyCorporateUnited States AG-2019-2383697AG-20192383697Not Given10/16/19WednesdayOctober10/17/19Standard ClassTEC-SHA-100000521TechnologyCopiersSharp Copy Machine, Color$ 240.84$ 481.68Low$ 0.190.04%20.250148852402Cedar RapidsIowaCentral United StatesAnnelise WilliamsCC-2100Chad CunninghamHome OfficeUnited States AG-2019-2384745AG-20192384745Not Given5/12/19SundayMay5/16/19Standard ClassOFF-KIT-100017914Office SuppliesAppliancesKitchenAid Refrigerator, White$ 526.08$ 1,052.16High$ 0.280.03%20.351148868104OmahaNebraskaCentral United StatesAnnelise WilliamsCL-2565Clay LudtkeConsumerUnited States AG-2019-2424042AG-20192424042Not Given10/14/19MondayOctober10/16/19Second ClassOFF-WIL-100006042Office SuppliesBindersWilson Jones Binder, Clear$ 12.48$ 24.96Low$ 0.100.40%20.150148860440BolingbrookIllinoisCentral United StatesAnnelise WilliamsJL-5835John LeeConsumerUnited States AG-2019-2448243AG-20192448243Not Given8/18/19SundayAugust8/23/19Second ClassOFF-AVE-100047085Office SuppliesBindersAvery Binder, Recycled$ 5.30$ 13.26Low$ 0.100.75%10.150148860653ChicagoIllinoisCentral United StatesAnnelise WilliamsCD-2790Cynthia DelaneyHome OfficeUnited States AG-2019-2455899AG-20192455899Not Given12/15/19SundayDecember12/15/19Standard ClassTEC-STA-100045420TechnologyMachinesStarTech Calculator, Durable$ 40.08$ 160.32Low$ 0.240.15%40.30148860188Carol StreamIllinoisCentral United StatesAnnelise WilliamsYS-11880Yana SorensenCorporateUnited States AG-2019-2534608AG-20192534608Not Given8/7/19WednesdayAugust8/7/19Standard ClassTEC-OKI-100027500TechnologyMachinesOkidata Inkjet, Wireless$ 94.27$ 314.22Low$ 0.240.08%10.30148853711MadisonWisconsinCentral United StatesAnnelise WilliamsHR-4830Harold RyanCorporateUnited States AG-2019-261749AG-2019261749Not Given9/19/19ThursdaySeptember9/19/19Second ClassOFF-IBI-100000800Office SuppliesBindersIbico Binder, Recycled$ 15.84$ 15.84Low$ 0.100.63%10.150148848601SaginawMichiganCentral United StatesAnnelise WilliamsCC-2220Chris CortesConsumerUnited States AG-2019-2728572AG-20192728572Not Given5/25/19SaturdayMay5/28/19Second ClassOFF-TEN-100003603Office SuppliesStorageTenex Folders, Wire Frame$ 22.29$ 22.29Low$ 0.050.22%10.10148873120Oklahoma CityOklahomaCentral United StatesAnnelise WilliamsSL-10155Sara LuxemburgHome OfficeUnited States AG-2019-2963245AG-20192963245Not Given10/29/19TuesdayOctober11/2/19Standard ClassOFF-STA-100002984Office SuppliesArtStanley Canvas, Blue$ 49.47$ 98.94Low$ 0.100.10%20.150148868025FremontNebraskaCentral United StatesAnnelise WilliamsDR-2940Daniel RaglinHome OfficeUnited States AG-2019-3032982AG-20193032982Not Given5/16/19ThursdayMay5/19/19Second ClassOFF-WIL-100019793Office SuppliesBindersWilson Jones Binder Covers, Clear$ 10.65$ 21.30Low$ 0.100.47%20.150148860543OswegoIllinoisCentral United StatesAnnelise WilliamsCL-2565Clay LudtkeConsumerUnited States AG-2019-3063469AG-20193063469Not Given3/7/19ThursdayMarch3/9/19Second ClassOFF-ELD-100008452Office SuppliesStorageEldon Lockers, Wire Frame$ 196.98$ 196.98Low$ 0.050.03%10.10148878550HarlingenTexasCentral United StatesAnnelise WilliamsAC-420Alyssa CrouseCorporateUnited States AG-2019-3078752AG-20193078752Not Given11/30/19SaturdayNovember12/3/19Second ClassOFF-WIL-100006043Office SuppliesBindersWilson Jones Binder, Clear$ 12.48$ 24.96Low$ 0.100.40%20.150148868025FremontNebraskaCentral United StatesAnnelise WilliamsJL-5835John LeeConsumerUnited States AG-2019-321771AG-2019321771Not Given2/16/19SaturdayFebruary2/21/19Second ClassTEC-SAN-100022545TechnologyAccessoriesSanDisk Mouse, USB$ 38.52$ 38.52Low$ - 00.00%10.050148854703Eau ClaireWisconsinCentral United StatesAnnelise WilliamsAC-420Alyssa CrouseCorporateUnited States AG-2019-3234894AG-20193234894Not Given2/5/19TuesdayFebruary2/10/19Standard ClassFUR-HON-100017765FurnitureChairsHon Bag Chairs, Red$ 18.06$ 90.30Low$ 0.140.16%20.20148855901RochesterMinnesotaCentral United StatesAnnelise WilliamsIL-5100Ivan ListonConsumerUnited States AG-2019-3236544AG-20193236544Not Given11/9/19SaturdayNovember11/10/19Standard ClassTEC-BRO-100041781TechnologyCopiersBrother Wireless Fax, Laser$ 378.81$ 1,515.24High$ 0.190.01%40.250148879907El PasoTexasCentral United StatesAnnelise WilliamsRD-9660Robert DilbeckHome OfficeUnited States AG-2019-3261303AG-20193261303Not Given9/11/19WednesdaySeptember9/14/19Second ClassTEC-MEM-100025243TechnologyAccessoriesMemorex Mouse, USB$ 11.35$ 56.76Low$ - 00.00%20.050148846142GreenwoodIndianaCentral United StatesAnnelise WilliamsCD-2790Cynthia DelaneyHome OfficeUnited States AG-2019-3407916AG-20193407916Not Given1/12/19SaturdayJanuary1/15/19First ClassOFF-AME-100008703Office SuppliesEnvelopesAmes Peel and Seal, Recycled$ 5.25$ 17.49Low$ - 00.00%10.050148877095HoustonTexasCentral United StatesAnnelise WilliamsPO-8865Patrick O'DonnellConsumerUnited States AG-2019-3416342AG-20193416342Not Given3/24/19SundayMarch3/29/19Same DayOFF-STO-100043635Office SuppliesFastenersStockwell Paper Clips, Bulk Pack$ 13.62$ 27.24Low$ - 00.00%20.050148878207San AntonioTexasCentral United StatesAnnelise WilliamsAC-420Alyssa CrouseCorporateUnited States AG-2019-347262AG-2019347262Not Given8/30/19FridayAugust9/4/19Second ClassTEC-MEM-100025245TechnologyAccessoriesMemorex Mouse, USB$ 11.35$ 56.76Low$ - 00.00%20.050148875220DallasTexasCentral United StatesAnnelise WilliamsCD-2790Cynthia DelaneyHome OfficeUnited States AG-2019-3495968AG-20193495968Not Given12/21/19SaturdayDecember12/22/19Standard ClassTEC-BRO-100041781TechnologyCopiersBrother Wireless Fax,
Answered Same DayJun 19, 2022

Answer To: Tableau Assignment BUSI 650 – Business Analytics The provided dataset “Walmart Sales” contains the...

Suraj answered on Jun 19 2022
81 Votes
Tableau Assignment
BUSI 650 – Business Analytics
Solution:
h)
In this section we will explain the insi
ghts gained from the interactive dashboard created for the Walmart Sales data.
From the histograms created we can see that; the maximum sales are for the office supplies for storage subcategory. Also, the maximum discount offers for the Binders sub category under the office supplies.
The maximum profit gained for storage under the office supplies category of value $2139. Also, technology factor has loss of value $3840.
The maximum profit margin gained in the office supplies for labels sub-category. Also, there is some sort of loss also in some sub-categories.
Also, the sales are increasing month by month. We can see there are minimum sales in the month of February and maximum sales are in the November month and after it the cycle will repeated again.
We can also see that maximum sales happened on Tuesday and minimum sales on Friday.
From the geographical map view graph created we can see that maximum profit gained city is Chicago...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here