PIVOT TABLES AND MULTI-ATTRIBUTE DECISION MAKING

4 pages minimum (not including Cover and Reference pages). NOTE: You must have 4 pages of written discussion and analysis. This means you should avoid use of tables and charts as “space fillers.”
Provide a brief introduction to/background of the problem.
Using the Pivot Table and Pivot Charts, discuss and analyze the data, noting key highs and lows, trends, etc.
Include charts from your Pivot Table to support your written analysis. (Please do not use charts as “space fillers.” Instead, use them strategically to support your written analysis.)
In a “Recommendations” section, give clear, specific, and meaningful recommendations that Buddy’s Floor Barn should use to improve overall company sales.
Be sure to consider highs, lows, and trends in the data. Which cities are the highest performers? Lowest? Which regions and quarter had the highest sales? Lowest sales? Consider what may be driving the numbers: Poor marketing? Outstanding marketing strategies? Inventory management? Seasonal sales? Other? There are innumerable possibilities.