Explain Pivot tables

Data Science, AI and ML
,
#1

Pivot tables in excel

#2

A pivot table is a [table] of statistics that summarizes the data of a more extensive table (such as from a [database], [spreadsheet], or [business intelligence program]. This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.

Pivot tables are a technique in [data processing]. They arrange and rearrange (or “pivot”) statistics in order to draw attention to useful information.[for more details please go through this link]
(https://www.excel-easy.com/data-analysis/pivot-tables.html)

2 Likes
#3

and if you are solving the same problem with excel functions and pivot table you will get to know it is easier to solve than the use of functions. lt’s only drag and drop of dimensions and measures.

1 Like
#4

very true

#5

A Pivot Table is used to summarize, sort, reorganize, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.

#6

It is summarised sheet of long data arranged in tabular form.

For eg- you deal in multiple brands in multiple cities and multiple countries throughout the year.

It can provide you with the data you sold for a particular brand month-wise, city wise or country wise, however you may like.

It is one of the functions of a pivot table. It can do a lot more. You may add Slicer in it. You may prepare a sales report, other MIS reports etc.