Analysis via Pivot Tables” Please respond to the following:
- Describe a situation where pivot tables could be used to aid a business decision. Specify the question / problem management needs to resolve, and explain the manner in which the pivot table results will provide a solution. You may use one (1) of the homework exercises as a basis for your response, or a company with which you are familiar.
- Be sure to write an original situation. Make sure you understand the function of a pivot table, and then describe a use of it and the way it would aid in a business decision.