Question

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.

Answer 1

Answer)

Here,for Example Brand X a manufacturer of tyres observes that their sales are going down year by year.Hence,it want to analyse the problem on Pivot table and try to make the decision.Here,pivot may not solve the issue alone but helps in making data driven decision support to the users by increasing the overall visibility.

1)Here,it helps in summarizing the data in to compact size and more readable format.

2)It helps in the trends, relationship with past years data that hows sales are coming down & going up and also seeing the coming opportunities & threats if any anticipated.

3)Rather than using endless filtering tools it helps in analysing the sales details in fat and efficient way.

4)It helps in asking the right questions with available data like what the customers want,what the competitors offering, pricing policies that are to be followed and much more.

5)Carrying the analysis to Management and concerned departments for making the right decision.