Microsoft PivotViewer

Microsoft PivotViewer is a really cool Silverlight web-based control that provides a visual way to interact with massive amounts of data (download).  It allows you to present thousands of things at once and visualize them in a way that exposes value from the group.  By visualizing thousands of related items at once, users can see trends and patterns that would be hidden when looking at one item at a time.  Which makes it ideal as a business intelligence reporting tool.

To build a PowerViewer app requires Visual Studio 2010, Silverlight Tools, and the PivotViewer SDK.  You will create a Silverlight project in Visual Studio, add a reference to the PowerViewer control, and off you go!  There is also a PivotViewer Extension for Reporting Services.

A great example of seeing this in action is this cool application that allows you to sort thru all the sessions for PASS Summit 2012.  Also check out Netflix Instant Watch collection, Top SharePoint Internet Sites,

More info:

PivotViewer

Lessons in PivotViewer

Quick Steps to displaying data using PivotViewer and Silverlight

Hacking PivotViewer

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQLServerPedia Syndication. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>