Category Archives: Reporting

More Timephased Reporting with OData

Posted on March 26, 2013 by

I realized that yesterday’s post may have given the incorrect impression that you need to go through all sorts of mind bending contortions to get timephased reporting out of Project Online.  The reality is that you’d only have to limber … Continue reading →

Posted in BI, Project Online, Reporting | 4 Comments

Timephased Capacity Reporting with OData

Posted on March 25, 2013 by

Catching up on the blog comments after a couple of weeks of vacation and post-vacation wheel spinning.  One of the comments that caught my eye was Bram de Vries’ comment on a previous reporting post: Do you think I need … Continue reading →

Posted in BI, Project Online, Reporting | Leave a comment

The Release Manager and the Maintenance Scheduler

Posted on February 18, 2013 by

Teach scheduling to any class of IT project managers, and the number one request is invariably “How do I make my schedules more predictable?  How do I accurately predict important events such as application releases?”  There’re really two answers to … Continue reading →

Posted in BI, Reporting, Scheduling | Leave a comment

EPM Bingo, or A Structured Approach to PPM Analysis

Posted on January 16, 2013 by

One of my colleagues used to explain to me that there are three kinds of people that attend any meeting: There are those who feel an emotional need to share how they’re feeling about the topic. There are those who … Continue reading →

Posted in BI, Portfolio Management, Reporting, Workflow | Leave a comment

Filtering Excel WebParts in Office 365 (Part 3)

Posted on December 6, 2012 by

Just wanted to close out this discussion with filtered Excel reports in Project Online with a last use case.  In yesterday’s post, I talked about how to create an automatically filtered project dashboard.  In this post, I’ll talk about another … Continue reading →

Posted in BI, Project Online, Reporting, SharePoint | Leave a comment

Filtering Excel WebParts in Office 365 (Part 2)

Posted on December 5, 2012 by

In this post, I’ll continue discussing how to promote parameters into SharePoint and then automatically filter reports using the SharePoint Filter Webparts.  Note that this solution should pretty much work both in on-prem and online – with the caveat that … Continue reading →

Posted in BI, Project Online, Reporting | Leave a comment

Filtering Excel WebParts in Office 365 (Part I)

Posted on December 4, 2012 by

Following Mike McLean and my triumphant debut as Project Server 2013 BI masters at the recent SharePoint conference, I wanted to document one of the demos – specifically the one where we filtered Excel reports automatically based on external parameters.  … Continue reading →

Posted in BI, Project Online, Reporting, SharePoint | Leave a comment

SharePoint Conference Project Server BI Linkfest

Posted on November 14, 2012 by

Thanks everyone for coming out to #SPC171 just now, where Microsoft’s Mike McLean and I skimmed a rock over what’s new in Project Server 2013 BI.  Looking for more?  Well, you came to the right place. As we mentioned, we’ve … Continue reading →

Posted in Admin, BI, Project Desktop, Reporting, Self Referential, SharePoint | 1 Comment

Project Server and the Obligatory Geospatial Report

Posted on November 12, 2012 by

Well, a great first day at SharePoint Conference already.  Yesterday, I attended Rafal Lukawiecki’s entertaining pre-conference session on the latest in Microsoft BI where he walked through many of the latest and greatest offerings, and included a demo of the … Continue reading →

Posted in BI, Reporting | 1 Comment

The Major Milestone Report Meets OData

Posted on November 6, 2012 by

I’ve been leveraging this report in my demos for a couple of years now – basically an overview of all of the major milestones in the project portfolio color coded by schedule status.  Figured I’d test my newfound OData skills … Continue reading →

Posted in BI, Reporting | 1 Comment