Computer Science homework help
Computer Science homework help
Basic Charts
The Excel file accompanying this assignment (SuperDrugsPrescriptions) contains fictitious pharmaceutical sales information. Using this data, create a Tableau worksheet to answer each of the following questions:
FILE to use: SuperDrugsPrescriptions.xlsx
1. Exactly recreate the following visualization of the average prescription price over time:
2. Exactly recreate the following visualization of prescription quantity vs. profit. The color of each mark denotes the region, and the shape denotes the drug supplier:
Use the viz you just created to answer the following in a word document:
· What pharmacy and drug supplier represented the highest profit mark on this viz, across all regions?
· What pharmacy and drug supplier represented the highest profit mark on this viz in the East region?