I. Upload the attached Excel file to your Tableau Desktop:

PropertyOrderProduct.xlsx

II$.$ Combine all worksheets into a single data set using Tableau Relationships. DO NOT USE JOINS as they do in LinkedIn Learning. Here is a video about Joins vs Relationships

III. Answer the following questions. Assume that the data is correct and without measurement error.

What type of statistical variation does the combined data set contain: is it a panel, cross$-$sectional or time series dataset? Which field$($s$)$ uniquely identify a row?

Create a simple plot with quantity on the y$-$axis or rows and "order date" on the x$-$axis or columns. Do quantities vary over time? If so$,$ then do they vary within a given product over time? hint: filter the data.

Post a photo of the graph that you created. Can you find any rhyme or reason that can explain this variation or lack thereof?

Repeat the exercise in $(2)$ except now look at prices over time, within product. Remember to post the graph you created.

Do you believe this firm practices revenue optimization? Support your answer with observations from the data set.

Is this data set suitable for studying how quantity demanded is influenced by price changes? Support your answer with observations from the data set.