BI Archives

POWER BI – Connecting to an On-Premise SQL Server Database

Posted by: Peter Williams on July 5, 2016

NOTES: A POWER BI PRO licence is required to connect to On-Premise Data. For details, please refer to https://powerbi.microsoft.com/en-us/documentation/powerbi-power-bi-pro-content-what-is-it/ For security related questions, refer to the Power BI whitepaper http://download.microsoft.com/download/4/8/C/48CFCF8A-2025-4B97-B249-7B505E26E7ED/Power%20BI%20Security%20Whitepaper.docx Installing Data Management Gateway on computer on the same network as the SQL Server I have logged into the server I wish to install

Blog Posted In: Blog, How to

How to Remove the Gap Between WebParts on PDP

Posted by: Khurram Jamshed on May 7, 2015

In the world of Project Server/Project Online, we deal with Project Detail Pages (PDPs) to place custom fields using basic info web-parts all the time. There is often a need to drop more than one basic info web-part on to the same page and to group similar fields. I usually do this when I have

Blog Posted In: How to

Project Hand Over Best Practices for PMO’s to Project Managers

Posted by: Khurram Jamshed on January 14, 2015

I was recently creating a project hand-over process for a PMO and after performing the required PMO activities, the project was to be handed over to the Project Manager for execution. The process comprised a list of activities that Project Managers have to perform to accept the project from the PMO so that he/she can

Blog Posted In: How to, Project Client

How to Use MS Project for Scheduling in the Construction Industry

Posted by: Laith Adel on December 11, 2014

Quite often I hear from our construction clients that the typical Primavera is the “right” tool for scheduling construction projects and that MS Project is not “right”. When we get down to the details of why MS Project isn’t right, it boils down to two common issues: 1. It’s not possible in Microsoft Project to

Blog Posted In: How to, Project Client, Troubleshooting

Reporting in Project Online

Posted by: Laith Adel on October 1, 2014

Tracking project and/or portfolio progress, and forecasting future performance are the cornerstones of all project management methodologies. While the reporting requirement itself is common and generic in nature, every organisation has specific PM practices which demand unique reporting that will result in the requirement for custom-developed Project Server reports. To meet this need, Project Online

Blog Posted In: How to

How to Create a Colour Coded Calendar in Microsoft Project

Posted by: Dan Stopher on September 30, 2014

I recently had a client request a calendar that auto colour coded appointments based on a category. I was really happy with the outcome and that it’s a useful tool that they are now using. The below image is from the PoC sample site. To top it off I also wrote a neat

Blog Posted In: How to

How to View all Deliverables in Microsoft Project Professional

Posted by: Peter Williams on September 17, 2014

Due to a schedule having many deliverables, it isn’t possible to select some of the deliverables to edit. For example, after clicking on the Manage Deliverables button (Task toolbar >> Deliverables >> Manage Deliverable) in the sample schedule shown below, despite the schedule having over 50 deliverables, only 26 are listed in the pane. The

Blog Posted In: How to

Introducing The Project Clan – A Guide to Differentiate Between Project, Project Online, Project Professional for Office 365 and Other Similar Terms

Posted by: Dan Stopher on September 3, 2014

Microsoft’s decision to embrace the cloud has been a game changer resulting in many more organisations being able to embrace Microsoft’s’ Project and Portfolio Management (PPM) solution suite and realise the related benefits. However, new terms have caused confusion with some of my clients so I have put together a simple explanation of key terms.

Blog Posted In: How to, Troubleshooting

PPM Tool Analysis; The Good, The Bad and The Ugly Webinar

Posted by: Laith Adel on September 1, 2014

PPM_Tools_Analysis.pdf

Blog Posted In: Reporting