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