Forget Excel - forecast with confidence.
So you’re storing your operations and financial data in your ERP system and then extracting that data for business critical analysis. That sounds like best practice – so far so good. So how are you crunching those numbers? If your answer is Excel, well nobody could blame you but it’s probably time you switched to a platform more fit for purpose.
Why do I need a fit for purpose platform?
There are a number of reasons but Tim Worstall probably said it best in his 2013 Forbes article titled ‘Microsoft's Excel Might Be The Most Dangerous Software on the Planet’. In his piece Worstall highlighted the billions lost by J P Morgan in a cut & paste spreadsheet error and pointed to alerts from the Basel Committee on Banking Supervision and the UK’s Financial Services Authority — warning about the inherent risk of manual processes in relation to spreadsheets and a lack of consistently applied controls around data accuracy.
To add to that picture we would make the following less sensational but nonetheless pertinent observations about what we see every day with Excel-based tools — especially those that have grown organically over time:
- They are hard to debug
- They are tough to add new functionality to
- They don’t adapt easily to the changing needs of the business
They are usually driven by the expert who built them, and if they leave it’s often a world of pain as the inner workings are rarely documented
In our experience, these are the main issues, but there’s another one we strike often — an Excel tool with known issues that nobody rectifies as everyone’s afraid a ‘fix’ might permanently break it.
So what's the alternative?
At Datamine we’ve help organisations address all these issues (and more) by creating bespoke software applications with a core analytical component, forecasting or scenario & simulation modelling. These solutions take in data, perform complex calculations or apply statistical techniques, and then present key business outputs in an easily accessible, intuitive web interface.
For example, we recently built a bespoke application for a media client that enabled them to quickly compare the relative success of different marketing scenarios, information which they then used in their sales collateral. Where previously the team would rely on one or two experts to delve into Excel for the analysis, the Datamine tool now removes the middleman — allowing users to quickly tweak a few inputs to create results for themselves.
A solution at another organisation saved the company over 45,000 people hours per year – adding nearly $1M to the bottom line annually.
Compared to an Excel based solution, a bespoke app delivers the following key benefits:
- Built with thoroughly documented, modular code that can be debugged, unit tested, and upgraded/enriched easily
- Speed increases of over 100x to perform a function — allowing for more testing and agile decision making
- An ability to save & compare results, and go back in time to undertake historic analysis
- A user-friendly web or data visualisation front end with a help function and user manual — directly empowering all app users — as opposed to creating skill-siloed Excel ‘experts’
- A significant reduction in the risk associated with having business-critical decision making reliant on tools that are almost impossible to audit
There is a better way!
The development phase of bespoke applications can be fast, with a three-month turnaround not uncommon — and the return on investment period is also very quick. Now don’t get us wrong, we’re not completely against Excel – it has its place and is a very useful tool. That said, though, it makes sense to be aware of a spreadsheet’s inherent shortcomings when really important decisions are on the line (just ask J P Morgan).
ABOUT THE AUTHOR
Sally Carey is a former director of Datamine with over 20 years experience consulting on data analytics solutions across a range of industries. Before retiring, Sally specialised in delivering clarity from the complexity of big data – advising organisations on a host of predictive analytics disciplines, including decision-making, loyalty programmes, organisational change and marketing strategy.