Open a new workbook in Power BI Desktop and connect to data:

From the Home tab in the ribbon, click Get Data $>$ Excel.

Navigate to your Lab $3-1$ Slainte Dataset.xlsx file and click Open.

In the Navigator window, check the boxes next to Employee$\_$Listing and Suppliers and click Transform Data.

Join the employee and suppliers tables with a fuzzy match to identify possible related parties:

Fuzzy matching supports only text columns. We will be matching the Supplier$\_$Address, Supplier$\_$Zip,Employee$\_$Street$\_$Address, and Employee$\_$Zipcolumns, so ensure they are all data type text. If they are not, adjust the data types. If prompted to Replace current or Add a new step, select Replace current.

Click the Suppliers query then go to the Home tab in the ribbon and click Merge Queries.

In the Merge window:

Choose Employee$\_$Listing from the drop$-$down menu above the bottom table.

From the Join Kind drop$-$down menu, choose Inner $($only matching rows$).$

Check the box next to Use fuzzy matching to perform the merge.

Click the arrow next to Fuzzy matching options and set the similarity threshold to $0\mathrm{.}5.$

Now, hold the Ctrl key and select the Supplier$\_$Address and Supplier$\_$Zip columns in the Suppliers table in the preview at the top of the screen.

Finally, hold the Ctrl key and select the Employee$\_$Street$\_$Address and Employee$\_$Zip columns in the Employee$\_$Listing table in the preview at the bottom of the screen.

Click OK to merge the tables.

In the Power Query Editor, scroll to the right until you find Employee$\_$Listing and click the expand $($two arrows$)$ button to the right of the column header.

Click OK to add all of the employee columns.

From the Home tab in the ribbon, click Choose Columns.

Uncheck $($Select all columns$)$ and check the following attributes and click OK:

Supplier$\_$Company$\_$Name

Supplier$\_$Address

Supplier$\_$Zip

Employee$\_$First$\_$Name

Employee$\_$Last$\_$Name

Employee$\_$Street$\_$Address

Employee$\_$Zip

cameraTake a screenshot $($label it $3-1$MA$).$

You may notice that you have too many matches. Now adjust your fuzzy match to show fewer, more likely matches:

In the Query Steps panel on the right, click the gear icon next to the Merged Queries step to open the Merge panel with fuzzy match options.

Click the arrow next to Fuzzy matching options and change the Similarity threshold value to $0\mathrm{.}7.$

Click OK to return to Power Query Editor.

In the Query Steps panel on the right, click the last step to expand and remove the other columns: Removed Other Columns.

cameraTake a screenshot $($label it $3-1$MB$).$

Answer the lab questions, then close Power Query and Power BI$.$ Save your Power BI workbook as $3-1$ Slainte Fuzzy.pbix.