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

Homework - Case Study ExampleA pivot table washbowl then break crop up the effects to limn 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 gross 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 info from the pivot table. Comparisons could then be made across previous metre 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 choos e. 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 reinvigorated 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 clicksYou 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 study 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 busin ess-related activities tho can