#PowerBI Gantt visualization #PPM #ProjectOnline #PMO #BI

March 23, 2016 at 10:28 am | Posted in Add-on, Customisation, Functionality, Information, Reporting | 1 Comment
Tags: , , , , , , ,

A quick post to highlight a cool new custom visual for Power BI that was released a few weeks ago by Microsoft, the Gantt visualization. This can be downloaded from the link below:

https://app.powerbi.com/visuals/show/Gantt1448688115699

Once added to Power BI Desktop this visual can be used in your Power BI reports. Below is a simple example that uses the Project Online Odata API to pull in the Project Name, Project Start Date, Project Duration and % complete:

image

In the example above I have also included some other project level custom fields, one to filter the data with a slicer and one to control the colour of the project bars. There are tooltips on the project / task bars to show details:

image

It also includes a “Today” line by default:

image

The Gantt visualization has some configurable settings that can be found on the visualizations pane:

image

You can control many formatting settings such as the date type:

image

Download and take a look to build some cool project center / project detail schedule type views in Power BI! For other Power BI posts for Project Online / Microsoft PPM, see the link below:

https://pwmather.wordpress.com/tag/powerbi/

Advertisements

#ProjectServer 2016 is RTM #SharePoint #PS2016 #SP2016 #Office2016 #PPM

March 18, 2016 at 4:54 pm | Posted in Administration, Functionality, Information, Installation | Leave a comment
Tags: , , ,

A quick post to highlight some great news this week, Project Server 2016 RTM has been released, the announcement is here:

https://blogs.office.com/2016/03/14/sharepoint-2016-rtm-and-the-future-of-sharepoint-event/

To view what is new for Project Server 2016 see the MSDN link below:

https://msdn.microsoft.com/en-us/library/ff631142(v=office.16).aspx

Some great reasons there for those clients still using the on-premise software to upgrade from earlier versions of Project Server.

To view what has been deprecated or removed in Project Server 2016 see the link below:

https://technet.microsoft.com/en-us/library/mt422816(v=office.16).aspx

To find all of the Project Sever 2016 documentation start here:

https://technet.microsoft.com/en-us/library/cc303399(v=office.16).aspx

#ProjectServer and #SharePoint 2010 / 2013 / 2016 March 2016 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

March 9, 2016 at 11:25 am | Posted in Administration, CU, Fixes, Functionality, Information | Leave a comment
Tags: , , , , , , , , ,

The Office 2016 March 2016 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-gb/kb/3143491

Project 2016 March 2016 update:
https://support.microsoft.com/en-gb/kb/3114865

The Office 2013 March 2016 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-gb/kb/3143491

Project Server 2013 March 2016 CU Server Roll up package:
https://support.microsoft.com/en-gb/kb/3114823

Project Server 2013 March 2016 update:
https://support.microsoft.com/en-gb/kb/3114836

Project 2013 March 2016 update:
https://support.microsoft.com/en-gb/kb/3114843

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the March 2016 CU.

The Office 2010 March 2016 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-gb/kb/3143491

Project Server 2010 March 2016 CU Server Roll up package:
https://support.microsoft.com/en-gb/kb/3114876

Project Server 2010 March 2016 update:
<no update this month>

Project 2010 March 2016 update:
https://support.microsoft.com/en-gb/kb/3114891

SP2 is a pre-requisite for the Office 2010 March 2016 updates.

As always, fully test these updates on a replica test environment before deploying to production

Blog at WordPress.com.
Entries and comments feeds.