In this article, we will give a brief overview of Power View (code name “Crescent”) – what it is, the architecture and how it complements the Microsoft Business Intelligence tools stack. We also provide a few examples of reports. Power View is a new data visualization tool which allows users to interact with data. It is a web browser-based end user Microsoft Business Intelligence tool.
Power View is a completely Silverlight-based application launched from SharePoint 2010, and therefore does not require any client side installation. The core objective of Power View is to present the modeled data in a fun and meaningful way, using highly interactive visualizations, animations, smart querying and rich Storyboarding presentation capabilities (a feature that allows you to embed charts and graphs in PowerPoint and manipulate the live data during a presentation). You can forget all about complex concepts like dimensions, measures groups, etc. and focus just on the data, with simple tables, columns and measures. In a nutshell, “Let the data tell you the story of the business.”
To use Power View, you need to have SharePoint 2010 installed and configured, and SQL Server 2012 Reporting Services configured in SharePoint integrated mode. SharePoint 2010 SP1 is also recommended, as are some cumulative updates which add extra compatibility with Apple’s iPads and iPhones. Power View requires Silverlight 4. Here is an overview of the architecture underlying Power View
Power View is not intended to replace any of the SQL Server Reporting Services tools like the Report Designer in BIDS (Business Intelligence Development Studio) for Visual Studio, Report Builder or Performance Point Services in SharePoint. These tools will continue to exist, with their respective enhancements, in SQL Server 2012. Report Designer and Report Builder are used to create powerful, data-rich static reports by power users and IT pros, for end users. Performance Point Services is used for creating Key Performance Indicators (KPIs) and Scorecards. Power View, on the other hand, is aimed at Presentation Ready for Ad-hoc Reporting, or Self-Service BI, optimized for design and online screen consumption and interactivity by End users, for End users. It is targeted at everyone, to enable them to create compelling, interactive and rich data visualizations out of the box based on PowerPivot workbooks and the brand new Business Intelligence Semantic Model (BISM). Because Power View uses only DAX language as the query language, it can only connect to BISM tabular models, either in SQL Server Analysis Services or PowerPivot Workbooks, which have a BISM Tabular model behind the scenes, as part of the new release of SQL Server 2012 (CTP3 and RC0). Microsoft understands that there is a need to remove this restriction in order to allow the existing multidimensional models to take advantage of Power View, so we hope that, in future releases of SQL Server, Power View can be used against BISM Multidimensional models.
You can connect to a PowerPivot model in SharePoint (which is a PowerPivot Excel Workbook published to SharePoint) or connect to a BISM Tabular model in Analysis Services (which is a Tabular data model published to Analysis Services server). You can also get data directly from the SQL Server, using the BISM Tabular pass-through mode named Direct Query.
With the introduction of Power View, the SharePoint Integration for Reporting Services is redefined. Reporting Services will now be configured and monitored like other SharePoint shared applications, enabling organizations to leverage existing SharePoint skills. Data security, permissions, properties, table names, column names, and so on, are defined at the BISM Model inside the Analysis Services solution or PowerPivot workbook. Power View focuses only on data presentation and interaction.
Operating Systems and Browsers that support Power View
You can see these main areas on the screen:
- Ribbon (giving you the Office 2010 user experience)
- Canvas (the data presentation area)
- Field List (the data selection area. The top half is from the underlying data model and the bottom highlights the selections made for a visualization)
Top features of Power View are:
Presentation-Ready – No previews or design modes. No ‘design time’ and ‘run time’. You are working with real data. You can browse your data and present it any time
Visual Design Experience – The canvas is where the user can play with the data. You can switch between different visualizations by a simple click on the respective visualization. For example, starting from a table you can switch to cards, tiles, bar charts or bubble charts to find the visualization that best illustrates your point.
Keep the table selected, and click on the column Visualization inside the Design Tab. The table will be converted to a column chart as shown below:
Click on the Table visualization inside the Design tab to go back to the table representation of data. Let’s add another column by clicking on the “Region Name” column from the Region table and select the Line Visualization. The data is now represented as a Line graph:
Let’s go back to the table, remove “Region Name” from the graph by unchecking the “Region Name” column from the Region table. Select Scatter Visualization from the Design tab. Add two more measures for the Y axis and the size of the bubble. Add the “Sum of Revenue” and “number of Products” columns. Expand the Date table and add the Year column, which will be automatically taken as the play axis of the scatter chart.
- Multiple Views in a single report – this feature allows the users to preview multiple views of a report.
- Export to Microsoft PowerPoint – this feature allows the users a fully interactive report to be run from within PowerPoint.
- PowerPivot Gallery Preview Images – this feature produces preview images in the PowerPivot Gallery, just like Excel workbooks.
- Multiple View Navigation – this feature allows the users to navigate through multiple report views and select the one they want to display.
- Sorting – this feature allows sorting on all data regions, and both single and multiple charts.
- More Chart Features – more functionality, such as more than 20 series, multiple measures, color (series) in scatter and bubble charts and legend highlighting is added to the charts.
- Chart Highlighting Enhancements – this feature has some major additions to the highlighting feature with charts.
- Number formatting for Tables and Matrix – this feature supports number formatting on both tables and matrix.
- Slicers Cross Filters Other Slicers – with multiple slicers in a view, if you select one slicer, the values on other slicers also get filtered.
- Per Data Region Filtering – this feature allows filtering the entire report view or individual data regions in a view.
- Measure Filters and Filter Restatement – this feature allows support for measure filters and will also restate the users selected filters, even when the specific filter is in a collapsed state.
- Search in filters – this feature allows you the search through the filters instead of just browsing through a long list.
- Drag your data to the Canvas – this feature allows the users to drag fields directly to the canvas from the model explorer.
- Print It – this feature allows the users the print the current (or selected) view.
- Support for DirectQuery Mode – this feature allows connecting to tabular models in direct query mode.
- Database Image Support – this feature supports database images stored directly in the model.
- Show Items with No Data – this feature supports the ability to display items with no data.
- Measures as Non-Measures – this feature supports the ability to treat measures as non-measures (i.e. as categories) by not summarizing on those fields.
- All New Canvas Look – the reporting canvas has an overall enhanced look.
Here you can find some Power View RC0 screenshots:
If you want to see all of the abovementioned features in action, you can watch the updated demo of SQL Server 2012 RC0 Power View released by Microsoft BI team. ConclusionThisarticle has only touched on some of the features of Power View, in order to give you a brief overview and show you how easy it is to create a report that is highly interactive and provides the ability to explore and visualize your data. Imagine how valuable it will be to track price changes, revenue growth, stock market fluctuations and much more.
- AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups - November 28, 2013
- Custom Master Pages not available from Performance Point Dashboard Designer - June 19, 2012
- An introduction to Power View (code name “Crescent”) in SQL Server 2012 (code name “Denali”) - May 2, 2012