Home » SharePoint 2013 » Building Excel 2013 Data Visualizations with PowerView and Adding Them to SharePoint 2013

Building Excel 2013 Data Visualizations with PowerView and Adding Them to SharePoint 2013

Back on February 25, 2013, in a post to this blog titled Changes in Excel Services for SharePoint with SharePoint 2013 we published word on changes in the PowerPivot feature of Excel. We quoted from an article titled “What’s New in PowerPivot in Excel 2013,” published by Microsoft on the topic of a more robust data model for Excel 2013, which incorporates much of the functionality of PowerPivot. We went onto present our opinion. Many businesses with a commitment to PowerPivot for Excel will want to read up on these changes before deciding whether to migrate from Excel 2010 to 2013 with SharePoint 2013.

Asif Rehmani, SharePoint MVP and MCT has published a video tutorial, Visualize Your Excel Data in SharePoint Using PowerView, which demonstrates how to continue to produce highly informative graphs with Excel 2013 and then add them to SharePoint Server 2013.

As Asif notes, “PowerView is a functionality that ships with Excel 2013 and it can be published directly to SharePoint server to provide all users with any skill level an interactive, data exploration, visualization and presentation experience.” The remainder of this tutorial is a presentation of how PowerView functionality works in Excel 2013 and data visualizations can be transferred to SharePoint Server 2013.

A button is provided in the ribbon for Excel 2013 for PowerView. A user can select columns and rows of data within an Excel 2013 spreadsheet. By simply clicking on the PowerView button Excel opens a new tab, complete with the copied data and a set of new functionality. Grouped within a tab of the same Excel 2013 ribbon titled “Switch Visualization” the user is offered a series of options, including “Bar Chart”, “Column Chart”, “Other Chart” and even a “Map”. Asif Rehmani produces a couple of attractive looking charts from the sample data included in this tutorial.

Use the “Save As” feature to add the Excel data visualization to SharePoint 2013.

Ira Michael Blonder

© Rehmani Consulting, Inc. & Ira Michael Blonder, 2013 All Rights Reserved