Project Server 2010 Reporting (With Excel Services and Creating Dashboards whitepapers)

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

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