BIS 155 retail chain keeps daily data

$4.50

BIS 155 retail chain keeps daily data 
(TCO 3) A retail chain keeps daily data with summaries of the dollar …

Description

BIS 155 retail chain keeps daily data

BIS 155 retail chain keeps daily data

A+ Final Exam

(TCO 3) A retail chain keeps daily data with summaries of the dollar amounts of sales for each of 151 different products sold at 23 retail stores. The daily data is tracked by product and by store. At the end of the day each store sends its data to the sales manager at the corporate office. The data is sent in an Excel spreadsheet. Describe a data consolidation strategy and at least two different types of visualization techniques the sales manager can use to analyze the data received from all stores. Be sure to include formulas that are to be used in the Excel spreadsheet. (Points : 40)

Data consolidation strategy is a new concept that a majority of mangers are trying to adopt in order to keep track of their…