Pivot Table is a tool that allows a user to present data in a form that is convenient for analysis. The view of the pivot table can be quickly changed with just one click, placing data in rows or columns, choosing grouping levels, filtering, and dragging columns from one place to another. One can also apply control tools and add charts in pivot tables for creating visual reports. Examples of such reports are gross profit reports using pivot tables and budget analysis charts (“Overview of PivotTables and PivotCharts,” 2020). A business scenario can be presented as a case where a manager of an online shop needs a brief analytical report for decision making from a table with a number of inputs that contain diverse information. He or she may have data showing information on the customer portfolio of the business, where there is recorded and detailed information for each client. Therefore, to analyze the clientele base portfolio, a pivot table is unloaded from the database into Excel.
The main goal is to identify the most frequent and impactful customers and group them in order to derive a specific target market. The PivotTable will need data on the products each customer purchased, the amount of money spent, and the frequency of monthly purchases. The customer base can be immensely large, especially in online shops, where small convenient purchases can be easily made. The analysis type needs to involve creating a table where each product line is indicated with the corresponding amount of money spent. In other words, the PivotTable must show which products were sold the most to which customers as well as the total sum of revenue. This will help to identify the most sold products alongside the target market. The only drawback of pivot tables is the lack of automatic updating or recalculation when changing data in the source list.