Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Fred R. McFadden, Jeffrey Slater, Mary B. Prescott

5th Edition

0805360549, 978-0805360547

More Books

Students also viewed these Databases questions

Question

How does selection differ from recruitment ?

Answered: 1 week ago