Mistake #1: Forcing users to abandon spreadsheets or current reporting tool:
More likely than not, every computer in your organization has either Microsoft Excel or another spreadsheet application installed. Businesses who implement Business Intelligence software solutions that replace Excel run the risk of having users who do not want change. While the fancy reporting tools and beautiful dashboards promise to replace the need to use Excel, when all ends fail: users run back to their ‘old companion’ aka spreadsheets. Whether it is how long it takes to run an ad-hoc report, or how unnecessarily complicated it is to enter and manipulate data, users stick to what they know in times of difficulties.
Just give up trying to force users to stop using spreadsheets. Find a Business Intelligence tool that offers flexibility and easy spreadsheet integration so that users can get the best of both worlds. A good example of this software solution is PowerOLAP dynamic integration with Excel and other reporting tools.
~Blog Contributed by: Hellen Oti-Yeboah, Marketing Associate, PARIS Technologies