SIGMA COMPUTING, INC.

Linking data sets, including receiving a selection of a first column of a first data set related to a second column of a second data set; in response to the selection, generating a query based on a relationship between the first column of the first data set and the second column of the second data set; and presenting a third data set based on a response to the query.

Generating a database query using a dimensional hierarchy within a graphical user interface including displaying a data set within a spreadsheet structure, wherein the data set comprises a plurality of columns; displaying a list structure comprising a first level and a second level; receiving a selection of a first column of the plurality of columns as a first key for the first level in the list structure; receiving a selection of a second column of the plurality of columns as a second key for the second level in the list structure; and in response to receiving the selection of the first column and receiving the selection of the second column and based on an order of the first key and the second key in the list structure, generating the database query defining a hierarchical relationship between the first column and the second column.

Top frequency worksheet filtering including sending a first request comprising a first search term; receiving, in response to the first request, a first plurality of distinct values having a greatest frequency in a data set and responsive to the first search term, wherein the first plurality of distinct values comprises a number of distinct values less than or equal to a size threshold; presenting the first plurality of distinct values; receiving a selection of a first value from the first plurality of distinct values; and filtering, based on the selected first value, a worksheet comprising a presentation of the data set.

Managing database queries using a deconstructed cloud database including receiving, by a communications manager of the deconstructed cloud database, a state specification from a client computing system; converting, by a query optimizer of the deconstructed cloud database, the state specification into a query plan comprising a database query targeting an offloaded execution engine; retrieving, by a dispatcher of the deconstructed cloud database, query results from the offloaded execution engine using the database query; and presenting, by the communications manager, the query results to the client computing system.

Accessing and organizing data sets directly from a data warehouse including receiving, by a data analyzer, a request from a service provider client instructing the data analyzer to retrieve a data set from a service provider data warehouse, wherein the service provider client is a client of a service provider, and wherein the service provider data warehouse stores data sets for the service provider; retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider; selecting, by the data analyzer, a worksheet template based on the service provider; organizing, by the data analyzer, the data set into a worksheet based on the worksheet template; and presenting, by the data analyzer to the service provider client, the worksheet comprising the data set.