Viewing Timephased data in Visual Reports #MSProject #Excel

<coffee>

I recently ran an MPUG session integrating Project with Excel.  Part of the presentation was using the Visual Reports feature and exporting the data to Excel, and I had one of those questions which caught me out (though it shouldn’t have, I’d just had a long day!).  So this post answers the question that . . . → Read More: Viewing Timephased data in Visual Reports #MSProject #Excel

Share

Planner is live! #Planner #Office365

<baileys>

Typically I don’t blog about service packs, feature packs, CUs, PUs and anything else release related, however, this time I’m making an exception because Microsoft have now officially released Microsoft Planner!  Planner can be used to create plans, and organise and collaborate on tasks, and assign them to users.  It’s a fantastic task management . . . → Read More: Planner is live! #Planner #Office365

Share

SPC Adriatics 2016 #ProjectOnline #Workflow

<jana mineral water>

I’m delighted to be have presented at the SPC Adriatics 2016 on a couple of topics regarding Project Online, and decided to record the sessions so I could share them to a wider audience.   Alas I only remembered to record part way through the 2nd session, but it’s sufficient.  Also, apologies for . . . → Read More: SPC Adriatics 2016 #ProjectOnline #Workflow

Share

Issues with Multiple Project Server Accounts in #MSProject with #ProjectOnline

Updated – 1st June 2016

One of the other things I did in MS Project was remove any disconnected services from MS Project… which left me with only connected services (see image below)

Also, Microsoft have rolled out fixes in Project Online and the updates for MS Project – so with this blog and the . . . → Read More: Issues with Multiple Project Server Accounts in #MSProject with #ProjectOnline

Share

Securing Enterprise Custom fields on Project Detail Pages in #ProjectOnline #Project #PPM #PS2013 #Office365

<Tomato Soup>

One of the main configuration items with respect to Project Server / Project Online is the creation of project level Enterprise Custom fields and their layout on separate Project Detail Pages.  Assuming that you are not using workflow* then by default anyone with read access to the project can see all of the . . . → Read More: Securing Enterprise Custom fields on Project Detail Pages in #ProjectOnline #Project #PPM #PS2013 #Office365

Share

#PowerBI on the TechNet UK blog

#ProjectOnline #ProjectServer #PowerBI #PowerQuery #BI #Office365 #Excel #PPM

<tea>

Just a quick plug for an article I recently wrote for the TechNet UK blog – it’s an expansion on a previous blog and works as an introduction to PowerBI with Project Online and is available here…

http://blogs.technet.com/b/uktechnet/archive/2015/12/29/is-power-bi-the-christmas-present-you-were-waiting-for.aspx 

Whilst I’m at it, other noteworthy resources for . . . → Read More: #PowerBI on the TechNet UK blog

Share

#PowerBI with #ProjectOnline #Office365 #PPM to view Resource Work by day

<Frothy Coffee>

Recently I’ve been working with a customer on getting a simple way of displaying resource information.  In truth I started with manipulating data in Excel using VBA, but quickly realised that there was a better way to do this using PowerBI.

The end result (or rather the 1st iteration) is a report which . . . → Read More: #PowerBI with #ProjectOnline #Office365 #PPM to view Resource Work by day

Share

Project 2016 (change 1) – Online status next to name

<ice cream>

In this series of blogs, I’m going to try list the differences between Project 2013 and Project 2016 – I’ll be comparing the Professional versions so if you’ve got the standard version then not every change will impact you.  Also, I’m not going to be concerned with UI changes (unless they are significant), . . . → Read More: Project 2016 (change 1) – Online status next to name

Share

I can’t delete a project – but I’m THE project manager!

<tea>

It’s a bit of a mundane topic this one, but like all of my topics, it’s soooo real world!

I have a customer (okay, so I’ve got lots, not just the one!) and this particular customer is only using Project Online, and not Project Pro for O365/Project 2013 Professional.  For those of you familiar . . . → Read More: I can’t delete a project – but I’m THE project manager!

Share

Nested IFs and Risks Lists

<Early morning coffee>

When it comes to Risks and Issues, I find that many of my customers wish to transfer their existing Risks and Issues Matrix, often held in Excel , directly into the pre-existing SharePoint lists on the project site.  Excel is an excellent tool, managing risks is complex, and so consequently the spreadsheet . . . → Read More: Nested IFs and Risks Lists

Share