Project Server 2010 Reporting with Excel Services & Creating Dashboards white papers

I’m thrilled to announce the release of the following two white papers which provide step by step guidance on surfacing key Project Portfolio Management data into insightful reports and dashboards:

• Microsoft Project Server 2010 Reporting with Excel Services written by Jean-Francois LeSaux and Steven Haden from Microsoft Consulting Services.
• Creating Dashboards for Microsoft Project Server 2010 written Blaise Novakovic, Jean-Francois LeSaux, Steven Haden, Microsoft Consulting Services

For additional information on Microsoft Project Server 2010 business intelligence & reporting please check out Business Intelligence in Project Server 2010.

Microsoft Project Server 2010 Reporting with Excel Services, 71 pages

Overview

Table Of Content

The purpose of this document is to provide enough detail to be able to create and deploy reports which will support the deployment of Microsoft Enterprise Project Management (EPM) Solution. Microsoft EPM Solution relies on Microsoft SharePoint Server 2010, Microsoft SQL Server 2008 or 2008 R2, Microsoft Project Server 2010 and Microsoft Project Professional 2010. Although each individual component of the solution is well documented on TechNet and MSDN (for the Business Intelligence), little documentation exists, as of today, which describes a step-by-step approach to building reports specific to Project Server 2010 data with Excel and Excel Services. This document is not intended to provide an in-depth description of all the features available in Excel 2007 or 2010 and Excel Services 2010 when building a report but rather provide the building blocks required to ‘be up and running’ quickly.

Foreword Introduction Overview Build Your First Excel Report against OLAP Data in 10 Minutes Authoring Reports against Relational Data Use Excel PowerPivot Migrating Reports between Environments Troubleshooting Business Intelligence Features References List of Figures

Creating Dashboards for Microsoft Project Server 2010, 115 pages

Overview

Table Of Content

The purpose of this document is to provide sufficient detail to fully design and implement Business Intelligence Dashboards that will support an Enterprise Project Management Solution (EPM), which consists primarily of SharePoint 2010 and Project Server 2010. It also includes detailed steps on how to replicate reports and dashboards included in the Project Server 2010 demonstration and evaluation pack available on the Microsoft Download Center. The purpose is to help you easily create reports and dashboards for your environment with similar characteristics. The target audience for this document is the business owner and report developers who are looking for a quick way to develop Dashboards that will support an Enterprise Project Management Solution for their organization.

Introduction Understanding Report Types Creating Reports Creating Dashboards using PerformancePoint Services Creating Dashboard using a Web Part Page Conclusion Appendix A – Enterprise Custom Fields Appendix B – IPMO Stored Procedures References List of Figures List of Tables