Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a 750-word paper that explains this data to your supervisor. You will need to analyze all sheets in this dashboard. This write-up should explain

Write a 750-word paper that explains this data to your supervisor. You will need to analyze all sheets in this dashboard. This write-up should explain the following:

A. Go to the Sales Chart sheet, and see what was the highest selling Category (Furniture, Office Supplies, or Technology) of products in 2015, 2016, & 2017?

B. Find and list every Category, Region, and Year that suffered a loss. The numbers with a negative symbol (-) in front of them represent losses.

C. On the Superstore Sales sheet, list the nine sales numbers from all of the categories. Briefly describe what these numbers represent.

D. Go to the Bubble Chart sheet and select the three largest bubbles. For each bubble, find the Sales and Profit numbers. Find the percentage of the profit by (Profit/Sales) and list.

E. On the US Map sheet, name the five highest states and their sales amounts.

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribedF. Go to the Sub-Category Sales sheet, find the three lowest sub-categories and their sales numbers. These three sub-categories will be looked at for removal and replacement of products. G. On the Treemap Sales sheet find the Technology numbers in Consumer, and Corporate for 2015-2018. H. Write 250 words about the value of a data dashboard in an organization.

Trnnmnmalnr cihratornrycaloc A. Orders+ (Superstore Data (1)) Connections Add Superstore Data(1) Microsoft Excel Sheets Use Data Interpreter Data Interpreter might be able to clean your Microsoft Excel workbook. Orders People Returns E Orders People Returns New Union How do relationships differ from joins? Learn more New Table Extension Trnnmnmalnr Trnnmnmalnr cihratornrycaloc A. Orders+ (Superstore Data (1)) Connections Add Superstore Data(1) Microsoft Excel Sheets Use Data Interpreter Data Interpreter might be able to clean your Microsoft Excel workbook. Orders People Returns E Orders People Returns New Union How do relationships differ from joins? Learn more New Table Extension Trnnmnmalnr

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

Strategic Marketing

Authors: Nigel Piercy and David Cravens

10th edition

78028906, 978-0078028908

More Books

Students also viewed these General Management questions