Catalogue Search | MBRL
Search Results Heading
Explore the vast range of titles available.
MBRLSearchResults
-
DisciplineDiscipline
-
Is Peer ReviewedIs Peer Reviewed
-
Item TypeItem Type
-
SubjectSubject
-
YearFrom:-To:
-
More FiltersMore FiltersSourceLanguage
Done
Filters
Reset
22
result(s) for
"Seiden, Max"
Sort by:
Sigma Workbook: A Spreadsheet for Cloud Data Warehouses
by
Woollen, Rob
,
Seiden, Max
,
Gale, James
in
Data analysis
,
Data warehouses
,
Interactive systems
2022
Cloud data warehouses (CDWs) bring large-scale data and compute power closer to users in enterprises. However, existing tools for analyzing data in CDWs are either limited in ad-hoc transformations or difficult to use for business users. Here we introduce Sigma Workbook, a new interactive system that enables business users to easily perform a visual analysis of data in CDWs at scale. For this, Sigma Workbook provides an accessible spreadsheet-like interface for analysis through direct manipulation. Sigma Workbook dynamically constructs matching SQL queries from user interactions, building on the versatility and expressivity of SQL. Constructed queries are directly executed on CDWs, leveraging the superior characteristics of the new generation CDWs, including scalability. We demonstrate Sigma Workbook through 3 real-life use cases -- cohort analysis, sessionization, and data augmentation -- and underline Workbook's ease of use, scalability, and expressivity.
Sigma Worksheet: Interactive Construction of OLAP Queries
by
Atwood, Gretchen
,
Woollen, Rob
,
Seiden, Max
in
Cloud computing
,
Data analysis
,
Data warehouses
2021
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.
Opening up
1987
Toronto ONT -- Re Canada Club Votes To Admit Women (Sept. 16): Now that the men-only rule is...
Newspaper Article
Hooray for bi-culturalism
1983
At the same time as Toronto celebrates Francophone Week, why not promote...
Newspaper Article
Maybe a Ford will be a way out of Poverty Trap
1981
Although a thunderbird may not be in [Christine Dunn]'s immediate future, I wish her at least the comfort of a compact Ford as she works toward reaching the top. [H. Max Seiden] Downsview, Ont.
Newspaper Article
Lawyers
1979
Lawyers are a free-governing society (Lawyers Reject Proposed Government Scrutiny - June 2).
Newspaper Article