A pivot table is a table that summarizes data from another table (such as the result set) by applying an operation such as sorting, averaging, and summing to data in the first table, additionally including grouping and filtering the data by selectable columns.

It allows the user to view the data from various viewing points (pivots), hence the name. The user can change the filter/summary/group and the action of the "pivot" by dragging and dropping the desired columns.

The following pivot table below is based on a slightly modified visualization usage query

select distinct queries.name as "query_name", data_sources.name as "datasource_name", visualizations.type as "visualization_type", count(*) from visualizations join queries on visualizations.query_id = queries.id join data_sources on data_sources.id= queries.data_source_id group by 1,2,3 order by 4 desc

and was made for presentation purposes only: