Question
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.
F. 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 TrnnmnmalnrStep 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