Assess the data to determine how the tables are related and create relationships necessary among the three tables.

Create a visualization to identify the number of sales orders each business has placed.

Add a filter to show businesses who haven't recorded any sales with Slainte.

Create an additional table to identify the number of sales orders that contain the separate products, as well as the different states where sales orders took place.

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: The dataset contains information about sales transactions to different customers. There are $132$ unique transactions, but $149$ rows$$this is because some of the transactions had multiple products on them.

This data is similar to the data used in several of the labs in Chapter $3$; however, in Chapter $3,$ the data had already been transformed. In this lab, we will build relationships between the three tables to make the analysis of sales transactions more interesting.

Software needed

Tableau

Screen capture tool $($Windows: Snipping Tool; Mac: Cmd$+$Shift$+4)$

Data: Lab $4-4$ Data.xlsx

Perform the Analysis: Refer to Lab $4-4$ in the text for instructions and steps for each the of lab parts.

Answer the following questions based the details provided.