For over 20 years the Acterys founders have been very closely involved in the evolution of performance management processes working with most major technologies.
In this blog we address the potential for efficiencies and cost savings through platform unification in organically grown, often very disparate approaches that we see at customers.
By Performance Management in this context we are referring to the feedback loop between:
and collaboration in the process:
What we still see as the prevailing status quo at our clients is a disparate mix of applications that are used in performance management process:
In most enterprise cases the core technology part of the process is a data warehouse or a central data model often using one of the main RDBMS (Relational Database Management System) platforms (e.g. Microsoft SQL Server, Oracle, Snowflake etc.). This is in nearly all cases is a “read only” environment. So, the users on the business side (finance, marketing, operations, etc.) must find another application for their requirements.
For the “less well heeled” the standard is more or less manual spreadsheet solution, that typically takes a lot of effort to maintain. Organisation with higher budgets typically use specialized applications that cater in most cases only for some aspects of the process (a consolidation app, an analytics solution, a planning tool, etc.) with varying, often very high price tags (more details in this blog).
So, it is not uncommon that an organisation after having invested a few million Dollars in a data warehouse, spends $3,000-4,500 per power user, per year on planning software to enable write back into a separate “planning database”. Typically, a proprietary technology different to the relational database used in the data warehouse.
Prior to commodity self service solutions like Power BI and Tableau users would spend another $1,000+ for licenses for that.
And this is just the software portion…
To make all this work in nearly all cases expensive, outside consultants with daily price tags ranging from $1,500-$4,000 are needed that often exceed the software investment manifold. Quickly adding up to hundreds of thousands of Dollars investment.
These consultants are not just required to configure the respective performance management component but also to bring it all together again.
The data warehouse data must be loaded and synchronized with the planning, consolidation or other specialized applications, then when finished often back to the data warehouse.
All in all, adding up to an excessive cost bill and unnecessary efforts for maintaining performance management processes.
At Acterys our preferred approach is focused on unifying all performance management processes on a single architecture with a single data store: “the planning enabled data warehouse” based on relational storage:
Relational databases have tremendously evolved over the last few decades, with the elastic capacity of the cloud, in memory processing, column store indices etc.
They perfectly cater for all necessary requirements from detailed transaction orientated ones (e.g. for HR planning that legacy, proprietary OLAP databases cannot easily deal with) to highly summarized multi-dimensional ones.
On this single platform the Acterys engine adds:
Over the last 5 years we have implemented this approach at hundreds of clients around the world who at a minimum were able to reduce costs at a minimum by 50% on all levels, software, service, and maintenance.
The following table shows a simplified breakdown for a 20-Planner User scenario:
|Position||Cost (USD)||Unified Approach|
|Relational Data Warehouse / Centralized Data Model||Similar investment – Acterys offers automated data warehouse generation for many systems, respectively business user driven wizards that greatly facilitate the implementation for any source.|
|Acterys Unified Approach Software license cost (p.a.)||$10-$40k|
|Average Specialized Planning Solution Software (p.a.)||$30-$70k|
|Average Specialized Consolidation Software (p.a.)||$30-$70k|
|Consulting Initial (once off)||$140k (1:2 Software vs Consulting)||$20k (1:1 Software vs Consulting savings through existing knowledge in organisation and cheaper generic knowledge)|
|Ongoing External support p.a.||$20-30k outside specialist support||Business user controlled, existing internal resources|
|Total Year 1||$220-310k||$30-60k|