Analyze SharePoint List data using Power Pivot/Power View

In my recent post I have talked about how to install and configure Power Pivot for Excel.
http://gowritech.blogspot.com/2016/04/download-powerpivot-for-excel.html

Now in this post we will learn about how to analyze data using Excel 2013 Power View.

I have created a List called Enrollment and added few records.



1. Open the Excel application
2. Go to POWERPIVOT tab and click on the Manage option.

3. It will launch POWERPIVOT window.


4. Now we have to bring SharePoint list data here to analyze.
5. The following feed URL can be used to connect SharePoint list.
     http://<SharePoint Site>/_vti_bin/ListData.svc

6. In the PowerPivot window, click on the From Data Service -> From OData Data Feed option and type the data feed URL, test the connection.

7. Select the desired list and click on Finish button. Click on Close button once you see Success message.

8.  You can see the data as below.

9. In the ribbon, you can see PivotTable option enabled. Now you can generate various pivot charts. I am not going to talk about how to generate pivot charts because you can find many blogs/videos in online which talks about Pivot Charts in detailed.
10. I have created below chart using Excel 2013 Power View.

11. In my next post I am going to show PowerPivot for SharePoint. It means I will show how to host the chart in SharePoint and automatic chart refresh.

Comments

Post a Comment

Popular posts from this blog

Switch from Classic to Claims Authentication in SharePoint 2010

SharePoint 2013 tutorials, SharePoint 2010 articles, SharePoint interview questions: Switch from Classic to Claims Authentication in Sh... : In this article we will discuss how to switch from Classic Mode Authentication to Claims Authentication. $webApp = Get-SPWebApplication “http://web application URL/” $webApp.UseClaimsAuthentication = 1 $webApp.Update() $webApp.ProvisionGlobally() $webApp.MigrateUsers($True)
Read more

How to query list data using web service

In SharePoint, to query list data we can also use web services provided by SharePoint other than SharePoint API. We can call web services from two places one is JavaScript and another one is .Net client application. Here I will show you both methods. .Net client application To query list data we will use a web service called lists.asmx . 1. Create .net project either windows/console. 2. Add the web reference and the URL looks like http://<servername:portno>/_vti_bin/lists.asmx 3. Give the web reference name as ListsSvc . 3. Add the following code snippet to get list data. ListsSvc. Lists listService = new  ListsSvc. Lists (); // If the current user is having access you can use below code listService.Credentials = CredentialCache .DefaultCredentials; // In case if you want to pass specific user credentials listService.Credentials = new NetworkCredential ( "<username>" , "<password>" , "<domain>" ); string v...
Read more