A new generation of cloud data warehouses has changed the landscape of information technology. This shift brings large amounts of data and compute power closer to many users in enterprises. The ability to directly access the warehouse data, interactively analyze and explore it at scale can empower users , improving the effectiveness and efficiency of their decision making cycles as never before . However, existing tools for querying, analyzing , and exploring data in cloud warehouses are either limited in facilitating iterative ad-hoc analysis or difficult to use for the largest segment of enterprise users, who have limited time, interest, or skills for writing queries . Here we present Sigma Worksheet, a new system for interactively constructing data warehouse queries through visual direct manipulation. Sigma Worksheet enables users to perform powerful interactive ad-hoc visual data analysis without writing queries. To thisend, it combines the notion of a multidimensional data cube with an expressive, spreadsheet-like query construction interface , in order to ease the generation of otherwise complex queries. The Worksheet interface borrows successful features from electronic spreadsheets to support the large segment of users familiar with that environment. We demonstrate the usefulness of Sigma Worksheet through two in-depth use casesand report on user feedback that we elicit through a 100-person survey followed by a semi-structured interview study with 70 participants. We find that Sigma Worksheet provides an easier to use and learn interface for accessing, transforming, exploring, and analyzing data in cloud data warehouses, improving the visual data analysis and exploration experience for both expert and non-expert enterprise users. Our findings also suggest Sigma Worksheet can further improve user experience by providing guidance to users at various steps of data analysis.
The new generation of cloud data warehouses (CDWs) brings large amounts of data and compute power closer to users in enterprises. The ability to directly access the warehouse data, interactively analyze and explore it at scale can empower users to improve their decision making cycles . However, existing tools for analyzing data in CDWs are either limited in ad-hoc transformations or difficult to use for business users, the largest user segment in enterprises . Here we introduce Sigma Worksheet, a new interactive system that enables users to easily perform ad-hoc visual analysis of data in CDWs at scale. For this, Sigma Worksheet provides an accessible spreadsheet-like interface for data analysis through direct manipulation. Sigma Worksheet dynamically constructs matching SQL queries from user interactions on this familiar interface, building on the versatility and expressivity of SQL. Sigma Worksheet executes constructed queries directly on CDWs, leveraging the superior characteristics of the new generation CDWs, including scalability. To evaluate Sigma Worksheet, we first demonstrate its expressivity through two real life use cases, cohort analysis and sessionization. We then measure the performance of the Worksheet generated queries with a set of experiments using the TPC-H benchmark. Results show the performance of our compiled SQL queries is comparable to that of the reference queries of the benchmark. Finally, to assess the usefulness of Sigma Worksheet in deployment, we elicit feedback through a 100-person survey followed by a semi-structured interview study with 70 participants. We find that Sigma Worksheet is easier to use and learn , improving the productivity of users. Our findings also suggest Sigma Worksheet can further improve user experience by providing guidance to users at various steps of data analysis.
R
A
The
R
has changed the landscape of information technology. This shift
(CDWs)
D
many
R
, improving the effectiveness and efficiency of
to improve
D
as never before
R
querying, analyzing , and exploring data in cloud warehouses
analyzing data in CDWs
D
facilitating iterative
R
analysis
transformations
R
the largest segment of enterprise users, who have limited time, interest, or skills for writing queries
business users, the largest user segment in enterprises
R
present
introduce
R
system for interactively constructing data warehouse queries through visual direct manipulation. Sigma Worksheet
interactive system that
R
perform powerful interactive
easily perform
R
data analysis without writing queries. To thisend, it combines the notion of a multidimensional data cube with an expressive,
analysis of data in CDWs at scale. For this, Sigma Worksheet provides an accessible
R
query construction interface , in order to ease the generation of otherwise complex queries. The Worksheet interface borrows successful features from electronic spreadsheets to support the large segment of users familiar with that environment. We demonstrate the usefulness of Sigma Worksheet
interface for data analysis through direct manipulation. Sigma Worksheet dynamically constructs matching SQL queries from user interactions on this familiar interface, building on the versatility and expressivity of SQL. Sigma Worksheet executes constructed queries directly on CDWs, leveraging the superior characteristics of the new generation CDWs, including scalability. To evaluate Sigma Worksheet, we first demonstrate its expressivity through two real life use cases, cohort analysis and sessionization. We then measure the performance of the Worksheet generated queries with a set of experiments using the TPC-H benchmark. Results show the performance of our compiled SQL queries is comparable to that of the reference queries of the benchmark. Finally, to assess the usefulness of Sigma Worksheet in deployment, we elicit feedback
D
two in-depth use casesand report on user feedback that we elicit through
R
provides an
is
R
interface for accessing, transforming, exploring, and analyzing data in cloud data warehouses, improving the visual data analysis and exploration experience for both expert and non-expert enterprise
, improving the productivity of