Using Multidimensional Concepts for Detecting Problematic Sub-KPIs in Analysis Systems

  • Alberto EstebanEmail author
  • Alejandro Maté
  • Juan Trujillo
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 10651)


Business Intelligence, and more recently Big Data, have been steadily gaining traction in the last decade. As globalization triggers the ability for small and medium enterprises to enter worldwide markets, monitoring business objectives and pinpointing problems has become more important than ever. Previous approaches have tackled the detection of particular problematic instances (commonly called Key Performance Indicators-KPIs), trying to search for the events that are driving companies to be far away from organization’s main goals. One of the key problems is that even though KPIs are positive, they are normally calculated from other sub-KPIs and therefore, it is crucial to find out which is the concrete sub-KPI that is negatively influencing the main KPI. Therefore, in this paper, we focus on a semi-automatic approach for finding the key sub-KPIs that have bad results for the company. This approach is checked on real data that are used to create a report showing potential weaknesses in order to help companies to find out which factors may affect concrete sub-KPIs. Our approach allows us to provide insights for decision makers and help them to determine the underlying problems for achieving a goal and thereby, aiding them with taking corrective actions.


KPI Monitoring Business Intelligence Reporting Business analysis 



This work has been partially funded by the Spanish Ministry of Economy and Competitiveness (MINECO/FEDER) under the Granted Project SEQUOIA-UA (Management requirements and methodology for Big Data analytics) (TIN2015–63502-C3-3-R). This work has been partially funded by the University of Alicante under a R&D grant for initiation to research (BOUA 28/06/2016).


  1. 1.
    Kucukaltan, B., Irani, Z., Aktas, E.: A decision support model for identification and prioritization of key performance indicators in the logistics industry. Comput. Hum. Behav. 65, 346–358 (2016)CrossRefGoogle Scholar
  2. 2.
    Jeusfeld, M.A., Thoun, S.: Key performance indicators in data warehouses. In: Zimányi, E., Abelló, A. (eds.) eBISS 2015. LNBIP, vol. 253, pp. 111–129. Springer, Cham (2016). Google Scholar
  3. 3.
    Dyson, R.G.: Strategic development and swot analysis at the university of warwick. Eur. J. Oper. Res. 152(3), 631–640 (2004)CrossRefzbMATHGoogle Scholar
  4. 4.
    Hill, T., Westbrook, R.: Swot analysis: it’s time for a product recall. Long Range Plann. 30(1), 46–52 (1997)CrossRefGoogle Scholar
  5. 5.
    Schoemaker, P.J., van der Heijden, C.A.: Integrating scenarios into strategic planning at royal dutch/shell. Plann. Rev. 20(3), 41–46 (1992)CrossRefGoogle Scholar
  6. 6.
    Kerzner, H.R.: Project Management Metrics, KPIs, and Dashboards: A Guide to Measuring and Monitoring Project Performance. Wiley, Hoboken (2011)CrossRefGoogle Scholar
  7. 7.
    Maté, A., Trujillo, J., Mylopoulos, J.: Stress testing strategic goals with SWOT analysis. In: Johannesson, P., Lee, M.L., Liddle, S.W., Opdahl, A.L., López, Ó.P. (eds.) ER 2015. LNCS, vol. 9381, pp. 65–78. Springer, Cham (2015). CrossRefGoogle Scholar
  8. 8.
    Sarawagi, S.: User-adaptive exploration of multidimensional data. VLDB 2000, 307–316 (2000)Google Scholar
  9. 9.
    Kaplan, R.S., Norton, D.P.: Putting the balanced scorecard to work. Perform. Measur. Manage. Apprais. Sourceb. 66, 17511 (1995)Google Scholar
  10. 10.
    Maté, A., Zoumpatianos, K., Palpanas, T., Trujillo, J., Mylopoulos, J., Koci, E.: A systematic approach for dynamic targeted monitoring of kpis. In: Proceedings of 24th Annual International Conference on Computer Science and Software Engineering, IBM Corp. pp. 192–206 (2014)Google Scholar

Copyright information

© Springer International Publishing AG 2017

Authors and Affiliations

  • Alberto Esteban
    • 1
    Email author
  • Alejandro Maté
    • 2
  • Juan Trujillo
    • 1
  1. 1.Software and Computing SystemsUniversity of AlicanteAlicanteSpain
  2. 2.Lucentia LabAlicanteSpain

Personalised recommendations