A comparison of the usability of performing ad hoc querying on dimensionally modeled data versus operationally modeled data

Vujošević, Dušan; Kovačević, Ivana; Suknović, Milija; Lalic, Nenad

doi:10.1016/j.dss.2012.05.004

Cited by 8 publications

(10 citation statements)

References 45 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…At the individual level, the literature review shows that BI systems help improve individuals' decision-making performance [49,97,130] by enabling sensemaking in data exploration tasks [46,50,97,118], facilitating analysis of large volumes of data [136], and enriching knowledge [70,92,119]. Individual-level inhibitors also need to be addressed (e.g., role authorization) [11].…”

Section: Results Of Reviewed Bi Studies By Level Of Analysismentioning

confidence: 99%

Getting value from Business Intelligence systems: A review and research agenda

Trieu

2017

Decision Support Systems

219

155

View full text Add to dashboard Cite

Much of the research on Business Intelligence (BI) has examined the ability of BI systems to help organizations address challenges and opportunities. However, the literature is fragmented and lacks an overarching framework to integrate findings and systematically guide research. Moreover, researchers and practitioners continue to question the value of BI systems. This study reviews and synthesizes empirical Information System (IS) studies to learn what we know, how well we know, and what we need to know about the processes of organizations obtaining business value from BI systems. The study aims to identify which parts of the BI business value process have been studied and are still most in need of research, and to propose specific research questions for the future. The findings show that organizations appear to obtain value from BI systems according to the process suggested by Soh and Markus (1995), as a chain of necessary conditions from BI investments to BI assets to BI impacts to organizational performance; however, researchers have not sufficiently studied the probabilistic processes that link the necessary conditions together. Moreover, the research has not sufficiently covered all relevant levels of analysis, nor examined how the levels link up. Overall, the paper identified many opportunities for researchers to provide a more complete picture of how organizations can and do obtain value from BI.

show abstract

Section: Results Of Reviewed Bi Studies By Level Of Analysismentioning

confidence: 99%

Getting value from Business Intelligence systems: A review and research agenda

Trieu

2017

Decision Support Systems

219

155

View full text Add to dashboard Cite

show abstract

“…However, participants in previous experiments have recalled a greater number of correct entities and relationships from dimensional models, which suggests that star schema diagrams are easier to comprehend than operational entity-relationship diagrams (Corral et al, 2006). Individuals also had an easier time modifying diagrams (Schuff et al, 2005) and solving tasks using a dimensional view of data (Hänel and Felden, 2017;Vujošević et al, 2012).…”

Section: Learnabilitymentioning

confidence: 98%

“…Complex navigation should be avoided in order to reduce short-term memory load; a compact design that minimizes scrolling and jumping is also useful in information retrieval (Zabed, 2006). A seemingly less complex alternative to dimensionally modeled data are flat files (Hänel and Felden, 2017;Alpar and Schulz, 2016;Vujošević et al, 2012), which are frequently used by business analysts. A measurement of their usability showed, however, that flat files, i.e.…”

Section: Learnabilitymentioning

confidence: 99%

The learnability of the dimensional view of data and what to do with it

Vujošević

Kovačević

Vujosevic-Janicic

2019

AJIM

Self Cite

View full text Add to dashboard Cite

Purpose The purpose of this paper is to examine the usability of the dimensional view of data in the context of its presumed learnability. Design/methodology/approach In total, 303 participants were asked to solve 12 analytical problems in an experiment using the dimensional view of data for half of the problems and an operational view of data for the other half. Inferential statistics and structural equation modeling were performed with participants’ objective results and affective reactions. Findings Showing that the order of exposure to the two views of data impacts the overall usability of ad hoc querying, the study provided evidence for the learnability potential of the dimensional view of data. Furthermore, the study showed that affective reactions to the different views of data follow objective usability parameters in a way that can be explained using models from affective computing research. Practical implications The paper proposes a list of guidelines for use of the dimensional view of data in business analytics. Originality/value This study is the first to confirm the learnability of the dimensional view of data and the first to take a deeper look at affective reactions to an ad hoc business analytics solution. Also, it is one of few studies that examined the usability of different views of data directly on these views, rather than using paper representations of data models.

show abstract

“…BI's characteristics in action planning are connected primarily to data and information use. For example, BI is used for ad hoc querying (Vujošević et al, 2012), information gathering (Gao, 2013), information validation (Hsieh, 2011), information reviewing (Chung and Tseng, 2012), and use of data in different ways (Clark et al, 2007;Roussinov and Chau, 2008;Deng and Chi, 2012;Rubin and Rubin, 2013). Other BI characteristics for action planning help to develop scorecards (Petrini and Pozzebon, 2009), analyse risk (Hu et al, 2012) and evaluate action plans (Chen et al, 2012a).…”

Section: Micro Level Of Bimentioning

confidence: 99%

“…Those BI characteristics help a company to support change, competition, decisions or events (Li et al, 2008a;Petrini and Pozzebon, 2009;Perko et al, 2011;Işık et al, 2013). Hybrid measurements (HMS) use analytical processes, algorithms (Perko et al, 2011), surveys, web analysis (Zorrilla and García-Saiz, 2013), paper reports, ad hoc reports, OLAP (Bouakkaz et al, 2016), data mining, dashboards, KPIs, alerts, (Popovič et al, 2012) reports, dashboards and scorecards, ad hoc querying (Vujošević et al, 2012), financial databases (Cheng et al, 2009) or CRM (Phan and Vogel, 2010). BI is also characterised as a non-financial measurement tool, which supports a firm by using multi-dimensional and unstructured data (Gao andXu, 2009, Chaudhuri et al, 2011).…”

Section: Micro Level Of Bimentioning

confidence: 99%

Technology in its Context

Fischer

2017

IJBIDM

View full text Add to dashboard Cite

The purpose of the literature review is to identify characteristics, concepts, and theories of business intelligence (BI). The status quo of BI is based on the literature review, which covers 86 journal articles from the three areas of accounting, strategy, and information systems between 2006 and 2014. The review combines two established frameworks to illustrate new insights regarding the macro and micro levels of BI. The complementary combination of both levels produces a new lens that shows the conceptualisation and characteristics of BI in a holistic view. The result of the study shows that BI is used as a monolithic concept and static tool with technical control mechanisms. Another result implies that BI is in a phase of maturity, in which it fulfils an organisational purpose without considering its social context or ecosystem in which it occurs. The literature review contributes to the characterisation and theorisation of BI and shows that a company depend on both characteristics and the purpose for which BI is used.

show abstract

A comparison of the usability of performing ad hoc querying on dimensionally modeled data versus operationally modeled data

Cited by 8 publications

References 45 publications

Getting value from Business Intelligence systems: A review and research agenda

Getting value from Business Intelligence systems: A review and research agenda

The learnability of the dimensional view of data and what to do with it

Technology in its Context

Contact Info

Product

Resources

About