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