A Data Warehouse Model for Business Processes Data Analytics

Business Process Management and Business Intelligence initiatives are commonly seen as separated organizational projects, suffering from lack of coordination, leading to a poor alignment between strategic management and operational business processes exec

  • PDF / 1,845,743 Bytes
  • 16 Pages / 439.37 x 666.142 pts Page_size
  • 33 Downloads / 208 Views

DOWNLOAD

REPORT


Abstract. Business Process Management and Business Intelligence initiatives are commonly seen as separated organizational projects, suffering from lack of coordination, leading to a poor alignment between strategic management and operational business processes execution. Researchers and professionals of information systems have recognized that business processes are the key for identifying the user needs for developing the software that supports those needs. In this case, a process-driven approach could be used to obtain a Data Warehouse model for the Business Intelligence supporting software. This paper presents a process-based approach for identifying an analytical data model using as input a set of interrelated business processes, modeled with Business Process Model and Notation version 2.0, and the corresponding operational data model. The proposed approach ensures the identification of an analytical data model for a Data Warehouse repository, integrating dimensions, facts, relationships and measures, providing useful data analytics perspectives of the data under analysis. Keywords: Analytical data model  Business intelligence  Business process management  Business process model and notation  Data warehousing  Operational data model

1 Introduction In recent years, more and more organizations are concerned about processes and how to manage them, which means that they started Business Process Management (BPM) initiatives, related with designing, enacting, managing, and analyzing operational business processes [1]. Moreover, organizations need to know and understand how the business is evolving, which led them moving towards Business Intelligence (BI) initiatives. BI has become a strategic initiative and is recognized as essential in driving business effectiveness and innovation [2]. A key component in a BI system is the Data Warehouse (DW) that supports the integration, storage, processing and analysis of the relevant data, reason why this paper is focused in the data model of this repository, in order to make available a physical data model that can support On-Line Analytical Processing (OLAP), a foundation for delivering the information needed for the decision making processes, providing autonomy and flexibility to users in browsing and analyzing data. © Springer International Publishing Switzerland 2016 O. Gervasi et al. (Eds.): ICCSA 2016, Part V, LNCS 9790, pp. 241–256, 2016. DOI: 10.1007/978-3-319-42092-9_19

242

M.Y. Santos and J. Oliveira e Sá

BPM and BI initiatives are commonly viewed as separate organizational information systems projects, suffering from lack of coordination, leading to a poor alignment between strategic management and operational business process execution [3]. Researchers and professionals in information systems have recognized that understanding the business processes is the key for identifying the user needs of the software systems that will support those needs [4]. As a consequence, researchers suggest a process-driven approach to obtain a DW model [5–7] that can support a BI