Purchase_Order_ID	Purchase_Order_Date	Purchase_Employee_ID	Supplier_ID	Raw_Materials_Code	Quantity_Purchased	Raw_Material_Purchase_Price
20500	11/1/2024	1009	3	1001	3	19.99
20501	11/5/2024	1009	2	1003	10	29
20502	11/10/2024	1009	2	1003	6	29
20503	11/13/2024	1008	1	1002	12	44.99
20504	11/16/2024	1009	1	1001	4	19.99
20505	11/19/2024	1008	2	1001	12	19.99
20506	11/23/2024	1009	1	1001	5	19.99
20506	11/23/2024	1009	1	1003	1	29
20507	11/26/2024	1009	1	1001	1	19.99
20508	11/29/2024	1009	3	1001	4	19.99
20509	12/4/2024	1009	1	1001	12	19.99
20510	12/9/2024	1009	2	1001	11	19.99
20511	12/12/2024	1008	3	1003	6	29
20512	12/16/2024	1009	3	1001	7	19.99
20513	12/19/2024	1008	2	1002	11	44.99
20514	12/24/2024	1009	3	1002	11	44.99
20515	12/28/2024	1009	1	1002	4	44.99
20516	1/2/2025	1008	1	1003	11	29
20517	1/5/2025	1009	2	1001	10	19.99
20518	1/9/2025	1009	1	1003	12	29
20519	1/14/2025	1008	2	1001	1	19.99
20520	1/18/2025	1008	1	1003	12	29
20521	1/23/2025	1008	3	1001	6	19.99
20522	1/26/2025	1009	3	1002	10	44.99
20523	1/31/2025	1009	1	1001	8	19.99
20524	2/4/2025	1009	2	1001	1	19.99
20525	2/8/2025	1008	3	1002	5	44.99
20525	2/8/2025	1009	3	1002	2	44.99
20525	2/8/2025	1008	3	1003	6	29
20526	2/13/2025	1009	2	1001	11	19.99
20527	2/16/2025	1009	2	1001	12	19.99
20527	2/16/2025	1009	2	1003	6	29
20528	2/21/2025	1008	1	1001	3	19.99
20529	2/24/2025	1008	3	1003	10	29
20530	2/28/2025	1008	3	1001	2	19.99
20530	2/28/2025	1009	3	1003	2	29
20531	3/4/2025	1008	3	1003	7	29
20532	3/7/2025	1008	1	1002	2	44.99
20533	3/12/2025	1009	1	1002	12	44.99
20534	3/15/2025	1008	2	1002	5	44.99
20535	3/19/2025	1009	3	1002	7	44.99
20536	3/23/2025	1009	2	1001	12	19.99
20537	3/27/2025	1008	2	1003	6	29
20538	3/31/2025	1009	1	1002	5	44.99
20539	4/4/2025	1008	3	1003	6	29
20540	4/8/2025	1008	2	1001	3	19.99
20541	4/11/2025	1009	3	1003	10	29
20541	4/11/2025	1008	3	1003	3	29
20542	4/14/2025	1009	1	1003	6	29
20542	4/14/2025	1009	1	1002	5	44.99
20543	4/18/2025	1009	1	1002	1	44.99
20544	4/21/2025	1008	2	1002	4	44.99

Supplier_ID	Supplier_Company_name	Supplier_Address	Supplier_City	Supplier_St	Supplier_Zip	Supplier_Phone	Notes
1	Northern Brewery Homebrew Supply	6021 Lyndale Ave S	Minneapolis	MN	55419	612-843-4444	Bulk Malt Supplier
2	Hops Direct, LLC	686 Green Valley Road	Mabton	WA	98935	509-837-3616	Bulk Hops Supplier
3	The Home Brewery	455 E. Township St.	Fayetteville	AR	72703	479-587-1440	Small batch and Speciality Ingredient Supplier
4	The Payroll Company	408 N. Walton Blvd	Bentonville	AR	72712	1-866-899-8439	Payroll
5	City of Fayetteville - Water	113 West Mountain Street	Fayetteville	AR	72701	479-521-1258	Water
6	Southwestern Gas	P.O. Box 98890	Las Vegas	NV		877-860-6020	Electric and Gas
7	Bob's Repair	3541 Horse Meadow Drive	Fayetteville	AR	72703	479-345-2345	Repairs
8	Farmer's Insurance	1943 College Avenue	Fayetteville	AR	72701	479-236-0013	Insurance
9	Lindsey Management Co.	1200 East Joyce Blvd.	Fayetteville	AR	72703	479-521-6686	Rent

Raw_Materials_Code	Raw_Materials_Description	Raw_Materials_Price
1001	Malt - Barley	$19.99
1002	Malt - Wheat	$44.99
1003	Hops	$29.00

Can someone help with this please?

Required: 1. Create the relationships among the three tables in the data source window. 2. Change the data type of Supplier St to geographic if necessary. 3. Create four sheets (Tableau) or four visualizations (Power BI): a. Sum of Raw Materials Purchased. b. Count of Purchase Orders by Raw Material. c. Purchases by Day. d. Sum of Raw Materials Purchased by State. 4. For Tableau, create a Dashboard with all four sheets. For Power BI, arrange the visualizations to make it easier to read. 5. Create dashboard-level filters from the following two visualizations: a. Sum of Raw Materials Purchased. b. Sum of Raw Materials Purchased by State. \begin{tabular}{|l|l|} \hline \multicolumn{1}{|c|}{ Question } & \multicolumn{1}{|c|}{ Answer } \\ \hline 1. Which raw material is purchased most frequently from suppliers in Arkansas (AR)? & \\ \hline 2. On which day was the highest quantity of units of Malt - Barley purchased from suppliers in Minnesota (MN)? & \\ \hline 3. On which day was the highest quantity of units of Malt - Barley purchased from suppliers in Arkansas (AR)? & \\ \hline 4. From which state are the most raw materials purchased, overall? & \\ \hline 5. From which state (of the states that purchases were made) are the least raw materials purchased, overall? & \\ \hline \end{tabular}