Data: Excel File Lab 4-5 Data.xlsx.

Sales_Transactions

Sales_Order_ID	Sales_Order_Date	Sales_Employee_ID	Customer_ID	Product_Code	Sales_Order_Quantity_Sold	Product_Sale_Price
20062	11/22/2019	1007	2001	2004	12	105
20168	12/27/2019	1007	2001	2005	8	85
20383	3/4/2020	1007	2001	2004	5	105
20564	4/28/2020	1007	2001	2002	6	120
20140	12/20/2019	1006	2002	2001	5	95
20310	2/11/2020	1007	2002	2004	2	105
20308	2/11/2020	1006	2004	2004	8	105
20308	2/11/2020	1006	2004	2003	11	100
20009	11/2/2019	1006	2005	2004	3	105
20233	1/16/2020	1006	2006	2003	7	100
20163	12/25/2019	1006	2007	2003	3	100
20224	1/13/2020	1006	2007	2001	1	95
20199	1/7/2020	1007	2008	2005	8	85
20291	2/4/2020	1007	2008	2005	7	85
20451	3/24/2020	1006	2008	2006	9	90
20451	3/24/2020	1006	2008	2002	2	120
20012	11/4/2019	1006	2009	2005	1	85
20494	4/8/2020	1006	2009	2005	6	85
20494	4/8/2020	1006	2009	2004	2	105
20537	4/19/2020	1007	2009	2004	6	105
20250	1/22/2020	1006	2010	2005	5	85
20251	1/22/2020	1007	2010	2004	11	105
20003	11/1/2019	1006	2011	2006	8	90
20241	1/19/2020	1007	2011	2004	2	105
20253	1/22/2020	1007	2011	2005	10	85
20005	11/1/2019	1006	2012	2006	9	90
20005	11/1/2019	1006	2012	2001	8	95
20090	12/1/2019	1006	2012	2002	10	120
20033	11/12/2019	1007	2013	2003	1	100
20211	1/10/2020	1007	2013	2006	12	90
20211	1/10/2020	1007	2013	2005	12	85
20338	2/22/2020	1006	2013	2005	6	85
20393	3/7/2020	1007	2013	2003	9	100
20097	12/4/2019	1007	2014	2003	9	100
20418	3/14/2020	1006	2016	2006	12	90
20543	4/20/2020	1006	2016	2003	3	100
20277	1/29/2020	1006	2017	2006	1	90
20406	3/10/2020	1007	2017	2005	4	85
20161	12/25/2019	1007	2019	2006	12	90
20229	1/14/2020	1006	2019	2001	9	95
20379	3/3/2020	1006	2020	2001	12	95
20056	11/21/2019	1006	2021	2003	8	100
20080	11/29/2019	1007	2021	2001	11	95
20305	2/10/2020	1007	2021	2005	3	85
20305	2/10/2020	1007	2021	2001	4	95
20305	2/10/2020	1007	2021	2004	6	105
20312	2/12/2020	1006	2021	2003	4	100
20031	11/12/2019	1006	2022	2002	4	120
20223	1/13/2020	1006	2022	2001	1	95
20230	1/15/2020	1006	2022	2002	6	120
20266	1/27/2020	1006	2022	2004	5	105
20452	3/25/2020	1007	2022	2004	4	105
20454	3/25/2020	1006	2022	2003	1	100
20265	1/27/2020	1006	2023	2004	1	105
20404	3/9/2020	1006	2024	2003	1	100
20404	3/9/2020	1006	2024	2006	3	90
20471	3/29/2020	1007	2025	2003	6	100
20513	4/13/2020	1007	2025	2001	10	95
20218	1/12/2020	1007	2026	2004	4	105
20307	2/11/2020	1007	2027	2004	9	105
20307	2/11/2020	1007	2027	2005	9	85
20227	1/14/2020	1006	2028	2001	2	95
20438	3/18/2020	1007	2028	2006	4	90
20375	3/2/2020	1007	2029	2006	11	90
20465	3/28/2020	1006	2029	2004	8	105
20120	12/12/2019	1006	2031	2005	10	85
20496	4/8/2020	1006	2031	2004	5	105
20020	11/7/2019	1006	2032	2003	6	100
20024	11/8/2019	1007	2033	2004	11	105
20063	11/22/2019	1006	2034	2003	4	100
20183	1/1/2020	1006	2034	2002	10	120
20183	1/1/2020	1006	2034	2001	7	95
20256	1/24/2020	1006	2034	2004	5	105
20053	11/20/2019	1006	2035	2004	2	105
20086	11/30/2019	1006	2035	2005	11	85
20202	1/8/2020	1006	2035	2005	7	85
20179	12/30/2019	1006	2036	2004	6	105
20453	3/25/2020	1007	2036	2006	3	90
20495	4/8/2020	1007	2036	2005	4	85
20040	11/14/2019	1007	2037	2003	2	100
20098	12/4/2019	1007	2037	2003	4	100
20283	1/31/2020	1007	2037	2006	4	90
20328	2/17/2020	1007	2037	2006	11	90
20384	3/4/2020	1007	2037	2003	10	100
20013	11/4/2019	1007	2038	2003	2	100
20013	11/4/2019	1007	2038	2002	4	120
20089	12/1/2019	1007	2038	2005	10	85
20055	11/20/2019	1007	2039	2004	11	105
20440	3/19/2020	1007	2039	2001	3	95
20516	4/13/2020	1006	2039	2002	11	120
20280	1/30/2020	1006	2040	2006	4	90
20280	1/30/2020	1006	2040	2001	7	95
20378	3/3/2020	1007	2040	2001	7	95
20403	3/9/2020	1006	2040	2004	4	105
20416	3/13/2020	1006	2040	2003	2	100
20138	12/19/2019	1007	2041	2006	4	90
20142	12/20/2019	1007	2042	2004	9	105
20559	4/25/2020	1007	2042	2004	11	105
20017	11/7/2019	1006	2043	2001	1	95
20043	11/16/2019	1006	2043	2005	12	85
20200	1/7/2020	1007	2043	2003	12	100
20200	1/7/2020	1007	2043	2004	10	105
20457	3/26/2020	1006	2043	2001	10	95
20461	3/27/2020	1007	2043	2004	2	105
20545	4/21/2020	1007	2043	2003	1	100
20407	3/10/2020	1006	2044	2004	9	105
20407	3/10/2020	1006	2044	2006	12	90
20357	2/27/2020	1006	2045	2005	8	85
20535	4/19/2020	1007	2045	2003	6	100
20314	2/13/2020	1007	2046	2004	2	105
20450	3/24/2020	1007	2046	2003	9	100
20368	2/29/2020	1007	2047	2003	11	100
20106	12/7/2019	1006	2048	2004	1	105
20126	12/16/2019	1006	2048	2004	6	105
20126	12/16/2019	1006	2048	2005	9	85
20217	1/12/2020	1007	2048	2003	11	100
20151	12/22/2019	1007	2049	2004	8	105
20518	4/14/2020	1007	2049	2001	8	95
20282	1/31/2020	1006	2050	2002	7	120
20285	2/1/2020	1007	2050	2003	2	100
20424	3/16/2020	1006	2050	2004	10	105
20460	3/27/2020	1006	2050	2003	6	100
20262	1/26/2020	1007	2051	2005	12	85
20023	11/8/2019	1007	2052	2005	2	85
20068	11/24/2019	1007	2052	2004	9	105
20249	1/22/2020	1006	2053	2004	8	105
20539	4/19/2020	1006	2053	2004	10	105
20037	11/13/2019	1007	2054	2004	3	105
20037	11/13/2019	1007	2054	2005	3	85
20001	11/1/2019	1006	2056	2001	10	95
20137	12/18/2019	1006	2056	2003	10	100
20155	12/23/2019	1006	2056	2003	8	100
20439	3/19/2020	1007	2056	2003	1	100
20261	1/25/2020	1006	2057	2003	6	100
20492	4/8/2020	1006	2057	2003	10	100
20093	12/2/2019	1007	2058	2002	1	120
20325	2/15/2020	1006	2058	2003	7	100
20124	12/15/2019	1007	2059	2004	11	105
20059	11/22/2019	1006	2060	2005	6	85
20103	12/5/2019	1006	2060	2003	7	100
20271	1/28/2020	1007	2060	2005	11	85
20491	4/7/2020	1006	2060	2003	3	100
20532	4/17/2020	1007	2060	2003	11	100
20192	1/6/2020	1007	2061	2004	12	105
20242	1/19/2020	1006	2061	2004	3	105
20458	3/26/2020	1007	2061	2003	11	100
20441	3/19/2020	1007	2062	2003	10	100
20503	4/10/2020	1006	2062	2005	6	85
20503	4/10/2020	1006	2062	2004	2	105

Customers:

Customer_ID	Business_Name	Customer_Address	Customer_City	Customer_St	Customer_Zip
2001	Beverage Distributors	3221 SE 14th Street	Des Moines	IA	50320
2002	Deep Ellum Brewing Company	2823 St Louis Street	Dallas	TX	75226
2003	Schatz Distributing Co.	3140 S. 28th Steet	Kansas City	KS	66106
2004	Arkansas Craft Distributors	1515 E. 4th Street	Little Rock	AR	72202
2005	Fleck Sales Co.	11125 High Life Ct SW	Cedar Rapids	IA	52404
2006	Wholesale Liquor	4720 S Broadway St	Wichita	KS	67216
2007	Texas Wholesale	550 North Beach Street	Fort Worth	TX	76111
2008	D&J Beverage Services	4740 G. Street	Omaha	NE	68117
2009	Andrews Distributing Company	2730 Distributing Company	Dallas	TX	75207
2010	Craft Beer Cellar	111 South 9th Street Suite #10	Columbia	MO	65201
2011	United Beverage Co.	1903 Woodland Avenue	Kansas City	MO	64108
2012	Star Distributors	6290 Shelby View Dr.	Memphis	TN	38134
2013	Golden Barrel Inc	1501 I-70 Complex Ct	Columbia	MO	65201
2014	Louisiana Specialty Drinks	1603 S Gayoso St	New Orleans	LA	70125
2015	AS Barboro Inc	5020 Tuggle Rd	Memphis	TN	38118
2016	Republic National Distributing Company	809 Jefferson Hwy	New Orleans	LA	70121
2017	MBA Tulsa Beverage Co	510 W. Skelly Drive	Tulsa	OK	74107
2018	Duff Beer	1319 S. Houston Road	Pasadena	TX	77502
2019	Faust Distributing Company	10040 East Freeway	Houston	TX	77029
2020	Glazer's	6201 Stilwell Street	Kansas City	MO	64120
2021	LDF Sales & Distributing	10718 E. Marshall Street	Tulsa	OK	74116
2022	Wil Fischer Companies	3539 W Farm Rd 142	Springfield	MO	65807
2023	Quality Beverage Company	7029 E. Reading Place	Tulsa	OK	74115
2024	Brown Distributing Inc	8711 Johnny Morris Road	Austin	TX	78724
2025	Boardwalk Distribution	4157 S. 72nd East Avenue	Tulsa	OK	74145
2026	Texas Quality Beverage	13300 Park Vista Blvd	Fort Worth	TX	76177
2027	Iowa Beverage Systems	2115 NE 58th Avenue	Des Moines	IA	50313
2028	Beer Distributors of Oklahoma	6301 Wateford Blvd #105	Oklahoma City	OK	73118
2029	Strathman Sales Co.	4235 SW Burlingame Road	Topeka	KS	66609
2030	Heart of America Beverage	2860 S Austin Ave	Springfield	MO	65807
2031	Evans Distributing	3750 Liberty Drive	Iowa City	IA	52240
2032	Texas Specialty Beverage	2512 Program Drive	Dallas	TX	72220
2033	Belle Point Beverages Inc.	1 Belle Point Place	Fort Smith	AR	72901
2034	Quality Brands of Omaha	13255 Centech Road	Omaha	NE	68138
2035	Wil Fischer Distributing of Kansas	17501 W 98th Street	Lenexa	KS	66219
2036	Premier Midwest Beverage	10367 S. 134th Street	Omaha	NE	68138
2037	Johnson Brothers of Nebraska	9320 J Street	Omaha	NE	68127
2038	Capital Distributing	421 North Portland Avenue	Oklahoma City	OK	73107
2039	Ben E. Keith Company	1805 Record Crossing Road	Dallas	TX	75235
2040	Burford Distributing	925 H Street South	Fort Smith	AR	72901
2041	Standard Beverage Corporation	2416 E 37th St N	Wichita	KS	67219
2042	Arkansas Craft Distributors	1605 W. Shady Grove	Springdale	AR	72764
2043	Silver Eagle	7777 Washington Avenue	Houston	TX	77007
2044	Grand Wholesale Liquor Inc	609 S Grand St.	Amarillo	TX	79104
2045	Premium Brands of NW Arkansas	1032 S. Razorback Road	Fayetteville	AR	72701
2046	Ben E. Keith Company	2300 N Lakeside Dr	Amarillo	TX	79108
2047	City Wholesale Liquor Co	4340 Washington Ave	New Orleans	LA	70125
2048	Reed Beverage Distributor	3333 SE 3rd Ave	Amarillo	TX	79104
2049	Doll Distributing Inc.	3501 23rd Avenue	Council Bluffs	IA	51501
2050	Broadway Beer Distributing Co	2304 North Broadway Avenue	Oklahoma City	OK	73103
2051	Capitol Wright South Austin	3834 Promontory Point Drive	Austin	TX	78744
2052	Sooner Beer Co	605 North Tulsa Avenue	Oklahoma City	OK	73107
2053	Barn Spirits	3002 Chapel Hill Road	Stillwater	OK	74074
2054	American Wholesale Distribution	3300 Pleasant Valley Lane	Arlington	TX	76015
2055	North Kansas City Beverage Co.	203 E. 11th Avenue	North Kansas City	MO	64116
2056	General Distributors	800 E Indianapolis St.	Wichita	KS	67211
2057	BDT Beverage	2115 Spicer Cove #113	Memphis	TN	38134
2058	Standard Beverage Corporation	2300 Lakeview Road	Lawrence	KS	66049
2059	High Life Sales Co.	1900 W. 142nd Street	Leawood	KS	66224
2060	Wholesale Beer Distributors	700 E. 9th Street #1J	Little Rock	AR	72202
2061	Nauser Beverage	6000 Paris Rd	Columbia	MO	65202
2062	De Nux Distributors	701 N. Broadway Street	North Little Rock	AR	72114

Products:

Product_Code	Product_Description	Product_Sale_Price
2001	Pale Ale	95
2002	Imperial IPA	120
2003	IPA	100
2004	Imperial Stout	105
2005	Stout	85
2006	Wheat	90

Required information [T he foiiowing information appiies to the questions dispiayed beiow] NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this la b, you will: Ask the Question: How can we pull in data from a relational database into Tableau in a way that best suits our analysis needs? Master the Data: Connect to Excel File Lab 45 Data.x|sx in Tableau. Software needed - Tableau - Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4J Data: Excel File Lab 45 Data.xlsx. Perform the Analysis: Refer to Lab 45 in the text for instructions and steps for each the of lab parts. Share the Story: You can continue to analyze your data in Tableau in ways that you have learned in other Tableau labs; you just have more flexibility now that you have data from more than one tablejoined in your Tableau connection. D/1 J.x A B C D E F G H K L M American Wholesale 3300 Pleasant Valley 55 2054 Distribution Lane Arlington TX 76015 North Kansas City 56 2055 Beverage Co. 203 E. 11th Avenue North Kansas City MO 64116 General 57 2056 Distributors 800 E Indianapolis St. Wichita KS 67211 2115 Spicer Cove 58 2057 BDT Beverage #113 Memphis TN 38134 Standard Beverage 59 2058 Corporation 2300 Lakeview Road Lawrence KS 66049 60 2059 High Life Sales Co. 1900 W. 142nd Street Leawood KS 66224 Wholesale Beer 61 2060 Distributors 700 E. 9th Street #1J Little Rock AR 72202 62 2061 Nauser Beverage 6000 Paris Rd Columbia MC 65202 De Nux 701 N. Broadway 63 2062 Distributors Street North Little Rock AR 72114 64 65 66 67 68 69 70 71 72 73 74 Sales_Transactions Customers Products + Ready Accessibility: Good to go\fJ6 X v fx A B C D E F G H 1 Sales_Order_ID . Sales_Order_Date Sales_Employee_ID Customer_ID * Product_Code Sales_Order_Quantity_Sold Product_Sale_Price 2 20062 11/22/2019 1007 2001 2004 12 105 3 20168 12/27/2019 1007 2001 2005 CO 85 20383 3/4/2020 1007 2001 2004 5 105 5 20564 4/28/2020 1007 2001 2002 6 120 6 20140 12/20/2019 1006 2002 2001 5 95 7 20310 2/11/2020 1007 2002 2004 2 105 8 20308 2/11/2020 1006 2004 2004 Co 105 9 20308 2/11/2020 1006 2004 2003 11 100 10 20009 11/2/2019 1006 2005 2004 105 11 20233 1/16/2020 1006 2006 2003 100 12 20163 12/25/2019 1006 2007 2003 100 13 20224 1/13/2020 1006 2007 2001 95 14 20199 1/7/2020 1007 2008 2005 85 15 20291 2/4/2020 1007 2008 2005 85 16 20451 3/24/2020 1006 2008 2006 90 17 20451 3/24/2020 1006 2008 2002 120 18 20012 11/4/2019 1006 2009 2005 85 19 20494 4/8/2020 1006 2009 2005 85 20 20494 4/8/2020 1006 2009 2004 105 21 20537 4/19/2020 1007 2009 2004 105 22 20250 1/22/2020 1006 2010 2005 85 23 20251 1/22/2020 1007 2010 2004 11 105 24 20003 11/1/2019 1006 2011 2006 90 25 20241 1/19/2020 1007 2011 2004 105 26 20253 1/22/2020 1007 2011 2005 10 85 27 20005 11/1/2019 1006 2012 2006 90 28 20005 11/1/2019 1006 2012 2001 95 29 20090 12/1/2019 1006 2012 2002 10 120 Sales_Transactions Customers Products + Select destination and press ENTER or choose Paste