Data Pivot is a process of rotating the view of data. In databases where there is high level volume of data, it is often very difficult to get a view of a particular data or report. A pivot table helps overcome this problem by displaying the data contained in the database by means of automated calculations which are defined in a separate column side by side with data column of the requested data view.