#Project #MVP Award #ProjectOnline #ProjectServer #MVPBuzz #Microsoft

April 1, 2016 at 2:15 pm | Posted in Information, Personal | 8 Comments
Tags: , , ,

Some good news, I’m very pleased to announce that my Project MVP award was renewed for the fourth time after first being awarded in April 2013. I am really grateful for the recognition, especially as I still enjoy helping out the Project and Project Server / Project Online community so much. It is kind of a hobby of mine I guess, or maybe just an obsession!

#ProjectVConf session summary for #ProjectOnline #BI #PowerBI #Excel #SSRS #JavaScript #SSIS

November 3, 2015 at 3:13 am | Posted in Administration, Information, Personal | 1 Comment
Tags: , , , , , ,

It’s been a few weeks now since the Project Virtual Conference, for those of you that missed it, sign up here: http://projectvirtualconference.com/ and you can view the recordings.

This post will give a summary of my session on Project Online BI Made Easy:

http://event.projectvirtualconference.com/B002/

The aim of this session was to give an overview on some of the reporting technologies available to Project Online, this included:

  • Excel
  • Power BI
  • SSIS / SSRS
  • JavaScript / HTML

Firstly I demonstrated some example Excel dashboards I created for the session, screen shots of these can be seen below:

The project report below is from my Project Online report pack found here: https://gallery.technet.microsoft.com/Online-Reporting-Pack-431f075e

image

The report below is an example portfolio dashboard showing key metrics / data:

image

The report below is an example portfolio type report that can filter by programme:

image

I then demonstrated some example Power BI reports and dashboards that I created for the sessions:

The report below contains 4 pages, the first is another example portfolio type report:

image

The second page shows an example Treemap visualisation for the projects in the portfolio based on the % complete:

image

The third page shows an example project report:

image

The final page displays the drill down capability in Power BI, it shows the total cost per project initially:

image

Clicking a project drills into show the task cost for that project:

image

I also put together an example dashboard containing visualisations from the reports and natural language queries from the dashboard data:

image

image

The third technology demonstrated was SSIS / SSRS. The reporting technology was SSRS (SQL Server Reporting Services) but without SSIS (SQL Server Integration Services) an SSRS report would not be possible with Project Online data. Well that isn’t strictly true but you need to extract the data out of Project Online into another data source such as SQL – SSIS can do this but so could a .NET console application using CSOM for example.

Below is an example SSRS project status / highlight report that displays data from my Project Online PWA instance:

image

The fourth technology was JavaScript / HTML, I put together an simple project report that displayed project information – project level data, milestones / marked tasks, issues, risks and data from a custom list on my project site called benefits. This also demonstrated the capability of rendered the HTML tags in multiline fields and accessing custom SharePoint list data from the associated project site. The report can be seen below:

image

I also demonstrated a reporting add-in that we use for PS+ but this was just to give another example using JavaScript / HTML:

image

I then covered a bit around best practice when using the Odata API regarding filtering the data at source as much as possible to minimise the data being pulled down – this means using filters and selects to only pull the information you need.

The final part I walked through creating a new Excel based report from a blank workbook and also create a new Power BI report from a blank Power BI Desktop file.

Take a look at the session for more details.

To help get started with reporting in Project Online, take a look at some of the links below:

Excel Project Online Report Pack: https://gallery.technet.microsoft.com/projectserver/Online-Reporting-Pack-431f075e

https://pwmather.wordpress.com/2014/09/05/microsoft-projectonline-reporting-pack-msproject-sharepointonline-office365-ppm-excel-bi-data/

Blogs posts on Excel / Odata:

https://pwmather.wordpress.com/2013/09/16/projectserver-projectonline-example-report-ps2013-sp2013-office365-bi-excel-powerpivot/

https://pwmather.wordpress.com/2013/08/01/projectserver-projectonline-highlight-report-example-ps2013-sp2013-excel-bi-office/

https://pwmather.wordpress.com/2015/01/20/projectonline-excel-powerquery-report-office365-ps2013-bi-odata/

https://pwmather.wordpress.com/2015/04/13/projectonline-projectserver-reporting-on-auto-manually-scheduled-tasks-bi-office365-excel-powerquery-ps2013/

https://pwmather.wordpress.com/2015/10/09/removing-html-tags-from-projectonline-fields-powerquery-powerbi-excel/

https://pwmather.wordpress.com/2014/07/17/getting-started-with-projectonline-part-9-ps2013-office365-project-ppm-sharepointonline-pm-sp2013/

SSIS links:

https://pwmather.wordpress.com/2014/03/26/projectonline-data-via-odata-and-ssis-in-sql-database-table-on-premise-msproject-sharepointonline-bi-ssrs-office365-cloud/

https://msdn.microsoft.com/EN-US/library/office/dn794163.aspx

Power BI:

https://pwmather.wordpress.com/2015/08/04/projectonline-reporting-using-powerbi-part1-bi-office365-reports-ppm-pmot/

https://pwmather.wordpress.com/2015/08/07/projectonline-reporting-using-powerbi-part2-bi-office365-reports-ppm-pmot/

JavaScript examples:

https://pwmather.wordpress.com/2014/10/26/project-on-a-page-for-microsoft-projectonline-ps2013-javascript-jquery-office365-sharepoint/

https://pwmather.wordpress.com/2015/02/25/projectonline-projectserver-project-cost-and-work-report-javascript-jquery-office365-sharepoint-bi-ppm/

https://pwmather.wordpress.com/2015/05/01/projectonline-projectserver-view-resource-calendar-exceptions-javascript-jquery-office365-sharepoint/

There are plenty of details out there, just have a quick search and you will find lots of helpful articles for each technology!

#Project #MVP Award #ProjectOnline #PS2013 #ProjectServer #MVPBuzz #Microsoft

April 1, 2015 at 5:47 pm | Posted in Information, Personal | Leave a comment
Tags: , , ,

Some good news, I’m very pleased to announce that my Project MVP award was renewed for the third time after first being awarded in April 2013. I am really grateful for the recognition, especially as I still enjoy helping out the Project and Project Server / Project Online community so much. It is kind of a hobby of mine I guess, or maybe just an obsession!

Free #ProjectOnline /ProjectServer advice sessions @ #ProjChallenge #PPM #Microsoft #Project #PMOT

September 29, 2014 at 4:45 pm | Posted in Administration, Functionality, Information, Personal | Leave a comment
Tags: , , , , , ,

Just a quick email to let you know that I will be at Project Challenge in October 2014 at Olympia, London. I will be there over the two days and available for free 20 minute sessions where general advice can been given for common business or technical issues relating to the Microsoft PPM toolset.

For details see the following link:

http://www.cps.co.uk/Who-Are-We/News/Pages/CPS-Invite-you-to-free-‘Ask-the-Expert-Sessions’-at-Project-Challenge.aspx

#Project #MVP Award #ProjectServer #SharePoint #PS2013 #SP2013 #ProjectOnline #MVPBuzz

April 1, 2014 at 3:50 pm | Posted in Information, Personal | 2 Comments
Tags: , , , ,

Some good news, I’m very pleased to announce that my Project MVP award was renewed for the second time after first being awarded in April 2013. I am really grateful for the recognition, especially as I enjoy helping out the Project and Project Server community so much. It is kind of a hobby of mine I guess, or maybe just an obsession!

#ProjectServer #Project Conference 2014 #ProjectOnline #ProjConf #pm #pmot #projectmanagement #PPM

November 22, 2013 at 11:09 am | Posted in Information, Personal | 1 Comment
Tags: , , ,

The Project Conference 2014 is fast approaching. This is the place to be for information on Microsoft Project, Microsoft Project Server and Project Online. For details see the links below:

http://www.msprojectconference.com/ 

http://blogs.msdn.com/b/jkalis/archive/2013/11/20/register-for-the-project-conference-2014-now.aspx

image

See you there!

Project Challenge 2013 #ProjectServer #PS2013 #SP2013 #projchallenge #pmot

October 14, 2013 at 1:26 pm | Posted in Information, Personal | 1 Comment
Tags: , , ,

Just a quick post to let you know that we (CPS) will have a stand at Project Challenge 2013. We will be on stand 72. CPS are also presenting, details below:

Wednesday 16 October 2013 – 14.00
Title: Portfolio management – how do I even get this on the executive agenda?
Speaker: David Dunning, Professional Services Director, CPS
http://www.projchallenge.com/case_studies_expertise.cfm

Tuesday 15 October 2013 – 11.30
Title: Microsoft Portfolio and Project Management made simple! Discover how effortless online and on-premise deployments are now a reality
Speaker: Ivan Lloyd, Product Lead, Corporate Project Solutions

Wednesday 16 October 2013 – 12.30
Title: Microsoft Portfolio and Project Management made simple! Discover how effortless online and on-premise deployments are now a reality
Speaker: Ivan Lloyd, Product Lead, Corporate Project Solutions
http://www.projchallenge.com/presentations.cfm

I will also be around at the exhibition on Wednesday – come and say hello Smile

#Project #MVP Award #ProjectServer #SharePoint #PS2013# SP2013

April 22, 2013 at 12:46 pm | Posted in Information, Personal | 10 Comments
Tags: , ,

I am very pleased to announce that I was awarded the MVP award for Project in April 2013. I am grateful for such recognition for doing something I really enjoy, helping out fellow Project Server community members. I have been holding off announcing the award as my surname is wrong on the award, it states Paul Mathers instead of Paul Mather. This is something that is being corrected but will take time.

MVP

I look forward to continuing helping out in the Project,Project Server and SharePoint communities. Smile

#Microsoft Community Contributor Award 2011 – Thanks

August 31, 2011 at 2:57 pm | Posted in Personal | Leave a comment
Tags:

Just a quick post today, I am pleased to announce that yesterday I was awarded with the Microsoft Community Contributor Award 2011.

Blog at WordPress.com.
Entries and comments feeds.