# US 2019/0171777 A1 · Modular data insight handling for user application data

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2019/0171777 A1
- Document ID: US20190171777A1
- Status: Published application
- Kind: A1
- Application number: 15/962,374
- Filed: 2018-04-25
- Published: 2019-06-06
- Earliest claimed: 2017-12-05
- Assignees: Microsoft Technology Licensing, LLC
- Applicants: Microsoft Technology Licensing, LLC
- Inventors: Ehab Sobhy Deraz; Charles David Ellis; Michael Joe Woolf; Matthew Willem Asplund; Mathew B. Olinger; Sameer Surendra Jagdale; Charles Strempler
- Web page: https://patentgrep.com/patent/US20190171777A1

## CPC

- G06F 16/9038: Presentation of query results
- G06F 9/54: Interprogram communication
- G06F 16/26: Visual data mining; Browsing structured data
- G06F 16/907: Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06N 20/00: Machine learning
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS

## 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.

## Claims

### Claim 1

A method of providing insight results in a productivity application, the method comprising:
receiving a dataset and a user query relating to the dataset;
processing the dataset to determine metadata that describes one or more properties of the dataset;
providing the dataset, the determined metadata, and the user query to one or more modular recommendation elements for processing into an insight result for the dataset, wherein the insight result indicates a result from data analysis directed to the query; and
transferring the insight result for use by the productivity application in displaying one or more insight objects based on the insight result.

### Claim 2 (depends on 1)

The method of claim 1, wherein a specific function is selected, from a plurality of functions, for processing a plurality of values of the dataset based on the specific function having a same property type assigned to it as a property type described in metadata for the plurality of values of the dataset.

### Claim 3 (depends on 2)

The method of claim 2, further comprising:
receiving an indication to provide information associated with one or more criteria utilized in generating the insight result for the dataset; and
causing, based on the received indication, a description of the specific function to be displayed.

### Claim 4 (depends on 1)

The method of claim 1, wherein the one or more properties comprise at least one of: one or more column headers associated with the dataset; one or more column footers associated with the dataset; and metadata associated with the dataset comprising a description of value property types associated with one or more values in the dataset.

### Claim 5

A system for providing dataset insights for a productivity application, the system comprising:
a memory for storing executable program code; and
one or more processors, functionally coupled to the memory, the one or more processors being responsive to computer-executable instructions contained in the program code and operative to:
receive an indication to generate an insight associated with a dataset;
analyze one or more properties associated with the dataset;
assign, based on analyzing the one or more properties, a category type to a plurality of values of the dataset;
generate an insight associated with the dataset, wherein the insight is generated by applying at least one function to a plurality of values of the dataset; and
cause the generated insight to be displayed in a user interface of the productivity application.

### Claim 6 (depends on 5)

The system of claim 5, wherein the applied function is selected from a plurality of functions, each of the plurality of functions being associated with one or more value category types, and wherein a function of the plurality of functions can be applied to a value that has a same category type assigned to it as a corresponding function.

### Claim 7 (depends on 5)

The system of claim 5, wherein the one or more properties comprise at least one of: one or more column headers associated with the dataset; one or more column footers associated with the dataset; and metadata associated with the dataset comprising a description of data in the dataset.

### Claim 8 (depends on 5)

The system of claim 5, wherein analyzing the one or more properties comprises identifying one or more patterns associated with a plurality of values in the dataset.

### Claim 9 (depends on 2)

The system of claim 2, wherein an insight type for the displayed insight is selected from one of: a graph associated with a plurality of values of the dataset; a chart associated with a plurality of values of the dataset; and a pivot table associated with a plurality of values of the dataset.

### Claim 10 (depends on 9)

The system of claim 9, wherein the insight type is selected based on one or more of: machine learning applied to historical productivity application data of a user account associated with the productivity application; a data type of the dataset; a user query to generate the insight; and metadata associated with the dataset.

### Claim 11 (depends on 5)

The system of claim 5, wherein the one or more processors are further responsive to the computer-executable instructions contained in the program code and operative to:
receive an indication to provide information associated with one or more criteria utilized in generating the insight; and
cause, based on the received indication, a description of one or more of the applied functions to be displayed in the user interface of the productivity application.

### Claim 12 (depends on 5)

The system of claim 5, wherein the one or more processors are further responsive to the computer-executable instructions contained in the program code and operative to:
assign a category type to a plurality of values in the dataset based on the analysis of the one or more properties of the dataset;
identify a second dataset associated with the assigned category type; and
utilize one or more values included in the second dataset in at least one of the applied functions.

### Claim 13 (depends on 12)

The system of claim 12, wherein the one or more processors are further responsive to the computer-executable instructions contained in the program code and operative to:
receive an indication to provide information associated with one or more criteria utilized in generating the insight; and
cause, based on the received indication, a description of the second dataset to be displayed in the user interface of the productivity application, wherein the description of the second dataset comprises one of: a location in the productivity application where the second dataset is located; a file where the second dataset is located; a remote storage location where the second dataset is located; and a web address where the second dataset is located.

### Claim 14 (depends on 13)

The system of claim 13, wherein the one or more processors are further responsive to the computer-executable instructions contained in the program code and operative to:
cause metadata associated with the dataset, and historical user data for the spreadsheet application to be cached;
receive an indication to generate a second insight associated with the dataset; and
cause the second insight to be displayed in a user interface of the productivity application, in an insight type specific to the cached metadata and the cached historical user data.

### Claim 15 (depends on 5)

The system of claim 5, wherein the one or more processors are further responsive to the computer-executable instructions contained in the program code and operative to:
receive a user input to modify a display property of the displayed insight;
identify a value of the dataset utilized in at least one of the applied functions that resulted in the display of the display property in the displayed insight;
determine a new value for the identified value that will result in modification of the display property when utilized in the at least one applied function; and
cause the new value to be displayed in the user interface of the productivity application.

### Claim 16 (depends on 15)

The system of claim 15, wherein the display property comprises one of: a size of a displayed metric for a category in a chart of the displayed insight; a color of a displayed metric for a category in a chart of the displayed insight; a size of a displayed metric for a category in a graph of the displayed insight; and a color of a displayed metric for a category in a graph of the displayed insight.

### Claim 17 (depends on 5)

The system of claim 5, wherein the one or more processors are further responsive to the computer-executable instructions contained in the program code and operative to:
receive a modification to a value in the dataset utilized in generating the insight;
re-apply at least one of the applied functions to the value based on the received modification; and
modify one or more display properties of the displayed insight in the user interface of the productivity application based on the result of the re-applied at least one function.

### Claim 18

A computer-readable storage device comprising executable instructions that, when executed by one or more processors, assists with providing dataset insights for a productivity application, the computer-readable storage device including instructions executable by the one or more processors for:
receiving a user query to generate an insight associated with a dataset;
causing, based on an assigned value category type associated with one or more values of the dataset, a plurality of insight display type categories selectable for generating insight results for the dataset to be displayed in a user interface of the productivity application;
receiving a selection of one of the insight display type categories; and
causing an insight result for the dataset corresponding to the selected insight display type category to be displayed in the user interface of the productivity application.

### Claim 19 (depends on 18)

The computer-readable storage device of claim 18, wherein the value category type associated with the one or more values of the dataset is assigned based on at least one of: data included in one or more column headers associated with the dataset; data included in one or more column footers associated with the dataset; and user-provided data that describes the one or more values of the dataset.

### Claim 20 (depends on 18)

The computer-readable storage device of claim 18, wherein the instructions are further executable by the one or more processors for:
receiving an API call-in from the productivity application for the insight; and
sending, based on the API call-in, the user query, and the assigned value category type associated with the one or more values of the dataset, the insight result to the productivity application in a standardized output for interpretation by a plurality of application types.
