How to create a dashboard using excel service

Hi All,

I am newbie for sharepoint and I have taken over an already created dashboard which has the link like "SitePages/XYZ.aspx". It has an excel powerpivot reports in it. 

I want to know how to create this dashboard. Is it by writing asp.net c# code to integrate the excel sheet or should I use any tools. If by either one, please help me with the steps.

Hope I am clear. Thanks in advance.


July 30th, 2015 2:34pm

Hi,

The easiest way I would recommended is that, you can use the OOTB Excel Web Access Web Part which enables you display an Excel workbook on a dashboard or other site page, all you need to do is designing all the customization in the Excel Workbook.

The documentation below about Display a workbook in an Excel Web Access Web Part would be helpful:

https://support.office.com/en-us/article/Display-a-workbook-in-an-Excel-Web-Access-Web-Part-2c0925c1-f383-4179-88fe-febd1f912894

As an alternative, you can use Performance Point Service to create a dashboard with the data from Excel Workbook.

About how to Create an Excel Services data connection by using PerformancePoint Services:

https://technet.microsoft.com/en-us/library/Ff191193.aspx

More information about how to configure and use Performance Service for your reference:

https://technet.microsoft.com/en-us/library/Ee748644.aspx

http://www.codeproject.com/Articles/783405/PerformancePoint-Services-in-SharePoint

https://technet.microsoft.com/en-us/library/JJ571736.aspx

Thanks 

Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 3:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics