{'fraction_non_alphanumeric': 0.01407035175879397, 'fraction_numerical': 0.0, 'mean_word_length': 4.824561403508772, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
An experimental evaluation of an alternative to the pivot table for ad hoc access to OLAP data

This paper examines the usability of the orthodox interface to access business intelligence data held in OLAPbased systems – the pivot table. An alternative to the pivot table is described, based on Erik Thomsen’s simple diagramming technique for designing OLAP data structures. That interface is compared to the pivot table in a laboratory-based experiment. The results show that the alternative interface is a better interface to use for ad hoc access to OLAP data. The results for the subjects using the pivot table are very poor, with nearly a third of them being unable to successfully complete any of three simple analysis tasks. These results have important implications, as many systems and software tools are now based on the pivot table interface. The pivot table could be too difficult for most users to use, limiting the success of business intelligence systems based on OLAP technology.