Smart defaults for data visualizations

Patent metadata

Field	Value
Publication number	US-10452668-B2
Application number	US-201414462258-A
Country	US
Kind code	B2
Filing date	Aug 18, 2014
Priority date	Jul 21, 2010
Publication date	Oct 22, 2019
Grant date	Oct 22, 2019

Abstract

Smart defaults are provided for data visualization by creating a default layout of rows, columns, filters, and comparable elements that improve a user's experience in finding relevant answers within the data. Usage history of the ways that users look at data in various data sources, user specific information, and inferred relationships between a current user and similar users are used to determine elements relevant to visualization of data for a particular user such that the visualization process may be automatically started, and a relevance model is formed/adjusted based on these factors. Queries may also be executed in a preemptive fashion based on the relevance model and results provided to a requesting user more rapidly enhancing user experience with networked data visualization.

First claim

What is claimed is:

1. A method executed in a computing device to provide default layout elements for a data visualization user interface used for displaying retrieved data from a data source, the method comprising:
retrieving, via a processing circuit in the computing device, a usage history information associated with how data is viewed by a user, the usage history information including at least one from a set of: a query history, a peer usage, at least one defined data source, aggregation methods for past queries, and a date and time of past query requests;
storing the usage history information in a data store communicatively coupled to the computing device;
receive the usage history information as an input from the data store;
determining, via the processing circuit, layout elements relevant for the user for visualization of the data stored in the data source in the data visualization user interface based on the usage history information;
presenting the data visualization user interface employing the layout elements on a display coupled to the computing device; and
binding the layout elements to controls in the data visualization user interface by executing a visualization query against at least a portion of the data stored in the data source corresponding to the layout elements and presenting results of executing the visualization query in the data visualization user interface as the layout elements such that the data visualization user interface is presented employing the layout elements.

2. The method of claim 1 , further comprising:
detecting a user preference to maintain a portion of the usage history information as confidential.

3. The method of claim 2 , wherein the usage history information is maintained as confidential by:
associating the user with an anonymous user identifier;
providing a password protection for the portion; and
enabling the user to opt out of storing the portion.

4. The method of claim 2 , wherein a confidentiality of the portion includes a deletion operation of the usage history information of the user after a period set by the user.

5. The method of claim 1 , further comprising:
determining the layout elements based on a group that includes the user and a second user, wherein the group is determined based on a same organization associated with the user and the second user; and
presenting the data visualization user interface with the layout elements.

6. The method of claim 1 , further comprising:
adding a data connection to data retrieved from the data source and to return of endpoint values; and
constructing the visualization query using the endpoint values.

7. The method of claim 6 , further comprising
executing the visualization query against the data source.

8. The method of claim 1 , further comprising:
determining the layout elements based on the usage history of the user and a profile of the user, wherein the layout elements include one or more from a set of: a row of the usage history, a column of the usage history, a filter of the usage history, a measure of the usage history, and a formatting element of the usage history.

9. The method of claim 1 , further comprising:
presenting the data visualization user interface that employs the layout elements based on one from a set of: an order of relevance of the layout elements, a “popular” view of the layout elements, and a “users like you frequently look at” view of the layout elements.

10. A system to provide default layout elements for a data visualization user interface used for displaying retrieved data from a data source, the system comprising at least one processing circuit and a memory comprising:
a visualization module executed by a computing device, the visualization module configured to:
retrieve usage history information associated with how data is viewed by a user, the usage history information including at least one from a set of: a query history, a peer usage, at least one defined data source, aggregation methods for past queries, and a date and time of past query requests; and
store the usage history information in a data store communicatively coupled to the computing device; and

a relevance module executed by the computing device, the relevance module configured to:
receive the usage history information as an input from the data store;
determine, based on the usage history information, layout elements relevant for the user for visualization of data stored in the data source in the data visualization user interface;
present the data visualization user interface employing the layout elements on a display coupled to the computing device; and
binding the layout elements to controls in the data visualization user interface by executing a visualization query against at least a portion of the data stored in the data source and returning results of executing the visualization query to the visualization module for visualization of the layout elements such that the data visualization user interface is presented employing the layout elements.

11. The system of claim 10 , wherein the relevance module is further configured to:
add a data connection to data retrieved from the data source and to return of endpoint values; and
construct the visualization query using the endpoint values.

12. The system of claim 10 , wherein the relevance module is further configured to:
execute a parameterized relevance algorithm operative to receive the usage history information as the input, wherein the parameterized relevance algorithm includes one from a set of a neural network algorithm, a Bayesian tree algorithm, a collaborative filtering algorithm, a data mining algorithm, a machine learning algorithm, and a weighted majority algorithm.

13. The system of claim 10 , wherein the relevance module is further configured to:
detect a user preference to maintain a portion of the usage history information as confidential, wherein a confidentiality of the portion includes a deletion operation of the usage history information of the user after a period set by the user.

14. The system of claim 10 , wherein the relevance module is further configured to:
retrieve the usage history information from the data store to infer a relationship between the user and another user, wherein the relationship may include one or more of an organizational position of one or more of the user and the other user, an organizational profile of one or more of the user and the other user, and a query history of the usage history information of one or more of the user and the other user.

15. The system of claim 10 , wherein the visualization module and the relevance module are one from a set of: separate modules and an integrated part of a data processing application executed by the computing device, wherein the data processing application provides one or more of data retrieval, data analysis, and visualization services.

16. An article of manufacture comprising computer-readable storage having instructions stored thereon that when executed causes a computing device to provide default layout elements for a visualization of data in a data store, the instructions comprising:
retrieving usage history information associated with how data is viewed by a user of the data store, wherein the usage history information includes at least one from a set of: a query history, a peer usage, at least one defined data source, aggregation methods for past queries, and a date and time of past query requests;
storing the usage history information in the data store;
receiving the usage history information as an input from the data

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Heimendinger Scott
• Burns Jason
• Baumgartner Patrick J

Classifications

• G06F16/953

  Querying, e.g. by the use of web search engines · CPC title

• G06F16/2457

  with adaptation to user needs · CPC title

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F16/337

  Profile generation, learning or modification · CPC title

• H04L67/10

  in which an application is distributed across nodes in the network (software deployment G06F8/60; multiprogramming arrangements G06F9/46) · CPC title