Comparative Analysis of the Main Business Intelligence Solutions

Nowadays, Business Intelligence solutions are the main tools for analyzing and monitoring the company’s performance at any organizational level. This paper presents a comparative analysis of the most powerful Business Intelligence solutions using a set of technical features such as infrastructure of the platform, development facilities, complex analysis tools, interactive dashboards and scorecards, mobile integration and complex implementation of performance management methodologies.


Introduction
Performance management is a relatively new concept, but "the word performance is widely used in all fields of management.In the management control area, terms such as performance measurement (Euske, Lebas and McNair, 1993), evaluation, or appraisal (e.g.Bruns, 1992) is used.Despite the frequency of use of the word, its precise meaning is rarely explicitly defined by authors even when the main focus of the article or of the book is performance.(e.g.Baird, 1986;Richard, 1989).Often, performance is identified or equated with effectiveness and efficiency (e.g.Neely, Gregory, and Platts, 1995;Corvellec, 1994).A publication of the French Ministry of Industry equated performance with lean production, competitiveness, cost reduction, value and job creation, growth, and long-term survival of enterprises.In short, performance is one of those "suitcase words" (Bourguignon, 1995) in which everyone places the concepts that suit them, letting the context take care of the definition" [1].Performance can be expressed as a set of complementary indicators that describes the process by which certain results are achieved.Also performance can be defined as a dynamic causal model that describes how certain actions affect future results.Performance is closely related to decision making because performance has no intrinsic value, it exists only when an individual or more use it to make decisions.If the description of perfor-mance has no impact on a system or organization then the performance has no value.Also, the description of performance is relative to the perspective from which analyzes, it can be a accounting, operational or strategic perspective.Performance management includes activities that ensure the fulfillment of targets in an efficient and effective way.These activities are focused on achieving performance of an organization, a department, employees or even some manufacturing processes of a product or a service.Another definition of performance management extracted from a dictionary of management considers that performance is "a process by which organizations align their resources, systems and employees to strategic objectives and priorities."[2] This approach is typical for strategy-based management.

Performance Management
The goal of performance management is to ensure the fulfillment of the objectives set by the organization whether they are at strategic, operational or individual level.In order to achieve this goal must be followed a basic set of steps which are valid regardless of the implementation level: organization, subsystems, processes and so on.Some of these activities includes: [3] a. reviewing organizational goals and their correlation with performance units; b. elaborate the desired results; DOI: 10.12948/issn14531305/17.2.2013.12c. ensure the existence of correlation between the results on a certain domain and the results of the organization; d. prioritize the domain's desired results; e. finding a first level of evaluating the results and identifying the achieved level; f. identifying more specific measures for the first level of evaluation, if it is necessary; g. define standards for evaluating the results; h.create a performance plan that includes the expectations, measures and standards; i. create a performance review.The instruments of performance management need to be used by an organization, department, team or person in a way that the performance achieved to be developed and improved.There is no formula for designing and developing the instruments of performance management to ensure successful implementation and results.However, there are some factors [4] that influence the success: a. defining the position and the priorities in performance management; b. selecting an instrument that is correlated with the structure, culture and strategy of the organization, also the instrument must consolidate the strategy regarding performance and future directions of the company; c. each instrument has a significant role in communication within the organization.In the article "Rediscovering performance management: systems, learning and integration" performance management "has been divided into three levels: strategic, operational and individual performance management".[5] Individual performance management is an integrated system for improving the performance of employees at all levels and requires the definition of a performance plan that leads employees to achieve desired results but also that leads the corporation to achieve their objectives.An important feature is that performance can be measured.For this level exists different ways of gathering information and also there are certain indicators that synthesize information and expose it in an aggregate manner for an easier way of tracking the fulfillment of the objectives.Some of these indicators include: training days per employee, cost on training, number of complains, actual time taken to fill a position, etc.There are numerous indicators and they can be divided into many categories like: workforce planning, equal employment opportunities or recruitment."Performance management at operational level is linked to operational management, as its focus is the achievement of departmental or group objectives.Although it is aligned with corporate strategy, its focus is more functional.Scorecards and Dashboards are some of the key tools used."[5] Operational management is strongly related to accounting, because the operational performance is evaluated using efficiency and effectiveness and the easiest modality to do this is by using financial indicators like solvability, liquidity, profitability or other financial ratios."The rise of business intelligence software products over the last ten years had a profound impact on how companies manage their operational performance.Enterprise resource planning software (SAP, Oracle, etc.), combined with business intelligence software (Business Objects, Hyperion, Cognos, etc.) enabled companies to reach new levels of data integration, by making the data gathering and reporting process more streamlined."[5] Strategic performance management is the highest level of performance management.It focuses on the organizational level objectives.The most significant processes are related to organizational strategy, how to establish it and how to execute in order to have conclusive results.Some popular methodologies for this type of performance management include: Balanced Scorecards, Performance Prism, Baldrige Award, and European Foundation for Quality Management Excellence Model (EFQM).[5]

Performance Management and Business Intelligence Tools
There is a strong correlation between software programs for performance management and improved business and organizational results.Direct benefits of using these systems DOI: 10.12948/issn14531305/17.2.2013.12are:  increase sales, reduce costs, reduce delaying of the projects;  improving learning and development;  facilitate and optimize the decision making process;  facilitate communication and collaboration.Business Intelligence concept involves raw data that needs to be condensed from different data sources and then transformed in information.Performance Management concept uses this information and transpose it into an intuitive decision making format."To differentiate BI from PM, performance management can be viewed as deploying the power of BI, but the two are inseparable.Think of PM as an application of BI.PM adds context and direction for BI."[6] Business Intelligence gives companies the ability to access, analyze and use their data to make business decisions.This system is used both for daily operational activities and long-term strategic decisions.There are two areas of interest where BI is necessary: Business planning and Business execution.Business planning includes objectives such as increase revenue or reduces costs.Performance Management supports Business Intelligence in providing special dashboards that highlights how the company's performance align with business goals and provides actionable metrics in order to guide the company toward performance.Business execution refers to tactical and operational activities.The difference between the two is time.If tactical refers to business activities over a certain period of time, days, weeks, operational refers to daily business activities.Table 1 "compares traditional BI with BI used for BPM.It demonstrates how BPM forms the underpinnings for many of the BI developments we have outlined.Specifically, BPM helps BI cause operational decision making to become more proactive and timely, and support a wide range of business users."[7]. integration, which deals with collaborating data,  information delivery, where reporting is a major aspect and  analysis, which involves predictive mod-eling and processing.[8] This is this year's edition "Magic Quadrant" that presents the current state of the BI solutions market.EPM is a complete solution for monitoring, analyzing and improving business performance using KPIs.These two solutions must be integrated and requires material and human resources.weights that reflect the importance of each category, as in Table 3.The table shows that the platform with the highest score is MicroStrategy 9.3.1 with a score of 88.33.This means that most of this platform's functionalities are provided with an average range of options and customization tools.Also, the following platforms, SAS Enterprise Intelligence and Oracle BI Foundation Suite, provide the same characteristics as the first placed.Platforms that have scores between 50 and 75 are characterized by an average range of features offered that need to be customized using programming tools.Thus, companies that implement these solutions will have to invest in financial and human capital for the implementation of these platforms or the company will bear the cost of implementation provided by the vendor.

Fig. 1 .
Fig. 1.Magic Quadrant for Business Intelligence and Analytics Platforms

Table 2 .
Scores for Business Intelligence Platforms Infrastructure & Development: On this category the platform with the highest average score is MicroStrategy 9.3.1.Its integrated Intelligence Server supports "the full range of BI applications -from workgroup and departmental, to enterprise-wide BIthrough a unified metadata and a single inte-grated server running on Windows®, UNIX®, or Linux®."[9]The platforms with the lowest score are Microsoft and QlikView.Microsoft has two independent products for fulfilling the Business Intelligence architecture: SQL Server and SharePoint.

Table 3 .
Global score weights

Table 4 .
Global Scores