Andrew Macpherson

Andrew Macpherson


Managing Director

Learn all about our Managing Director and resident Excel geek!


What Andrew offers our clients…

Andrew enjoys programming, data management, analysis and visualisation, so his skills are well suited to a wide range of applications.

He has been producing countless macros, scripts and programs for more than 15 years; these greatly assist our clients, and also turn the other Prism team members’ ideas into useful programs. Andrew also plays a key role in moving an ever-expanding range of statistical tools to our website, in order to make them freely available to everyone.

Andrew also curates and delivers a number of our training courses, and enjoys conveying the relevant concepts to people unfamiliar with statistics. He takes a particular interest in the practical applications of statistics; for example, how the various statistical software packages can be used to make sense of complex data, or how DoE can be used in any scientific field.

What Andrew offers Prism…

Andrew is our Managing Director, so is ultimately responsible for all aspects of our business. He regularly negotiates agreements with our clients, provides estimates, manages our team, oversees various projects, and approves the eventual invoices. Andrew is a vital part of our core team.

He also likes to contribute to project work, assist colleagues with data management, deliver training courses, and develop bespoke software solutions, so he’s usually kept fairly busy!

Andrew’s experience…

After studying Maths at university, Andrew worked for several years at Johnson Matthey, where his love of Excel grew as he developed numerous stock control management tools. He was also involved in a large ERP implementation programme, which saw him act as an internal consultant to various stakeholders within the company.

After this programme was successfully completed, Andrew left the company in search of a new challenge. He was approached by Paul Nelson, who wanted someone to turn his statistical methods into user-friendly tools – and so began a beautiful relationship! After working initially as a Consultant from 2005, Andrew became a Director in 2013, and our Managing Director in 2015. Over this time he's delivered a range of training courses, familiarised himself with various statistical software packages, and reformatted more datasets than he's had hot dinners!

What Andrew enjoys most about working with Prism…

  • The people that he’s fortunate enough to work with, both inside and outside the company;
  • The challenge of dealing with complex and varied statistical problems;
  • The practical benefits of applying DoE to the world around us;
  • The freedom and flexibility of working for a small company.

If Andrew could give one piece of advice to all potential clients, it would be…

Define a consistent data structure before you start!

Andrew’s first rule of consultancy is…

Never be surprised.

How Andrew relaxes outside of work…

Andrew is a big fan of a sunny afternoon in a pub beer garden, with his delightful wife and daughter. He’s an even bigger fan of a sunny afternoon in a pub beer garden without his delightful wife and daughter cramping his style – but, in fairness, he did propose, so he should now suffer the consequences of his actions.

He also “enjoys” supporting Tottenham Hotspur, and indulges in an occasional kickabout himself.

After living in Cambridge, Barcelona, London and Cambridge again, he moved to rural Suffolk in 2016, and now spends his weekends struggling to keep his garden under control.

Andrew’s greatest achievement…

Completing Wainwright’s 192-mile Coast to Coast walk in 2010, during which he met the future Mrs. Macpherson.

Andrew’s ideal holiday would be…

A chauffeur-driven tour around the Rioja region of Spain, leaving no vineyard unvisited. Or, if he could take a month off work, walking the world-famous Camino de Santiago!

Most surprising thing about Andrew…

That his delightful wife hasn’t thought better of it, and become his delightful ex-wife.

Least surprising thing about Andrew…

He really loves Excel!


Andrew is proficient using various software packages, including:


See what Andrew has been writing about...


Find Andrew on social media at: