According to Microsoft, Pivot's "a new way to browse and arrange massive amounts of images and data online," enabling "spectacular zooms in and out of web databases, and the discovery of [invisible] patterns and links." According to me, it's awesome.
Pivot allows you to create and access data collections made from massive amounts of web information in a visual way. It keeps the same interface independently of the content of the collection, allowing you to dive in the data with ease, zoom out, reorder the collection in any way you want, filter data with one click, and establish relationships between different data sets with ease.
To do this, it uses meta-information within an open XML structure to make those collections—which vary in complexity. Then it allows the user to manipulate the data view using Seadragon, a display technology specifically designed to move around titanic amounts of data and graphics in real time.