Table2Analysis: Modeling and Recommendation of Common Analysis Patterns for Multi-Dimensional Data

Authors

  • Mengyu Zhou Microsoft Research
  • Wang Tao Beijing University of Posts and Telecommunications
  • Ji Pengxin Beijing University of Posts and Telecommunications
  • Han Shi Microsoft Research
  • Zhang Dongmei Microsoft Research

DOI:

https://doi.org/10.1609/aaai.v34i01.5366

Abstract

Given a table of multi-dimensional data, what analyses would human create to extract information from it? From scientific exploration to business intelligence (BI), this is a key problem to solve towards automation of knowledge discovery and decision making. In this paper, we propose Table2Analysis to learn commonly conducted analysis patterns from large amount of (table, analysis) pairs, and recommend analyses for any given table even not seen before. Multi-dimensional data as input challenges existing model architectures and training techniques to fulfill the task. Based on deep Q-learning with heuristic search, Table2Analysis does table to sequence generation, with each sequence encoding an analysis. Table2Analysis has 0.78 recall at top-5 and 0.65 recall at top-1 in our evaluation against a large scale spreadsheet corpus on the PivotTable recommendation task.

Downloads

Published

2020-04-03

How to Cite

Zhou, M., Tao, W., Pengxin, J., Shi, H., & Dongmei, Z. (2020). Table2Analysis: Modeling and Recommendation of Common Analysis Patterns for Multi-Dimensional Data. Proceedings of the AAAI Conference on Artificial Intelligence, 34(01), 320-328. https://doi.org/10.1609/aaai.v34i01.5366

Issue

Section

AAAI Technical Track: AI and the Web