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.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.