Power View Data Visualizations - SQL 2012 Reporting Services
Power View, a feature of SQL Server 2012 Reporting Services, allows you to create reports and dashboards using a number of different data visualizations. With the ability to drag and drop data, and being able to easily switch between visualizations, Power View quickly becomes a powerful BI tool to illustrate, summarize, display and analyze your data.
The following table is a list of data visualizations that come out of the box with Power View:
![]() Click image to enlarge |
TABLE You can easily drag and drop fields onto a table. Columns can be easily reordered and all columns are automatically sortable. You can even include images files. |
![]() Click image to enlarge |
COLUMN CHARTS Easily display data in a vertical bar chart. Bar charts can have multiple series in a clustered column chart or can be stacked (example to the left). |
![]() Click image to enlarge |
LINE CHARTS Line charts are a great way to show values over time. A great way to show trends. Line charts can show one series or multiple series. |
![]() Click image to enlarge |
SCATTER CHART This type of chart is a great way to visualize data from two different measures. Size and position of the circles allow you to quickly analyze the data. |
As you start building reports and dashboards with the different data visualization components, keep in mind that they can all be interactive. As you select a tile, a series on a bar chart, etc. The other elements of the dashboard will filter down to that element. Here are some more examples of dashboards combining all of the previous elements.
One last cool note about all of these data visualizations and Power View; if you have Excel 2013, you can build Power View reports against your data in Excel without the need for SharePoint.
For more information about SQL 2012, Power View Reports, or Power Pivot, please do not hesitate to contact FMT Consultants, LLC.
Written By:
Jeff Fenn, Practice Manager
FMT Consultants, LLC
Posted by: Jakob Bechgaard