DotNetCurry Logo

Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 3

Posted by: Pravinkumar Dabade , on 2/19/2011, in Category SharePoint
Views: 49840
Abstract: In the first part of this series Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS we saw how to create a SharePoint Site and Scorecard with KPIs. In the second part, we saw how to create a Chart Report and a Grid Report. In this final part of this article series, we are going to see how to create a Dashboard and deploy it to SharePoint Site.

In the first part of the series Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS we saw how to create a SharePoint Site and Scorecard with KPIs. In the second part of this series, we saw how to create a Chart Report and a Grid Report. If you have not read Part I and II, I strongly commend you do so before continuing with this article.

 

In this final part, we are going to see how to create a Dashboard and deploy it to SharePoint Site.

Step 1: Right click PerformancePoint Content > New > Dashboard which will use a Dashboard template ‘Header, 2 Columns’ as shown below:

Dashboard Page Template

Rename your Dashboard as ‘PDW Demo Dashboard’. Your Dashboard will look similar to the one shown below :

Sharepoint Dashboard

Step 2: Now let’s modify the height of our Header section. For this right click the header section and go to “Zone Settings” from the context menu. Click on the Size Tab and change its height from 10 to 50, as shown below:

Zone Settings

Now let’s add our Chart Report that we created in our previous article to our Header Section, Scorecard to the Left Column of our dashboard and Grid Report to the Right column of our Dashboard from the ‘Details’ window as shown below –

PDW Demo Dashboard

Step 3: That’s all. Your Dashboard is ready. To preview your Dashboard, right click and click on Deploy as shown below :

Deploy to SharePoint

Once your Dashboard is deployed successfully, you should see it on your SharePoint Site as shown below:

Sharepoint Dashboard Example

That’s it! You have successfully created a Dashboard using Sharepoint PerformancePoint and Analysis Services (SSAS) and deployed it a SharePoint Site.

Conclusion

In this article series, we have seen how to create a Dashboard using PerformancePoint Services Dashboard Designer Tool and deploy it to SharePoint Site. For this demonstration we have used Microsoft Multidimensional Data Source that is SQL Server Analysis Services Database.

Was this article worth reading? Share it with fellow developers too. Thanks!
Share on LinkedIn
Share on Google+
Further Reading - Articles You May Like!
Author
Pravinkumar, works as a freelance trainer and consultant on Microsoft Technologies. He is having over 10 years of experience in IT and is also a Microsoft Certified Trainer(MCT). He has conducted various corporate trainings on all versions of .NET Technologies including .NET, SharePoint Server, Microsoft SQL Server, Silverlight, ASP.NET, Microsoft PerformancePoint Server 2007 (Monitoring). He is passionate about learning new technologies from Microsoft. You can contact Pravinkumar at dabade[dot]pravinkumar [attherate] gmail[dot]com


Page copy protected against web site content infringement 	by Copyscape




Feedback - Leave us some adulation, criticism and everything in between!
Comment posted by Arnis on Thursday, February 24, 2011 12:52 AM
Thanks for the stepbystep approach. Can the same be done in SP 2007 too?
Comment posted by Pravinkumar on Thursday, April 21, 2011 12:53 AM
Yes we can do the same in MOSS 2007 as well. Provided you need to configure MOPPS 2007 explicitly.
Comment posted by Gladys Sannada on Thursday, May 12, 2011 4:33 AM
Very good,step by step article with screen shots. Was very helpful in understanding the overal apporach of using performacepoint
Comment posted by Ahmed on Tuesday, June 7, 2011 7:02 AM
Could you please tell me how to make dashboard using asp.net and make it connect sharepoint
Comment posted by Pravinkumar on Wednesday, June 8, 2011 8:07 AM
Hi Ahmed,

If you are using SharePoint 2010, why do you want to design the Dashboard using ASP.NET?
Comment posted by Bizzy on Friday, November 18, 2011 2:29 PM
cool explanation
Comment posted by Ashu on Tuesday, February 19, 2013 8:34 PM
Thank you for nice article.It is very helpful to understand fora beginner like me.Keep posting.