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

Posted By 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

Read More


Blog Posted In Blog Posted In: Blog, How to
Blog Posted In 

How to Remove the Gap Between WebParts on PDP

Posted By 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

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

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

Posted By 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

Read More


Blog Posted In Blog Posted In: How to, Project Client
Blog Posted In 

How to Use MS Project for Scheduling in the Construction Industry

Posted By 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

Read More


Blog Posted In 

Reporting in Project Online

Posted By 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

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

How to Create a Colour Coded Calendar in Microsoft Project

Posted By 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

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

How to View all Deliverables in Microsoft Project Professional

Posted By 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

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

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

Posted By 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.

Read More


Blog Posted In Blog Posted In: How to, Troubleshooting
Blog Posted In 

It’s a Wrap….Highlights from the Worldwide Partner Conference (WPC)

Posted By Posted by: Dan Stopher on August 11, 2014

The annual Microsoft Worldwide Partner Conference (WPC) was in early July.  Senior consultant, Dan Stopher, attended on behalf of EPM Partners and joined more than 16,000 people in Washington DC to gain valuable insights into the direction in which Microsoft is heading. Dan reports the conference was an amazing experience. Senior Microsoft Management representatives –

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In