Homework Case Study Example | Topics and Well Written Essays - 500 words

Homework - Case Study Example A pivot table can then break down the numbers to show the amount sold by each employee. Then, it could even go further and break those numbers down by cities. So you would know which employee made the most number of sales, in which city the most number of sales were made, and which singular employee made the most number of sales in just one city. Data from the pivot table could then be used to allocate funds and estimate future sales based on the data from the pivot table. Comparisons could then be made across previous time periods and a comparison could be made to show the trends of certain employees or locations. Changes could then be made based off this data by either firing an employee or stop selling products in a city that is underperforming. 1- Because they are amazing tools used to quickly explore and manipulate data from a spreadsheet. A pivot table uses existing data and allows users to sort that data by any field they choose. The user can select which fields they would like to be displayed and whether it should be a column or a row header. That table can then be manipulated by integrating formulas into the table to quickly get inventory counts, cost percentages, sales commissions, regional growth, or anything else you need to determine. Using pivot tables to explore crosstab data is much easier than searching through spreadsheets, pulling out the pertinent data, then creating a new spreadsheet with the data necessary. Pivot tables make analyzing large quantities of data a user-friendly experience. You can actually create a pivot table in as few as 10 mouse clicks! You are correct in that using a pivot table can significantly reduce the time it takes to analyze data. All it needs is for just a few spaces to be filled in and the pivot table will display all the information you need in a nice and easy format. You might want to mention though that the use of pivot tables is not simply reduced to business-related activities but can