Build a change platform, not a change program.

It’s not you, it’s your company. Management Innovation eXchange founders Gary Hamel and Michele Zanini believe that continuous improvement requires the creation of change platforms, rather than change programs ordained and implemented from the top.

October 2014 | byGary Hamel and Michele Zanini

Project Challenge 14/15 October 2014

I will be at Project Challenge, London Olympia, on Tuesday and Wednesday 14/15th of October.

During the show my colleagues and I from TPG The Project Group will be available to discuss and demonstrate Project Online, Project Server, Project Web App, and Project (desktop).

We will also be available to discuss and demonstrate TPG products for integration with line of business systems, and products that extend Microsoft Project, Project Online and Project Server.

TPG’s customer – Orange Business Services – will be presenting on Tuesday 14 October 2014 at 11:30

“How Orange consolidated and integrated multiple data streams in to a single global project solution” with Graham Freak, Global PPM Practice and Des White, Global PPM Practice

Replicate Project Online Reporting Data to a SQL Server database using the OData protocol

This link describes how you can use SQL Server Integration Services (SSIS) to replicate your reporting data from Project Online to a separate SQL Server database, using the Open Data protocol (OData).

It explains how to install the add-on, the high level details of the replication process and how to get started in Visual Studio with the Integration Services project template to create a project that automatically pulls your data based on a schedule.

While Project Online: SSIS package for OData delta sync provides an example SSIS package that demonstrates how to perform a delta sync to reduce download times. The package retrieves Project Web App (PWA) data only for projects that changed since the last sync. This sample applies to Project Online reporting when report data is replicated to a local SQL Server database.

Why Project Online #1

Why would you choose Project Online?  Let’s assume you’ve made the decision to improve how you manage and approach portfolio / programme / project management (which is a topic in itself).

As an organisation you’re spending time reviewing your processes and working practices, in light of your requirements and aspirations.  Now you’re looking for some tools to help support these changes.

Project Online provides a number of capabilities that can be deployed, preferably through a staged approach.  At a high level these capabilities include:

  • Portfolio Management / Selection & Prioritisation (a very short hand description!)
  • Resource forecasting & management
  • Project scheduling
  • Timesheets
  • Reporting & BI
  • Collaboration across teams

I will be looking at the various capabilities over the coming days and weeks.

In the meantime, using Project Online and working with a suitably qualified Microsoft Partner, can help you deploy the toolset in a shorter timeframe.

This can seriously reduce upfront CAPEX that may be required to get an environment up and running (licenses, virtualised or hardware infrastructure).  At the same time, your  partner should be able to provide an OPEX approach to deployment and on-going support, in the same way that your organisation is obtaining Project Online.