ANNOUNCING: Microsoft Project Server 2010 Burn & Forecast and Spend Report Solutions

I am pleased to announced the release of two Microsoft Project Server 2010 reporting solutions on TechNet Gallery: Project Burn and Forecast Report and Project Spend Report. Both solutions can be deployed and tested with the Microsoft Project Server 2010 v2 Demo Virtual Machine. These reporting solutions leverages Microsoft SQL Server 2008 R2 Reporting Services…


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…


Great read: How to Choose the Right Business Intelligence Technology to Suit Your Style – Microsoft BI!

Great white paper published in January from Microsoft Business Intelligence team: Choose the right business intelligence technology to suit your style (white paper) From the white paper’s introduction: This white paper discusses five different styles of BI reporting: Self-Service Analysis – Self-Service Analysis describes free-form reporting and analysis by users so that they can integrate…


Getting started with business intelligence in SharePoint Server 2010

It’s all about Business Intelligence and reporting! I’m sure you all agree, check out this recently released set of diagrams that will explains the options available with SharePoint 2010 to extract and surface your Project Portfolio Management diamonds, rubies and nuggets… As a reminder check out the Business Intelligence in Project Server 2010 for…


Business Intelligence and Microsoft Project Server 2010

Timely subject with the following resources recently released on the topic; check out the following to learn more about it: Project Server 2010 Project and Portfolio Management Reporting – webcast in 90min … Project 2010: Business Intelligence Overview – product group blog post Business Intelligence Resource Center for SharePoint Server 2010 – all up BI…


Project Server 2007 Report Pack II – An incredible asset you should all leverage

This is a blog post that is worth checking out! My colleague Jan Kalis just announced the release of the Project Server 2007 Report Pack II (recorded webcast and demo here). Why is it the best thing since slice bread? Well check out the following list of SQL Server Reporting Services it contains (and to…


How to Leverage Project Server 2007 with PerformancePoint Server 2007 Monitoring and Analytics?

I am pleased to announce the release of a white paper written by Symmetry Corporation entitled:  How to Leverage Project Server 2007 with PerformancePoint Server 2007 Monitoring and Analytics. This white paper provides an overview of the Microsoft PerformancePoint Server software and how it can be used to develop dashboards with the existing relational and…


Microsoft PerformancePoint Server 2007 Roadmap Update

Microsoft announced last week important changes to our PerformancePoint Server product roadmap, check the following blog post to learn more: Microsoft Brings Business Intelligence to the Masses With SharePoint (presspass) Microsoft Business Intelligence strategy update and SharePoint (Microsoft SharePoint Team Blog) Microsoft BI Strategy Update (THE BI blog)


Fields required to run Project List and Project Detail Reports

I posted this set of sample SQL Server Reporting Services (SSRS) reports almost a year ago: New SQL Reporting Services Sample Reports for Project Server, and due to popular demand finally documented the required custom fields and lookup tables to run the following two reports: Project List Project Detail If you are looking for a…


How to report Project Risks at a Program Level?

<Update June 2010> As a reminder as mentioned in this MSDN article: SharePoint Database Access “process for acquiring that data should be through the built-in SharePoint object model, and not by using any type of query to the database.” hence a much more elegant and supported solution to address this request is to use the…