Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Utilize the Store Data.xlsx file to answer the following questions. It is recommended that you utilize Tableau Prep Builder to join the tables in the
Utilize the Store Data.xlsx file to answer the following questions. It is recommended that you utilize Tableau Prep Builder to join the tables in the excel file together, then process it using Tableau. Alternatively, you may use PowerBL or any other tool you wish. Please provide a screenshot of the visualization(s) that you used to answer each question or alternatively, if you utilized a formula or a script, please share that information as well. You may also share more details about how you processed the data to get your answer (for partial credit). 1. Which product ID has the highest returns? (10) California has the highest count of returns which is 338 2. Returns by state: Which state has the highest returns? (10) a. California has the highest return for 127. b. What is the total dollar amount of sales revenue returned for that region? *assume that for returns, the entire revenue for the sales transaction is returned (10) 3. Profit by region: Which region has the highest profit? (10) How much profit did it
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started