Subject: Business AnalyticsTableau Assignment BUSI 650 – Business Analytics The provided dataset...

Question

Subject: Business AnalyticsTableau 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_id	order_info_id	order_id_number	return_reason	order_date	order_weekday	order_month	ship_date	ship_mode	product_id	days_to_ship	category	sub_category	product_name	unit_cost	sales	sales_volume	profit	profit_margin	quantity	discount	discount_over_30	region_id	postal_code	city	state 	sub_region	salesperson	customer_id	customer_name	segment	Country 	AE-2019-1231682	AE-2019	1231682	Not Returned	12/18/19	Wednesday	December	12/23/19	Second Class	TEC-MOT-10001535	5	Technology	Phones	Motorola Headset, VoIP	$   23.95	$   95.80	Low	$   0.33	0.34%	4	0.4	1	1488	47374	Richmond	Indiana	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-1263608	AE-2019	1263608	Not Returned	12/26/19	Thursday	December	12/31/19	Second Class	OFF-AVE-10004827	5	Office Supplies	Binders	Avery Binder Covers, Recycled	$   11.43	$   3.43	Low	$   0.33	9.62%	1	0.4	1	1488	78745	Austin	Texas	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-303016	AE-2019	303016	Not Returned	12/18/19	Wednesday	December	12/23/19	Second Class	TEC-MOT-10001535	5	Technology	Phones	Motorola Headset, VoIP	$   23.95	$   95.80	Low	$   0.33	0.34%	4	0.4	1	1488	52402	Cedar Rapids	Iowa	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-304471	AE-2019	304471	Not Returned	12/27/19	Friday	December	12/31/19	Second Class	TEC-MOT-10001535	4	Technology	Phones	Motorola Headset, VoIP	$   23.95	$   95.80	Low	$   0.33	0.34%	4	0.4	1	1488	60653	Chicago	Illinois	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-3123605	AE-2019	3123605	Not Returned	11/30/19	Saturday	November	12/5/19	Second Class	OFF-ROG-10001340	5	Office Supplies	Storage	Rogers File Cart, Industrial	$   141.60	$   42.48	Low	$   0.28	0.66%	1	0.35	1	1488	55901	Rochester	Minnesota	Central United States	Annelise Williams	PG-8820	Patrick Gardner	Consumer	United States 	AE-2019-3179243	AE-2019	3179243	Not Returned	11/18/19	Monday	November	11/19/19	Second Class	TEC-MOT-10001535	1	Technology	Phones	Motorola Headset, VoIP	$   23.95	$   95.80	Low	$   0.33	0.34%	4	0.4	1	1488	75220	Dallas	Texas	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-3323423	AE-2019	3323423	Not Returned	12/6/19	Friday	December	12/11/19	Second Class	OFF-ELD-10002297	5	Office Supplies	Storage	Eldon Lockers, Blue	$   197.91	$   59.37	Low	$   0.28	0.47%	1	0.35	1	1488	78745	Austin	Texas	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-3371820	AE-2019	3371820	Not Returned	12/26/19	Thursday	December	12/31/19	Second Class	OFF-ELD-10002297	5	Office Supplies	Storage	Eldon Lockers, Blue	$   197.91	$   59.37	Low	$   0.28	0.47%	1	0.35	1	1488	49505	Grand Rapids	Michigan	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-350473	AE-2019	350473	Not Returned	3/25/19	Monday	March	3/29/19	Same Day	OFF-HON-10004621	4	Office Supplies	Labels	Hon Color Coded Labels, Adjustable	$   10.71	$   6.43	Low	$   0.24	3.73%	2	0.3	0	1488	78577	Pharr	Texas	Central United States	Annelise Williams	JD-5790	John Dryer	Consumer	United States 	AE-2019-4073208	AE-2019	4073208	Not Returned	1/13/19	Sunday	January	1/18/19	Second Class	OFF-TEN-10002817	5	Office Supplies	Storage	Tenex Folders, Blue	$   23.22	$   6.97	Low	$   0.28	4.02%	1	0.35	1	1488	52402	Cedar Rapids	Iowa	Central United States	Annelise Williams	MY-7380	Maribeth Yedwab	Corporate	United States 	AE-2019-4135578	AE-2019	4135578	Not Returned	3/22/19	Friday	March	3/23/19	Same Day	OFF-HON-10004621	1	Office Supplies	Labels	Hon Color Coded Labels, Adjustable	$   10.71	$   6.43	Low	$   0.24	3.73%	2	0.3	0	1488	78745	Austin	Texas	Central United States	Annelise Williams	JD-5790	John Dryer	Consumer	United States 	AE-2019-4220600	AE-2019	4220600	Not Returned	3/24/19	Sunday	March	3/26/19	Same Day	OFF-HON-10004621	2	Office Supplies	Labels	Hon Color Coded Labels, Adjustable	$   10.71	$   6.43	Low	$   0.24	3.73%	2	0.3	0	1488	77095	Houston	Texas	Central United States	Annelise Williams	JD-5790	John Dryer	Consumer	United States 	AE-2019-4244209	AE-2019	4244209	Not Returned	12/18/19	Wednesday	December	12/20/19	Second Class	OFF-ROG-10003993	2	Office Supplies	Storage	Rogers File Cart, Single Width	$   141.63	$   42.49	Low	$   0.28	0.66%	1	0.35	1	1488	47201	Columbus	Indiana	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-447833	AE-2019	447833	Not Returned	12/26/19	Thursday	December	12/26/19	Second Class	OFF-AVE-10000357	0	Office Supplies	Binders	Avery Binder Covers, Clear	$   10.53	$   3.16	Low	$   0.33	10.44%	1	0.4	1	1488	75023	Plano	Texas	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-4984367	AE-2019	4984367	Not Returned	12/10/19	Tuesday	December	12/11/19	Second Class	OFF-ELD-10002297	1	Office Supplies	Storage	Eldon Lockers, Blue	$   197.91	$   59.37	Low	$   0.28	0.47%	1	0.35	1	1488	48310	Sterling Heights	Michigan	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-5077525	AE-2019	5077525	Not Returned	12/6/19	Friday	December	12/8/19	Second Class	OFF-AVE-10004827	2	Office Supplies	Binders	Avery Binder Covers, Recycled	$   11.43	$   3.43	Low	$   0.33	9.62%	1	0.4	1	1488	53209	Milwaukee	Wisconsin	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-5351828	AE-2019	5351828	Not Returned	11/19/19	Tuesday	November	11/21/19	Second Class	OFF-AVE-10000357	2	Office Supplies	Binders	Avery Binder Covers, Clear	$   10.53	$   3.16	Low	$   0.33	10.44%	1	0.4	1	1488	52302	Marion	Iowa	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-5740368	AE-2019	5740368	Not Given	12/30/19	Monday	December	1/1/20	Standard Class	OFF-BIC-10002270	2	Office Supplies	Art	BIC Pencil Sharpener, Water Color	$   32.19	$   77.26	Low	$   0.33	0.43%	8	0.4	1	1488	60174	Saint Charles	Illinois	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-5941050	AE-2019	5941050	Not Given	11/27/19	Wednesday	November	11/30/19	Second Class	OFF-ELD-10002297	3	Office Supplies	Storage	Eldon Lockers, Blue	$   197.91	$   59.37	Low	$   0.28	0.47%	1	0.35	1	1488	62301	Quincy	Illinois	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AE-2019-633725	AE-2019	633725	Not Given	12/28/19	Saturday	December	1/2/20	Second Class	OFF-AVE-10004827	5	Office Supplies	Binders	Avery Binder Covers, Recycled	$   11.43	$   3.43	Low	$   0.33	9.62%	1	0.4	1	1488	77803	Bryan	Texas	Central United States	Annelise Williams	GH-4665	Greg Hansen	Consumer	United States 	AG-2019-1011961	AG-2019	1011961	Not Given	11/30/19	Saturday	November	12/5/19	Standard Class	TEC-STA-10000699	5	Technology	Machines	StarTech Phone, Red	$   71.67	$   143.34	Low	$   0.24	0.17%	2	0.3	0	1488	47905	Lafayette	Indiana	Central United States	Annelise Williams	DR-2940	Daniel Raglin	Home Office	United States 	AG-2019-1031598	AG-2019	1031598	Not Given	5/4/19	Saturday	May	5/6/19	Second Class	TEC-CIS-10003017	2	Technology	Phones	Cisco Signal Booster, with Caller ID	$   151.83	$   151.83	Low	$   0.10	0.07%	1	0.15	0	1488	60653	Chicago	Illinois	Central United States	Annelise Williams	CR-2820	Cyra Reiten	Home Office	United States 	AG-2019-1110396	AG-2019	1110396	Not Given	1/3/19	Thursday	January	1/6/19	Same Day	OFF-STI-10000305	3	Office Supplies	Supplies	Stiletto Shears, High Speed	$   48.09	$   48.09	Low	$   0.05	0.10%	1	0.1	0	1488	75220	Dallas	Texas	Central United States	Annelise Williams	IL-5100	Ivan Liston	Consumer	United States 	AG-2019-1153827	AG-2019	1153827	Not Given	2/3/19	Sunday	February	2/4/19	Second Class	OFF-ROG-10003300	1	Office Supplies	Storage	Rogers Box, Wire Frame	$   23.04	$   92.16	Low	$   0.05	0.05%	4	0.1	0	1488	48234	Detroit	Michigan	Central United States	Annelise Williams	CA-2310	Christine Abelman	Corporate	United States 	AG-2019-1231908	AG-2019	1231908	Not Given	1/23/19	Wednesday	January	1/24/19	Standard Class	FUR-RUB-10002817	1	Furniture	Furnishings	Rubbermaid Door Stop, Durable	$   40.83	$   40.83	Low	$   0.05	0.12%	1	0.1	0	1488	49505	Grand Rapids	Michigan	Central United States	Annelise Williams	JG-5160	James Galang	Consumer	United States 	AG-2019-1275697	AG-2019	1275697	Not Given	12/13/19	Friday	December	12/14/19	Standard Class	TEC-STA-10004542	1	Technology	Machines	StarTech Calculator, Durable	$   40.08	$   160.32	Low	$   0.24	0.15%	4	0.3	0	1488	78745	Austin	Texas	Central United States	Annelise Williams	YS-11880	Yana Sorensen	Corporate	United States 	AG-2019-1310837	AG-2019	1310837	Not Given	6/10/19	Monday	June	6/15/19	Second Class	OFF-FEL-10004117	5	Office Supplies	Storage	Fellowes Trays, Blue	$   22.96	$   229.56	Low	$   0.05	0.02%	4	0.1	0	1488	60653	Chicago	Illinois	Central United States	Annelise Williams	DL-2865	Dan Lawera	Consumer	United States 	AG-2019-1352224	AG-2019	1352224	Not Given	5/15/19	Wednesday	May	5/20/19	Second Class	TEC-CIS-10003017	5	Technology	Phones	Cisco Signal Booster, with Caller ID	$   151.83	$   151.83	Low	$   0.10	0.07%	1	0.15	0	1488	75220	Dallas	Texas	Central United States	Annelise Williams	CR-2820	Cyra Reiten	Home Office	United States 	AG-2019-1366085	AG-2019	1366085	Not Given	10/16/19	Wednesday	October	10/21/19	Standard Class	TEC-SHA-10000052	5	Technology	Copiers	Sharp Copy Machine, Color	$   240.84	$   481.68	Low	$   0.19	0.04%	2	0.25	0	1488	48234	Detroit	Michigan	Central United States	Annelise Williams	CC-2100	Chad Cunningham	Home Office	United States 	AG-2019-1400544	AG-2019	1400544	Not Given	1/29/19	Tuesday	January	1/29/19	Standard Class	FUR-SAU-10002255	0	Furniture	Bookcases	Sauder Classic Bookcase, Pine	$   437.34	$   874.68	High	$   0.19	0.02%	2	0.25	0	1488	47374	Richmond	Indiana	Central United States	Annelise Williams	SB-10170	Sarah Bern	Consumer	United States 	AG-2019-1557147	AG-2019	1557147	Not Given	1/11/19	Friday	January	1/15/19	First Class	OFF-AME-10000870	4	Office Supplies	Envelopes	Ames Peel and Seal, Recycled	$   5.25	$   17.49	Low	$   - 0	0.00%	1	0.05	0	1488	76706	Waco	Texas	Central United States	Annelise Williams	PO-8865	Patrick O'Donnell	Consumer	United States 	AG-2019-1588096	AG-2019	1588096	Not Given	5/23/19	Thursday	May	5/27/19	Standard Class	FUR-DEF-10002865	4	Furniture	Furnishings	Deflect-O Light Bulb, Erganomic	$   7.04	$   17.61	Low	$   0.05	0.28%	1	0.1	0	1488	49201	Jackson	Michigan	Central United States	Annelise Williams	CL-2565	Clay Ludtke	Consumer	United States 	AG-2019-1635797	AG-2019	1635797	Not Given	2/3/19	Sunday	February	2/8/19	Same Day	OFF-FIS-10000063	5	Office Supplies	Supplies	Fiskars Shears, High Speed	$   19.06	$   47.64	Low	$   0.05	0.10%	1	0.1	0	1488	53209	Milwaukee	Wisconsin	Central United States	Annelise Williams	PO-8865	Patrick O'Donnell	Consumer	United States 	AG-2019-1691731	AG-2019	1691731	Not Given	9/11/19	Wednesday	September	9/15/19	Second Class	OFF-AVE-10004708	4	Office Supplies	Binders	Avery Binder, Recycled	$   5.30	$   13.26	Low	$   0.10	0.75%	1	0.15	0	1488	55407	Minneapolis	Minnesota	Central United States	Annelise Williams	CD-2790	Cynthia Delaney	Home Office	United States 	AG-2019-179206	AG-2019	179206	Not Given	4/24/19	Wednesday	April	4/25/19	Second Class	OFF-ROG-10001818	1	Office Supplies	Storage	Rogers Folders, Single Width	$   30.72	$   122.88	Low	$   0.05	0.04%	4	0.1	0	1488	79424	Lubbock	Texas	Central United States	Annelise Williams	BD-1605	Brian Dahlen	Consumer	United States 	AG-2019-1957110	AG-2019	1957110	Not Given	8/31/19	Saturday	August	9/1/19	Second Class	OFF-IBI-10000080	1	Office Supplies	Binders	Ibico Binder, Recycled	$   15.84	$   15.84	Low	$   0.10	0.63%	1	0.15	0	1488	46203	Indianapolis	Indiana	Central United States	Annelise Williams	CC-2220	Chris Cortes	Consumer	United States 	AG-2019-1958395	AG-2019	1958395	Not Given	5/16/19	Thursday	May	5/16/19	Second Class	OFF-TEN-10000360	0	Office Supplies	Storage	Tenex Folders, Wire Frame	$   22.29	$   22.29	Low	$   0.05	0.22%	1	0.1	0	1488	60653	Chicago	Illinois	Central United States	Annelise Williams	SL-10155	Sara Luxemburg	Home Office	United States 	AG-2019-2056925	AG-2019	2056925	Not Given	10/28/19	Monday	October	11/2/19	Second Class	OFF-WIL-10000604	5	Office Supplies	Binders	Wilson Jones Binder, Clear	$   12.48	$   24.96	Low	$   0.10	0.40%	2	0.15	0	1488	77095	Houston	Texas	Central United States	Annelise Williams	JL-5835	John Lee	Consumer	United States 	AG-2019-2066119	AG-2019	2066119	Not Given	7/8/19	Monday	July	7/11/19	Standard Class	TEC-PAN-10000979	3	Technology	Machines	Panasonic Receipt Printer, Wireless	$   120.90	$   241.80	Low	$   0.24	0.10%	2	0.3	0	1488	65807	Springfield	Missouri	Central United States	Annelise Williams	DL-2865	Dan Lawera	Consumer	United States 	AG-2019-2198541	AG-2019	2198541	Not Given	9/7/19	Saturday	September	9/11/19	Second Class	TEC-NOK-10004541	4	Technology	Phones	Nokia Office Telephone, Cordless	$   67.98	$   67.98	Low	$   0.10	0.15%	1	0.15	0	1488	48234	Detroit	Michigan	Central United States	Annelise Williams	CD-2790	Cynthia Delaney	Home Office	United States 	AG-2019-2231275	AG-2019	2231275	Not Given	8/28/19	Wednesday	August	8/29/19	Second Class	TEC-MEM-10002524	1	Technology	Accessories	Memorex Mouse, USB	$   11.35	$   56.76	Low	$   - 0	0.00%	2	0.05	0	1488	78521	Brownsville	Texas	Central United States	Annelise Williams	CD-2790	Cynthia Delaney	Home Office	United States 	AG-2019-2332510	AG-2019	2332510	Not Given	12/1/19	Sunday	December	12/6/19	Second Class	OFF-TEN-10000794	5	Office Supplies	Storage	Tenex Shelving, Wire Frame	$   53.73	$   53.73	Low	$   0.05	0.09%	1	0.1	0	1488	77095	Houston	Texas	Central United States	Annelise Williams	MS-7980	Michael Stewart	Corporate	United States 	AG-2019-2333770	AG-2019	2333770	Not Given	6/22/19	Saturday	June	6/27/19	Second Class	TEC-APP-10001108	5	Technology	Phones	Apple Headset, with Caller ID	$   73.26	$   73.26	Low	$   0.10	0.14%	1	0.15	0	1488	77642	Port Arthur	Texas	Central United States	Annelise Williams	AM-360	Alice McCarthy	Corporate	United States 	AG-2019-2383697	AG-2019	2383697	Not Given	10/16/19	Wednesday	October	10/17/19	Standard Class	TEC-SHA-10000052	1	Technology	Copiers	Sharp Copy Machine, Color	$   240.84	$   481.68	Low	$   0.19	0.04%	2	0.25	0	1488	52402	Cedar Rapids	Iowa	Central United States	Annelise Williams	CC-2100	Chad Cunningham	Home Office	United States 	AG-2019-2384745	AG-2019	2384745	Not Given	5/12/19	Sunday	May	5/16/19	Standard Class	OFF-KIT-10001791	4	Office Supplies	Appliances	KitchenAid Refrigerator, White	$   526.08	$   1,052.16	High	$   0.28	0.03%	2	0.35	1	1488	68104	Omaha	Nebraska	Central United States	Annelise Williams	CL-2565	Clay Ludtke	Consumer	United States 	AG-2019-2424042	AG-2019	2424042	Not Given	10/14/19	Monday	October	10/16/19	Second Class	OFF-WIL-10000604	2	Office Supplies	Binders	Wilson Jones Binder, Clear	$   12.48	$   24.96	Low	$   0.10	0.40%	2	0.15	0	1488	60440	Bolingbrook	Illinois	Central United States	Annelise Williams	JL-5835	John Lee	Consumer	United States 	AG-2019-2448243	AG-2019	2448243	Not Given	8/18/19	Sunday	August	8/23/19	Second Class	OFF-AVE-10004708	5	Office Supplies	Binders	Avery Binder, Recycled	$   5.30	$   13.26	Low	$   0.10	0.75%	1	0.15	0	1488	60653	Chicago	Illinois	Central United States	Annelise Williams	CD-2790	Cynthia Delaney	Home Office	United States 	AG-2019-2455899	AG-2019	2455899	Not Given	12/15/19	Sunday	December	12/15/19	Standard Class	TEC-STA-10004542	0	Technology	Machines	StarTech Calculator, Durable	$   40.08	$   160.32	Low	$   0.24	0.15%	4	0.3	0	1488	60188	Carol Stream	Illinois	Central United States	Annelise Williams	YS-11880	Yana Sorensen	Corporate	United States 	AG-2019-2534608	AG-2019	2534608	Not Given	8/7/19	Wednesday	August	8/7/19	Standard Class	TEC-OKI-10002750	0	Technology	Machines	Okidata Inkjet, Wireless	$   94.27	$   314.22	Low	$   0.24	0.08%	1	0.3	0	1488	53711	Madison	Wisconsin	Central United States	Annelise Williams	HR-4830	Harold Ryan	Corporate	United States 	AG-2019-261749	AG-2019	261749	Not Given	9/19/19	Thursday	September	9/19/19	Second Class	OFF-IBI-10000080	0	Office Supplies	Binders	Ibico Binder, Recycled	$   15.84	$   15.84	Low	$   0.10	0.63%	1	0.15	0	1488	48601	Saginaw	Michigan	Central United States	Annelise Williams	CC-2220	Chris Cortes	Consumer	United States 	AG-2019-2728572	AG-2019	2728572	Not Given	5/25/19	Saturday	May	5/28/19	Second Class	OFF-TEN-10000360	3	Office Supplies	Storage	Tenex Folders, Wire Frame	$   22.29	$   22.29	Low	$   0.05	0.22%	1	0.1	0	1488	73120	Oklahoma City	Oklahoma	Central United States	Annelise Williams	SL-10155	Sara Luxemburg	Home Office	United States 	AG-2019-2963245	AG-2019	2963245	Not Given	10/29/19	Tuesday	October	11/2/19	Standard Class	OFF-STA-10000298	4	Office Supplies	Art	Stanley Canvas, Blue	$   49.47	$   98.94	Low	$   0.10	0.10%	2	0.15	0	1488	68025	Fremont	Nebraska	Central United States	Annelise Williams	DR-2940	Daniel Raglin	Home Office	United States 	AG-2019-3032982	AG-2019	3032982	Not Given	5/16/19	Thursday	May	5/19/19	Second Class	OFF-WIL-10001979	3	Office Supplies	Binders	Wilson Jones Binder Covers, Clear	$   10.65	$   21.30	Low	$   0.10	0.47%	2	0.15	0	1488	60543	Oswego	Illinois	Central United States	Annelise Williams	CL-2565	Clay Ludtke	Consumer	United States 	AG-2019-3063469	AG-2019	3063469	Not Given	3/7/19	Thursday	March	3/9/19	Second Class	OFF-ELD-10000845	2	Office Supplies	Storage	Eldon Lockers, Wire Frame	$   196.98	$   196.98	Low	$   0.05	0.03%	1	0.1	0	1488	78550	Harlingen	Texas	Central United States	Annelise Williams	AC-420	Alyssa Crouse	Corporate	United States 	AG-2019-3078752	AG-2019	3078752	Not Given	11/30/19	Saturday	November	12/3/19	Second Class	OFF-WIL-10000604	3	Office Supplies	Binders	Wilson Jones Binder, Clear	$   12.48	$   24.96	Low	$   0.10	0.40%	2	0.15	0	1488	68025	Fremont	Nebraska	Central United States	Annelise Williams	JL-5835	John Lee	Consumer	United States 	AG-2019-321771	AG-2019	321771	Not Given	2/16/19	Saturday	February	2/21/19	Second Class	TEC-SAN-10002254	5	Technology	Accessories	SanDisk Mouse, USB	$   38.52	$   38.52	Low	$   - 0	0.00%	1	0.05	0	1488	54703	Eau Claire	Wisconsin	Central United States	Annelise Williams	AC-420	Alyssa Crouse	Corporate	United States 	AG-2019-3234894	AG-2019	3234894	Not Given	2/5/19	Tuesday	February	2/10/19	Standard Class	FUR-HON-10001776	5	Furniture	Chairs	Hon Bag Chairs, Red	$   18.06	$   90.30	Low	$   0.14	0.16%	2	0.2	0	1488	55901	Rochester	Minnesota	Central United States	Annelise Williams	IL-5100	Ivan Liston	Consumer	United States 	AG-2019-3236544	AG-2019	3236544	Not Given	11/9/19	Saturday	November	11/10/19	Standard Class	TEC-BRO-10004178	1	Technology	Copiers	Brother Wireless Fax, Laser	$   378.81	$   1,515.24	High	$   0.19	0.01%	4	0.25	0	1488	79907	El Paso	Texas	Central United States	Annelise Williams	RD-9660	Robert Dilbeck	Home Office	United States 	AG-2019-3261303	AG-2019	3261303	Not Given	9/11/19	Wednesday	September	9/14/19	Second Class	TEC-MEM-10002524	3	Technology	Accessories	Memorex Mouse, USB	$   11.35	$   56.76	Low	$   - 0	0.00%	2	0.05	0	1488	46142	Greenwood	Indiana	Central United States	Annelise Williams	CD-2790	Cynthia Delaney	Home Office	United States 	AG-2019-3407916	AG-2019	3407916	Not Given	1/12/19	Saturday	January	1/15/19	First Class	OFF-AME-10000870	3	Office Supplies	Envelopes	Ames Peel and Seal, Recycled	$   5.25	$   17.49	Low	$   - 0	0.00%	1	0.05	0	1488	77095	Houston	Texas	Central United States	Annelise Williams	PO-8865	Patrick O'Donnell	Consumer	United States 	AG-2019-3416342	AG-2019	3416342	Not Given	3/24/19	Sunday	March	3/29/19	Same Day	OFF-STO-10004363	5	Office Supplies	Fasteners	Stockwell Paper Clips, Bulk Pack	$   13.62	$   27.24	Low	$   - 0	0.00%	2	0.05	0	1488	78207	San Antonio	Texas	Central United States	Annelise Williams	AC-420	Alyssa Crouse	Corporate	United States 	AG-2019-347262	AG-2019	347262	Not Given	8/30/19	Friday	August	9/4/19	Second Class	TEC-MEM-10002524	5	Technology	Accessories	Memorex Mouse, USB	$   11.35	$   56.76	Low	$   - 0	0.00%	2	0.05	0	1488	75220	Dallas	Texas	Central United States	Annelise Williams	CD-2790	Cynthia Delaney	Home Office	United States 	AG-2019-3495968	AG-2019	3495968	Not Given	12/21/19	Saturday	December	12/22/19	Standard Class	TEC-BRO-10004178	1	Technology	Copiers	Brother Wireless Fax,

Suraj · Accepted Answer

Tableau Assignment
BUSI 650 – Business Analytics
Solution:
h)
In this section we will explain the insights 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.

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...

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

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment