Skip to main content

Business Intelligence in Project Server 2010

Learn about business intelligence (BI) in Microsoft Project Server 2010, built on Microsoft SharePoint Server 2010. For cross-product information about business intelligence solutions from Microsoft, see the Microsoft Business Intelligence Scenarios on TechNet.

Get Started

Business intelligence and reporting overview in Project 2010Business intelligence and reporting overview in Project 2010

The Microsoft Enterprise Project Management (EPM) Solution includes a variety of online views and powerful business intelligence and reporting services to help organizations gain insight and control across all project portfolios.

Plan reporting and business intelligence (Project Server 2010)Plan reporting and business intelligence

Project Server has been integrated with Excel Services in Microsoft SharePoint Server 2010 to make it easier to create custom reports. As part of this integration, blank data-connected spreadsheets and sample reports are provided.

Project 2010 Quick Start Training – Reporting (Part 1)Project 2010 Quick Start Training – Reporting (Part 1)

Every organization from small to big requires an insight into business data, including project and portfolio information. Project Server 2010 benefits from the rich BI platform of SharePoint Server 2010 and offers powerful dashboarding capabilities. Reporting (Part 1) of the Quick Start training talks about out-of-the box reporting capabilities and infrastructure enhancements.

Project 2010 Quick Start Training – Reporting (Part 2)Project 2010 Quick Start Training – Reporting (Part 2)

Reporting (Part 2) of the Quick Start training shows other powerful services available with every deployment of Project Server 2010, such as Visio Services and PerformancePoint Services.

About the BI Center (Project Server 2010)Video: About the Business Intelligence Center

This video helps Microsoft Project Web App site administrators become familiar with the business intelligence and reporting environment used in Project Server 2010.

Deploy and Configure

Configure SQL Server and Analysis Services for use with Project Server 2010

Before installing SharePoint Server 2010 and Project Server 2010, you must first configure Microsoft SQL Server and Analysis Services.

Configure reporting for Project Server 2010

Project Server 2010 integrates the SharePoint Server 2010 Business Intelligence Center Web application, which provides a central point for hosting the reports, dashboards, and report connections that can be auto-created or manually authored to provide access to reporting data.

OLAP database management

Through Microsoft Project Web App (PWA), multiple OLAP databases can be delivered that contain the specific resources, projects, and custom fields that each group within your organization requires for its particular group reporting needs.

Troubleshoot business intelligence features

To get the best benefit from the Project Server 2010 business intelligence features, you should understand how Excel Services, Secure Store Service, PerformancePoint Services and SQL Server fit together to provide business intelligence in Project Server 2010. This blog post provides that overview and provides troubleshooting answers for common issues.

Use Project Server with PerformancePoint Services

The scenarios in this section use PerformancePoint Services in Microsoft SharePoint Server 2010 together with Microsoft Project Server 2010. PerformancePoint Services can help you to monitor and analyze your Project Server deployment by providing tools for building dashboards, scorecards, and key performance indicators (KPIs).

Reporting with Project Server 2010

This white paper is an introduction to the reporting options available in Project Server 2010 and SharePoint Server 2010. The target audience for this document is the experienced user, business owner, or administrator who is new to Project Server 2010 and looking for a quick way to assess the reporting options available to the organization.

Project Server 2010 reporting with Excel Services

Learn how to create and deploy reports that support the deployment of an EPM Solution. This document provides a step-by-step approach to building reports specific to Project Server 2010 data with Excel and Excel Services.

Creating dashboards for Project Server 2010

Learn how to design and implement Business Intelligence dashboards that support an EPM Solution. This document also includes detailed steps on how to replicate reports and dashboards that are included in the Project Server 2010 demonstration and evaluation pack.

PerformancePoint Services for Project Server 2010

Learn how to design and implement Business Intelligence dashboards for Project Server using PerformancePoint Services in SharePoint Server 2010.