Monthly Archives: June 2012

New Oil and Gas Case Study Published

Working primarily in O&G myself these days, it’s always good to see another industry specific case study.  Here’s an example that was just published on Microsoft.com about UMT’s collaboration with Gran Tierra. http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=710000000923

Posted in Self Referential | Leave a comment

Automatically Filtering Excel Reports in PerformancePoint Dashboards

This post is essentially a follow up to a series of three posts I wrote last week on how to create a Webpart in InfoPath that pulls URL parameters, queries SQL and then filters PerformancePoint reports with the returned value.  … Continue reading

Posted in BI, Reporting | Tagged , , | 5 Comments

PPM For Everyone…In Under 3 Minutes

Here’s a great video that Sy Aslan, our academic director, put together to explain the fundamental concepts of Project Portfolio Management…in under 3 minutes.  A short, concise description of the value proposition of effective PPM. Project Portfolio Management, Explained

Posted in Portfolio Management | Leave a comment

Highlights from Last Week’s TechEd

Looking for some entertainment to round out the week?  Look no further.  Check out this presentation – right around the 14 minute mark for what I thought was the best moment in all of TechEd 2012. http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI207

Posted in Events | Leave a comment

Returning Reporting Database Values in the Project Workspace

Just a quick add on to yesterday’s post on leveraging InfoPath to create automatically filtered PerformancePoint reports on PDPs.  I figured that I’d extend the same approach to the workspace. For the workspace, we can simply pull the URL of … Continue reading

Posted in BI, InfoPath, Reporting, SharePoint | Tagged | 5 Comments

Adding Filtered Project Dashboards to PDPs (Part 2)

In this post, we’ll take that InfoPath form we created in the last post, add it to a PDP, and link it to a PerformancePoint report to create an automatically filtered project dashboard.  For what it’s worth, I know it … Continue reading

Posted in BI, InfoPath, PDP, Reporting, SharePoint | Tagged , , | 3 Comments

Adding Filtered Project Dashboards to PDPs (Part 1)

I guess a combination of that last post on “fun with InfoPath” and my upcoming TechEd BI presentation prompted me to get in a bit of an InfoPath/BI rut this week….or maybe it’s just the fact that I can feel … Continue reading

Posted in BI, InfoPath, PDP, Reporting | Tagged , , | 9 Comments

TechEd 2012 Recording Posted

For those of you who couldn’t make it out to the presentation I delivered last week in Orlando, please note the recording has been posted here: http://channel9.msdn.com/Events/Speakers/andrew+lavinsky Enjoy.  And for those of you who download the PPT, note the hula … Continue reading

Posted in BI, Self Referential | Tagged | Leave a comment

TechEd 2012 Project Server BI Follow Up

Thanks to everyone for coming out to the TechEd presentation on Project Server BI that wrapped up just now. For blow by blow descriptions and screenshots on reproducing everything I just presented, I refer you to the following links: Project … Continue reading

Posted in BI, Reporting, Self Referential | Tagged , | Leave a comment

Break Out the Ripe Tomatoes…It’s MS TechEd (North America)

If you’re in the Orlando area, this week’s your chance to get back at me for all of those blog posts that probably ended up breaking your production environment over the past couple of years…. Come on by and chat.  … Continue reading

Posted in Self Referential | Tagged | Leave a comment