Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger ( and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

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:


Lessons in PivotViewer

Quick Steps to displaying data using PivotViewer and Silverlight

Hacking PivotViewer


Leave a comment on the original post [, opens in a new window]

Loading comments...