Building Business Intelligence & Analytics Capabilities - A Work System Perspective

2020 | International Conference on Information Systems | Citations: 1

Authors: Fadler, Martin; Legner, Christine

Abstract: Although enterprises believe that they can achieve a competitive advantage with ... Expand

Abstract: Although enterprises believe that they can achieve a competitive advantage with big data and AI, their analytics initiatives’ success rate still lags behind expectations. Existing research reveals that value creation with business intelligence and analytics (BI&A) is a complex process with multiple stages between the initial investments in BI&A resources and ultimately obtaining value. While prior research mostly focused on value generation mechanisms, we still lack a thorough understanding of how enterprises actually build BI&A capabilities. We explain the process in our research using work system theory (WST). Based on case studies and focus groups, we identify four prevalent BI&A capabilities: reporting, data exploration, analytics experimentation, and analytics production. For each identified BI&A capability, we derive patterns for BI&A resource orchestration, using the WST lens. Our findings complement the BI&A value creation research stream by providing insights into capability building. Collapse

Topics: analytical information system big data value creation organization structure digital platform

Methods: case study focus group mixed method company material qualitative interview

Theories: work systems theory

EM-OLAP Framework: Econometric Model Transformation Method for OLAP Design in Intelligence Systems

2018 | Business & Information Systems Engineering | Citations: 0

Authors: Tyrychtr, Jan; Pelikán, Martin; Štiková, Hana; Vrana, Ivan

Abstract: Econometrics is currently one of the most popular approaches to economic analysi ... Expand

Abstract: Econometrics is currently one of the most popular approaches to economic analysis. To better support advances in these areas as much as possible, it is necessary to apply econometric problems to econometric intelligent systems. The article describes an econometric OLAP framework that supports the design of a multidimensional database to secure econometric analyses to increase the effectiveness of the development of econometric intelligent systems. The first part of the article consists of the creation of formal rules for the new transformation of the econometric model (TEM) method for the econometric model transformation of multidimensional schema through the use of mathematical notation. In the proposed TEM method, the authors pay attention to the measurement of quality and understandability of the multidimensional schema, and compare the proposed method with the original TEM-CM method. In the second part of the article, the authors create a multidimensional database prototype according to the new TEM method and design an OLAP application for econometric analysis. Collapse

Topics: online analytical processing database system data warehouse digital dashboard data integration

Methods: econometric modeling design artifact design science experiment multidimensional modeling

Expediting analytical databases with columnar approach

2017 | Decision Support Systems | Citations: 1

Authors: Jukic, Nenad; Jukic, Boris; Sharma, Abhishek; Nestorov, Svetlozar; Korallus Arnold, Benjamin

Abstract: The approaches and discussions given in this paper offer applicable solutions fo ... Expand

Abstract: The approaches and discussions given in this paper offer applicable solutions for a number of scenarios taking place in the contemporary world that are dealing with performance issues in development and use of analytical databases for the support of both tactical and strategic decision making. The paper introduces a novel method for expediting the development and use of analytical databases that combines columnar database technology with an approach based on denormalizing data tables for analysis and decision support. This method improves the feasibility and quality of tactical decision making by making critical information more readily available. It also improves the quality of longer term strategic decision making by widening the range of feasible queries against the vast amounts of available information. The advantages include the improvements in the performance of the ETL process (the most common time-consuming bottleneck in most implementations of data warehousing for quality decision support) and in the performance of the individual analytical queries. These improvements in the critical decision support infrastructure are achieved without resulting in insurmountable storage-size increase requirements. The efficiencies and advantages of the introduced approach are illustrated by showing the application in two relevant real-world cases. Collapse

Topics: database system extract transform load process data warehouse decision support decision making

Methods: computational algorithm experiment multidimensional modeling design science simulation

Dimensional modeling: Identification, classification, and evaluation of patterns

2008 | Decision Support Systems | Citations: 7

Authors: Jones, Mary Elizabeth “M. E. ”; Song, Il-Yeol

Abstract: Software design is a complex activity. A successful designer requires knowledge ... Expand

Abstract: Software design is a complex activity. A successful designer requires knowledge and training in specific design techniques combined with practical experience. Designing a dimensional model embodies this challenge. This paper presents Dimensional Design Patterns (DDPs) and their application to the design of dimensional models. We describe a metamodel of the DDPs and show their integration into Kimball's dimensional modeling design process so they can be applied to design problems using a known practice. By providing a metamodel and a method for DDP use, we combine theory and a practical design technique with the goal of increasing the efficiency and effectiveness of the software designer. The experimental results show that the classroom use of DDPs increase the effectiveness by 25% and efficiency by 9% for students in designing dimensional models. This research shows that DDPs could be an effective tool not only for teaching a dimensional model in academia, but also for designing dimensional models in an industry setting. Collapse

Topics: data warehouse

Methods: experimental group experiment design pattern case study parametric test