Monday, February 23, 2015

O365 Roadmap - Project focus


Coming back from the TechDays 2015 in Paris, I've been reading a couple of articles about O365 which is going to be a particular target for MS developers and innovation in the coming years. I've ended on this roadmap which lists "updates that are currently planned for applicable subscribers. Updates are at various stages from being in development to rolling-out to customers to being generally available for applicable customers world-wide"

If you search for "Project" updates, you'll find 4 interesting updates. Obviously being a MVP has some advantages and I already heard of those improvments to come. But the question was more about the NDA on those new developments which prevents me blogging. Now it is public, let me summarize for you what you can expect about Project.

1. Apps for Project Pro for Office 365 write support

Apps for Project Pro for Office 365 will be able to write-back and update the project plan. 

2. Capacity Management capabilities in Project Online

Resource Managers can benefit from configurable color coded heatmaps to better predict the utilization of   their resource pool in Project Online. These heatmaps will also support seamless drill-down capabilities all the way down to individual resources and their assigned projects. 

3. Multiple timeline bars in Project Pro for Office 365

In Project Pro for Office 365 you will be able to create multiple timeline bars within the Timeline view. You will also be able to set a custom date range for each timeline bar in order to just highlight a certain time period of the project in the Timeline view. 

4. Resource Engagement Workflow in Project Online

Project managers, working in Project Pro for Office365 can systematically place resource requests in order to build their project teams.  Soon thereafter, Resource managers working in Project Online willbe able to view, modify, accept or reject those requests. Also, decisions made by Resource managers  will be available to Project Managers within Project Pro for Office 365 to review and plan accordingly.  

Do not hesitate to drill down into the several updates in the list, particulary around O365 which will for sure have a positive side effect on the Project word, such as the O365 notification pane or Power View integration in Excel Online.
Share this article :

Monday, February 16, 2015

Tip for resource forecasting: show assignment units as a decimal

Not all our readers use Project Server, thus this post is only related to MS Project. Indeed Project Server proposes advanced features to enhance capacity planning and forecasting through tools such as the resource plan which is very convenient in an early planning phase. It allows entering FTE by skills (or named resources evenif it makes less sense) in order to plan your resource demand. In my screenshot below, work is displayed in hours but it can also be managed in FTE or in days.
Figure 1: Project Server resource plan
Does that mean that MS Project (standalone) users cannot achieve such a goal?? I don't think so, since MS Project still proposes a large set of planning features. I'll show you in this short post how a very simple option in MS Project allows you visualizing in a better way FTE required for a project.

You are all aware of the unit concept which is meant to give the ratio the resource will work on the task. By default this is configured as a percentage.
Figure 2: Assignment with units as a percentage
In the example above, I have assigned 5 full-time analyst on my task, and I can check the work calculated accordingly by Project.

Having provided MS Project trainings since years now, I've had a lot of questions about this assignment unit. It is not quite difficult to understand but it requires kind of self thinking to masterize the concept. For example, you never say "I'll assign 250% of  designer on this task" but "I'll assign 2,5 designers full-time on this task".

This is where I'm heading to: Project allows you doing such a wonderful trick. Going to file, options, schedule, you'll be able to set the assignment units as a decimal:
Figure 3: setting the assignment units as a decimal

Then I can happily forecast the resource demand on my project more easily:
Figure 4: creating an assignment with decimal units
Note that it changes absolutely nothing to how Project will calculate the assignment data, it is just more convenient for certain users and might make easier the resource forecast phase.
Share this article :

Friday, February 6, 2015

New filtering feature in Excel 2013 : the timeline!

For once, I won't write about Project Server but about a related topic: Excel! Actually both applications are closely interrelated since Excel through Excel Services allows creating tremendous reports using Office Data Connection (ODC) files on OLAP database or reporting table (it took me a while to get used saying "table" instead of "database" for PS2013!).

Excel 2010 brought a nice feature as the slicer for filtering data in pivot tables. This gave a nice graphical and mobile-adapted (smart phones, tablets) way to filter information. You could deploy thanks to this feature more user-friendly dashboards.

Excel 2013 goes on furhter this way introducing the timeline filtering feature that works similarly to the slicers. You can insert a timeline based on the time dimension (year, month,...) and link it to one or more pivot tables. Here is an example on the Excel Services sample dashboard that comes out-of-the-box in Project Server 2013 BI Center.
Figure 1: timeline filtering feature in a Excel Services dashboard
Then after filtering with the timeline:
Figure 2: dashboard filtered with the timeline

Now how to do it? You first need to start with an Excel file embedding data. It could be with an ODC (reporting table or OLAP data) as per my example below. Note that it won't work for MS Project visual reports, since timeline cannot use offline OLAP connections.

From the "insert" tab in the ribbon, "filter" section, select "timeline" option:
Figure 3: insert a timeline on a pivote table
From the options tab once the timeline is selected, you can connected it to any pivot table and change the formatting options.
Figure 4: timeline connection and formatting options
Et voilà!! If you had fun using the slicers, you'll love creating and using dashboards with the timeline!
Share this article :