Lab Insight: We have worked with Tableau and$/$or Power BI throughout this course, but we have always worked with only one sheet or visual at a time. Now, we will create several Tableau sheets and$/$or Power BI visualizations and combine them in one place or page to create a dashboard.

Required:

Create the relationships among the three tables in the data source window.

Change the data type of Supplier St to geographic if necessary.

Create four sheets $($Tableau$)$ or four visualizations $($Power BI$)$:

Sum of Raw Materials Purchased.

Count of Purchase Orders by Raw Material.

Purchases by Day.

Sum of Raw Materials Purchased by State.

For Tableau, create a Dashboard with all four sheets. For Power BI$,$ arrange the visualizations to make it easier to read.

Create dashboard$-$level filters from the following two visualizations:

Sum of Raw Materials Purchased.

Sum of Raw Materials Purchased by State.

Ask the Question: What are the different reports and charts that would be useful to place together for regular analysis?

Master the Data: Apply the same steps as Lab $10-2$ to the Alt Lab $10-2$ Data.xlsx dataset.

Open Tableau or Power BI and Connect to Excel File Alt Lab $10-2$ Data. This dataset contains similar data to the Lab $10-2$ Data, except it shows purchase orders, raw materials, and suppliers.

Software needed

Tableau$/$Power BI

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

Data: Alt Lab $10-2$ Data.xlsx

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