It is also used as a data visualization ... You can use a pivot table to analyze your expenses and revenue by category to determine areas where savings can be made. For example, letâ s say ...