Monthly Archives: May 2014

A recipe for Excel BI harmony

20 years’ ago when I first started my career in BI one of the most common projects I would get involved with was the replacement of Excel based reporting systems, with a “proper” BI system. The business justification was easy:

  • Duplicated effort with multiple departments producing their own versions of the spreadsheet
  • Time wasted in meetings deciding whose numbers to run with – do we go with finance’s definition of revenue or sales’ definition?
  • No single version of the truth meaning a recipe for inconsistent decision-making Continue reading