Search Results

Most of the reports I create have a time element… Which client used the most project hours last year? ….. How many hours are my QA people scheduled to work next month?  Without that time framework, the information is less valuable. Time phased reports do, however, have an unfortunate side. The tables we must use […]

Recently, we were working on a nice set of Project Online timesheet reports for a client.  The fields we needed were in these Odata tables: Tasks TimesheetLines TimesheetLineActualDataSet We knew we were going to need to create some calculated fields, so we decided to use PowerPivot.  We needed to create relationships between these 3 tables, […]

No Good Portfolio Data Unless Everybody Plays!  Lets put that project portfolio management (PPM) system to work.  The organization has a high level of maturity with PPM tools and understands how utilizing plays a part in the organizations return on investment.

We have been waiting to hear about what will be new in Microsoft Project 2016. Here is a brief overview of what is coming:   Resource Engagements For project managers, securing resources to ensure your project is properly staffed has always been a challenge. With Microsoft Project 2016, it’s now possible to systematically request a […]

We love using Excel with Project Online or Project Server to pull updated live data at any time. Often, our clients want to see this data with some sort of conditional formatting.  Maybe it’s a heatmap throughout a numbers grid, or perhaps text highlighted  in bold or red when a number exceeds a threshold. In […]

Project Center is a great tool for presenting a portfolio in a snapshot. Using the right filters and grouping, you can quickly show health across the portfolio, projects grouped by client, capitalized vs. non-capitalized projects with costs. And all of this without manipulating a report. By nature, time is not an element we frequently feature […]

We are excited to announce the availability of Project Server 2016 IT Preview. Microsoft has worked very hard over the past three years to bring the latest and greatest innovations to Project Online and incorporate feedback from customers into Project Server 2016. Project Server 2016 IT Preview provides an initial view of what is to […]

Being a visual person, I love the idea of charts, views and graphs. These tools make it easy to tell your story at a glance.  Are our projects in good health? Do we need more resources to accomplish our goals? Is our risk level above our threshold? The primary example of this sort of reporting […]

Ever wonder how Microsoft Project Server is calculating those Resource Availability numbers on the Requirements Details page in Portfolio Analysis? First make sure you have the Highlight Deficit checkbox selected. This highlights the months in red where you have deficits. Let’s focus on the month of September and the role of Product Engineer. I scrolled […]

  With Project Server 2013 and Project Online, Microsoft replaced the server-side scheduling engine with the Project Calculation Service (PCS), bringing the power of the Project Professional scheduling engine to the browser. This new service also powered a new cloud-ready Project API, also known as the Client Side Object Model (CSOM). What’s changing? There will […]

It can be challenging for resource managers and project managers to agree on and assign resources for specific projects and tasks. With no clear way to track who is working where, who is over-allocated—and with crossed lines of communication, things can start to break down. To address these challenges, Microsoft is introducing a new capability […]

From the Microsoft Ignite conference in May, these are some of the highlights of what we have to look forward to features being added to Project 2016. User interfaceMore fluent user interface if you are familiar with current interface you should find new features easily, and if you are new to Project hopefully features will […]

Let me start by saying NEVER delete or edit an out of the box field on a project site for risks or issues in Microsoft Project Server or Microsoft Project Online. Doing so will create issues with syncing and you could see some of the following scenarios: Sync errors showing up the queue related to […]

We receive questions on how to leverage the OData connections quite often, therefore, I thought I’d write up a quick-start. Navigate to the Business Intelligence/Reports section of PWA Locate your OData connections.  There can be several ways to do this.  here’s one: Click on the Gear in the top-right, then select Site Contents Locate and […]

One thing that can make our rollout of Microsoft Project a success is understanding how our data shows up in reporting and views.  This is true whether we’re using Microsoft Project Online or Microsoft Project Server. At MS Project Now, we’ve seen a wide assortment of client reporting needs. One critical piece is always the […]