Skip Ribbon Commands
Skip to main content
CPS Blog :
 

CPS Blog

Get all the latest blog posts from CPS

  • February 2012
    • Lastminute.com case study - getting the right people doing the right things in the right way

      by System Account on 15 Feb 2012 13:29
      Category: Best Practice

      ​Launched in October 1998, lastminute.com has grown from a dotcom dream into one of the most well-known global travel brands. As the company expanded, through growth and acquisition, its technology infrastructure and project delivery systems became increasingly complex and diverse as different processes and technologies were integrated into the lastminute.com enterprise.

      Terry Dewhurst was appointed as Director of Transformation, and initiated and led the transformation programme.

      In 2008, Terry started to radically improve delivery of change within lastminute.com, with the objective of creating a framework within which the executive leadership would be able to make strategic decisions which would both reflect international business priorities and also take account of the resources they had at their disposal. The transformation programme was launched and named Z-ETA (being a derivative of “Zen and the art of EMEA Technology Abilities”) and its vision was to deliver all aspects of improvement within technology and project delivery at lastminute.com.

      Read and download his full case study on the APM website.

    • Enterprise Project Management Discovery Day

      by System Account on 07 Feb 2012 09:49

      ​Interested in implementing a Microsoft EPM system but don’t know where to start? Looking to find out how it works in the real world? Got Microsoft Project Server already but would like to understand how to get more out of it? Find the answers at this free seminar.

      ​Microsoft, in partnership with CPS, a Gold Certified Partner would like to invite you to an EPM Discovery Day where you’ll be able to hear from the people who have successfully rolled-out an EPM system within their own organisation. Also in attendance will be technical experts and implementation specialists to show you the key functionality of Microsoft Project Server 2010 and talk through your requirements.

      Agenda:
       
      9.30 – Welcome
       
      9:45 - 10:30 – Key Benefits of Microsoft Project Server 2010 and a guide to successful implementation with Christopher Pond, Solution Specialist at CPS.
       
      10:30 - 11:15 – Case Study: Phillip Stanbury-Jones from ARM, the world’s leading semiconductor IP supplier. Integrating Project Server and SharePoint 2010 to deliver a powerful, scalable PPM system to support ISO9001:2000 compliant management system processes.
       
      11:15 – Refreshments
       
      11:30 - 12:15 – Case Study: Giles Hamson, CPS SharePoint Technical Consultant. Integrating SharePoint and Project Server 2010 - Deployment Approaches, Integration Options and making the most of the SharePoint Enterprise Features.
       
      12:15 – Q&A, Networking
       
      12:30 – Close

      The free half-day seminar is held at Microsoft’s London office and refreshments are served throughout.

      Book Online Today!

  • January 2012
    • The strangest of bedfellows: earned value and portfolio management?

      by System Account on 17 Jan 2012 12:21
      Category: Best Practice

      Read the latest blog post on the APM website from CPS director, David Dunning looking at the overlap between the organisational needs of portfolio and earned value (EV) management.

      View now at: http://www.apm.org.uk/blog/strangest-bedfellows-earned-value-and-portfolio-management

    • Excel Services Reporting - Calling Stored Procedures

      by System Account on 05 Jan 2012 09:48
      Category: Excel Services

      Sometimes reporting in Excel Services isn’t as simple as just reading a view or table from the reporting database, or a basic select statement directly from Excel itself. Occasionally, you might want to pull back data from a variety of tables or views and carry out some pre-filtering on the data before presenting it to the user. The beauty of Excel Services is that it allows you to not only use TSQL directly against your specified database, but also to call Stored Procedures.

       
      In order to do this, simply create your stored procedure in SQL, as you would normally:
      1_SP.png

      When creating you Excel report, simply reference the stored procedure in the connection page:
       
      2_SP.png
       
      After publishing the report to SharePoint the Secure Store Service (SSS) will take care of the rest. It should have sufficient permission to run these stored procedures from the reporting database:

       

      3_SP.png

      Written by Lester Lovelock, CPS Principal Consultant

  • December 2011
    • The SharePoint 2010 Handbook

      by System Account on 13 Dec 2011 13:47
      Category: SharePoint

      CPS Sharepoint consultant, Giles Hamson has written a chapter in a new book which aims to explain some of the key topics of SharePoint 2010 as well as to broaden the understanding of SharePoint so that its full business effectiveness might be better exploited.

       

      The SharePoint 2010 Handbook:  A Collection of Short Chapters for Delivering Successful SharePoint Projects is now available via Amazon and features a number of topics written as separate chapters by different authors, each drawing on their own real world experience.
       

       

      Giles' chapter, entitled 'Creating Dashboards using Business Connectivity Services, SharePoint Designer and other related technologies' focuses on the end to end cycle of linking to 3rd party Line Of Business (LOB) applications, authentication and creating reports.

       

       

      Full Details:
      Publication Date: 7th November 2011
      ISBN/EAN13: 1466486740 / 9781466486744
      Page Count: 448
      Binding Type: US Trade Paper
      Trim Size: 5″ x 8″
      Language: English
      Colour: Black and White
      Related Categories: Computers / Documentation & Technical Writing

Success Stories

Discover how CPS have partnered with a range of organisations to successfully achieve their objectives 

find out more