Abstract: Systems, methods, and software for mobile data visualization frameworks are provided herein. An exemplary method includes, determining data insight candidates for presentation on the mobile computing device that describe analysis of a target dataset, determined based at least on data analysis preferences associated with processing one or more past datasets, and where each of the data insight candidates includes at least one insight object directed to the target dataset and is described by object metadata that indicates at least a processing lineage used to produce the at least one insight object. The method includes selecting a presentation detail level for displaying the data insight candidates on the mobile computing device based at least on properties of the mobile computing device, and generating one or more insight views for presentation on the mobile computing device.

Abstract: Systems, methods, and software for developing application usage information are provided herein. An exemplary method includes identifying data sources that relate to application usage activity of one or more users, determining activity signals related to at least data analysis by the one or more users from among the application usage activity, and applying the activity signals to a knowledge graphing service that infers data analysis preferences from among the activity signals. The method also includes providing ones of the data analysis preferences for use by data insight services that establish data insight objects visualizing target datasets based at least on the ones of the data analysis preferences.

Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for assisting with providing dataset insights associated with datasets are presented. A dataset and a query relating to the dataset may be received. The dataset may be processed to determine metadata that describes one or more properties of the dataset. The dataset, the determined metadata, and the user query may be provided to one or more modular recommendation elements for processing into an insight result that indicates a result from data analysis directed to the query. The insight result may be transferred in a portable format for use by the productivity application in displaying one or more insight objects based on the insight result.

Abstract: Systems, methods, and software for data visualization frameworks are provided herein. An exemplary method includes identifying a target dataset from which to determine data insights for presentation in an insight interface to the user application. The method includes determining data insight candidates for the target dataset based at least on usage modalities associated with processing one or more past datasets, and establishing content of the data insight candidates according to at least the target dataset and the usage modalities, where the content of each of the data insight candidates includes at least one insight object described by object metadata that indicates at least a processing lineage used to produce the at least one insight object.

Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for assisting with providing dataset insights associated with datasets are presented. A dataset and a query relating to the dataset may be received. The dataset may be processed to determine metadata that describes one or more properties of the dataset. The dataset, the determined metadata, and the user query may be provided to one or more modular recommendation elements for processing into an insight result that indicates a result from data analysis directed to the query. The insight result may be transferred in a portable format for use by the productivity application in displaying one or more insight objects based on the insight result.

Abstract: Systems, methods, and software for data visualization frameworks are provided herein. An exemplary method includes identifying a target dataset from which to determine data insights for presentation in an insight interface to the user application. The method includes determining data insight candidates for the target dataset based at least on usage modalities associated with processing one or more past datasets, and establishing content of the data insight candidates according to at least the target dataset and the usage modalities, where the content of each of the data insight candidates includes at least one insight object described by object metadata that indicates at least a processing lineage used to produce the at least one insight object.

Abstract: Systems, methods, and software for mobile data visualization frameworks are provided herein. An exemplary method includes, determining data insight candidates for presentation on the mobile computing device that describe analysis of a target dataset, determined based at least on data analysis preferences associated with processing one or more past datasets, and where each of the data insight candidates includes at least one insight object directed to the target dataset and is described by object metadata that indicates at least a processing lineage used to produce the at least one insight object. The method includes selecting a presentation detail level for displaying the data insight candidates on the mobile computing device based at least on properties of the mobile computing device, and generating one or more insight views for presentation on the mobile computing device.

Abstract: Systems, methods, and software for developing application usage information are provided herein. An exemplary method includes identifying data sources that relate to application usage activity of one or more users, determining activity signals related to at least data analysis by the one or more users from among the application usage activity, and applying the activity signals to a knowledge graphing service that infers data analysis preferences from among the activity signals. The method also includes providing ones of the data analysis preferences for use by data insight services that establish data insight objects visualizing target datasets based at least on the ones of the data analysis preferences.

Abstract: Systems, methods, and software for data visualization frameworks are provided herein. An exemplary method includes producing a data insight object for a target dataset, the data insight object comprising an object insight portion for presentation to a user and an object metadata portion that indicates at least a processing lineage used to produce the data insight object. The method includes providing the data insight object for presentation by an insight interface to the user application, and responsive to identifying a user action related to at least the target dataset, applying the processing lineage to produce at least one different data insight object for presentation by the insight interface.

Abstract: Embodiments are directed towards automatic provisional evaluation of utility program performance. Treatment facilities may be determined depending characteristics of a project. A performance profile corresponding to each treatment facility may be generated based on historical information corresponding to each treatment facility. Current usage information and current weather information for each treatment facility may be determined. Pre-treatment usage information that corresponds to each treatment facility may be determined based on the performance profile and the current usage information and the current weather information. A program evaluation report may be generated that includes program realization information. Program realization information may be based on an aggregation of project savings information that corresponds to the treatment facilities. Project savings information may be modified based on confidence weights.

Abstract: Embodiments are directed towards automatic provisional evaluation of utility program performance. Treatment facilities may be determined depending characteristics of a project. A performance profile corresponding to each treatment facility may be generated based on historical information corresponding to each treatment facility. Current usage information and current weather information for each treatment facility may be determined. Pre-treatment usage information that corresponds to each treatment facility may be determined based on the performance profile and the current usage information and the current weather information. A program evaluation report may be generated that includes program realization information. Program realization information may be based on an aggregation of project savings information that corresponds to the treatment facilities. Project savings information may be modified based on confidence weights.

Abstract: Embodiments are directed towards automatic provisional evaluation of utility program performance. Treatment facilities may be determined depending characteristics of a project. A performance profile corresponding to each treatment facility may be generated based on historical information corresponding to each treatment facility. Current usage information and current weather information for each treatment facility may be determined. Pre-treatment usage information that corresponds to each treatment facility may be determined based on the performance profile and the current usage information and the current weather information. A program evaluation report may be generated that includes program realization information. Program realization information may be based on an aggregation of project savings information that corresponds to the treatment facilities. Project savings information may be modified based on confidence weights.

Abstract: Technologies are described herein for the automated offloading of the execution of a user-defined function (“UDF”) to a high performance computing (“HPC”) system. When a request is received to calculate a workbook that references a UDF, a spreadsheet application program determines, based upon a tag set by the UDF, whether the UDF is safe for execution on the HPC system. If the UDF is safe for execution on the HPC system, the spreadsheet application program causes the UDF to be executed on the HPC system using a connector that communicates with the HPC system to cause the UDF to be executed thereupon. A container executing on the HPC system emulates interfaces provided by the spreadsheet application program and is utilized to execute the UDF. Results of the execution of the UDF on the HPC system may be returned asynchronously to the connector and to the spreadsheet application program.

Abstract: Technologies are described herein for the automated offloading of the execution of a user-defined function (“UDF”) to a high performance computing (“HPC”) system. When a request is received to calculate a workbook that references a UDF, a spreadsheet application program determines, based upon a tag set by the UDF, whether the UDF is safe for execution on the HPC system. If the UDF is safe for execution on the HPC system, the spreadsheet application program causes the UDF to be executed on the HPC system using a connector that communicates with the HPC system to cause the UDF to be executed thereupon. A container executing on the HPC system emulates interfaces provided by the spreadsheet application program and is utilized to execute the UDF. Results of the execution of the UDF on the HPC system may be returned asynchronously to the connector and to the spreadsheet application program.

Abstract: The present invention relates to a method of manipulating a software application and processing data stored in a data source. The method includes receiving a natural language input and analyze the natural language input to identify semantic information contained therein. Portions of the natural language input are associated with command objects and entity objects of a schema based on the semantic information and the natural language input. The method also includes rendering data from the data source in a table of columns and rows based on the schema and the associated portions of the natural language input.

Abstract: A system and method for automatically completing a formula of a spreadsheet application, calculator application, accounting application, business application or banking application. One aspect of the present invention is a computer-implemented method for automatically completing formulaic cell data. The computer-implemented method includes a step for substantiating an autocomplete process in response to a user input of formulaic cell data and aggregating autocomplete options based on the user input. Another aspect of the present invention includes displaying a dynamic list of autocomplete options when the user input is a trigger.