Power View - Creating Matrix Table and Line Graph - An SSRS ADD-INS...

Power View - Creating Matrix Table and Line Graph - An SSRS ADD-INS

              

Power View reports are built on data models. Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is tightly integrated with SharePoint Server 2010 so creating, opening, and saving Power View reports all take place in SharePoint Server 2010.

Open an Excel sheet and add the data into it. [Attached the Excel sheet along with Post]

 

Click on the Insert table after selecting the Data From - "FirstName" of Header to Last Column "Skilled Manual" and Click on he Power View Report Menu as Highlighted... 

On the Click of the Power View Reports, it will launch the Power View and install Silver Lights, as shown below

 

 Power View will appear as shown below

Click on the Design table to create the Tablix, Matrix, Charts and Map's

Click Matrix Menu, a rearrange the Fields present in the Right hand side menu's as shown below

Similarly, based on these data we can create the Line Graph as shown below from the Menu - Other Charts. Click on the Other Charts menu - Line Chart.

 

Once done, the Line graph will be shown as below.

 

 

Sample Excel sheet for Workout...

https://docs.google.com/file/d/0B4Bf0PBXKfpIT3Zjd05aelRGalU/edit?usp=sharing

 

Regards

Daniel J

Dataware and Data Mining Architect...