But in its current form, the data doesn’t reveal much to you.
This database contains a good amount of information.
Status determines whether the customer is new or existing. Store is the branch name of the super shop. Bill represents the amount of transaction. Weekday is for the corresponding day of the date. Each row represents sales information with date, weekday, customer name, bill amount, store name, etc. This figure shows a portion of the dataset we have used to create the pivot tables in this chapter. A Pivot table can organize, summarize, and analyze data easily and present the out based on requirements.įor clarification, we have a dataset for sales information of a super shop in our hand. We can organize data according to our requirements. Pivot Table is a solution for this complex work. Organizing data in Excel properly is a complex process. But from raw data, it is difficult to get the desired result. 
Usually, we insert raw data in Excel and want to get output based on requirements. Pivot table is an interactive tool of Excel.
0 kommentar(er)
