Systems and methods for interest-driven data visualization systems utilized in interest-driven business intelligence systems

• US 9,824,127 B2
• Filed: 03/08/2013
• Issued: 11/21/2017
• Est. Priority Date: 10/22/2012
• Status: Active Grant

• Current Assignee: Workday Incorporated
• Original Assignee: Workday Incorporated
• Inventors: Prabhu, Prithvi, Werther, Benjamin Mark, Beyer, Kevin Scott, Eshleman, John Glenn, Mulholland, James
• Primary Examiner(s): Mobin, Hasanul
• Application Number:
  US13/791,028
• Publication Number:
  US 20140114970A1
• Time in Patent Office: 1,719 Days
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

Systems and methods for interest-driven data visualization systems in accordance with embodiments of the invention are illustrated. In one embodiment, an interest-driven data visualization system includes a processor, a memory connected configured to store an interest-driven data visualization application, and metadata storage, wherein the interest-driven data visualization application configures the processor to define reporting data requirements, generate data retrieval job data based on the reporting data requirements, transmit the data retrieval job data, receive aggregate data, create at least one piece of reporting data using the received aggregate data and the reporting data requirements, associate visualization metadata with the reporting data describing the visual appearance of the at least one piece of reporting data, and generate a report using the reporting data requirements and the visualization metadata.

Claims

1. An interest-driven data visualization system, comprising:

a processor;

a memory connected to the processor and storing an interest-driven data visualization application; and

metadata storage storing data description metadata describing raw data and aggregate data available to an interest-driven business intelligence system, wherein aggregate data is generated from raw data obtained by the interest-driven business intelligence system using an interest-driven data pipeline, wherein the interest-driven data pipeline is configured to load data of interest into the memory based on a desired consumption of the data of interest;

wherein the interest-driven data visualization application directs the processor to;

define reporting data requirements, wherein the reporting data requirements comprise at least one piece of reporting data metadata;

generate data retrieval job data from the at least one piece of reporting data metadata in the reporting data requirements based on the data description metadata in the metadata storage;

transmit the data retrieval job data to an interest-driven business intelligence system;

receive aggregate data that satisfies the data retrieval job data from the interest-driven business intelligence system, the aggregate data including aggregate data metadata, wherein the aggregate data metadata includes time estimation data describing a delay associated with generating supplemental aggregate data using the raw data that is generated based on time taken to generate at least a portion of the aggregated data;

create at least one piece of reporting data using the aggregate data that satisfies the retrieval job data, the data description metadata in the metadata storage, and the at least one piece of reporting data metadata from the reporting data requirements;

associate visualization metadata with the at least one piece of reporting data, wherein the visualization metadata describes a visual appearance of the at least one piece of reporting data, and wherein the visualization metadata is automatically generated based upon the at least one piece of reporting data and the reporting data requirements using the interest-driven data visualization system, the visualization metadata comprising a portable visualization; and

generate a report using the at least one piece of reporting data based on the reporting data requirements and the visualization metadata, wherein the generated report is configured to be displayed using a display device.

2. The system of claim 1, wherein the interest-driven data visualization application directs the processor to include an indication of the delay associated with generating the supplemental aggregate data in the generated report that is based on the received aggregate data metadata for the aggregate data that satisfies the retrieval job data in the generated report.

3. The system of claim 1, wherein the interest-driven data visualization application directs the processor to:

generate supplemental data retrieval job data based on the data retrieval job data and the received aggregate data;

transmit the supplemental data retrieval job data to the interest-driven business intelligence system;

receive supplemental aggregate data that satisfies the supplemental retrieval job data from the interest-driven business intelligence system;

update at least one piece of the at least one piece of reporting data using the supplemental aggregate data that satisfies the supplemental retrieval job data, the data description metadata, and the reporting data metadata; and

update the report using updated reporting data.

4. The system of claim 3, wherein the interest-driven data visualization application directs the processor to:

associate an alert with the supplemental data retrieval job data, wherein the alert comprises an action to be performed in response to receiving the supplemental aggregate data the satisfies the supplemental retrieval job data; and

perform the action of the alert when the supplemental aggregate data is received.

5. The system of claim 1, wherein the interest-driven data visualization application directs the processor to:

capture a visualization snapshot using the generated report, wherein the visualization snapshot includes a portion of the reporting data, the reporting data requirements, and the visualization metadata; and

store the visualization snapshot within the memory.

6. The system of claim 5, wherein the interest-driven data visualization application directs the processor to transmit the visualization snapshot to a remote system separate from the interest-driven data visualization system, wherein the remote system displays the visualization snapshot without communicating with the interest-driven business intelligence system.

7. The system of claim 1, wherein the interest-driven data visualization application directs the processor to:

determine second system data description metadata using a second interest-driven business intelligence system, wherein the second interest-driven business intelligence system is separate from the interest-driven business intelligence system and the second system data description metadata describes new aggregate data available via the second interest-driven business intelligence system;

create replacement reporting data using the second system data description metadata and the at least one piece of reporting data metadata from the reporting requirements;

determine a mapping between a portion of the replacement reporting data and the visualization metadata based on the reporting data requirements and the second system data description metadata; and

generate a replacement report using the replacement reporting data and the second system data description metadata.

8. A method for creating interest-driven data visualizations, comprising:

storing data description metadata describing raw data and aggregate data available to an interest-driven business intelligence system in a metadata storage that is accessible by an interest-driven visualization system, wherein aggregate data is generated from raw data obtained using an interest-driven data pipeline, wherein the interest-driven data pipeline is configured to load data of interest into a memory based on a desired consumption of the data of interest;

defining reporting data requirements using the interest-driven data visualization system, wherein the reporting data requirements comprise at least one piece of reporting data metadata and the interest-driven data visualization system comprises a processor and a memory connected to the processor;

generating data retrieval job data based on the at least one piece of reporting data metadata in the reporting data requirements and the data description metadata from the metadata storage using the interest-driven data visualization system;

transmitting the data retrieval job data to the interest-driven business intelligence system using the interest-driven data visualization system;

receiving aggregate data that satisfies the data retrieval job data from the interest-driven business intelligence system using the interest-driven data visualization system, the aggregate data including aggregate data metadata, wherein the aggregate data metadata includes time estimation data describing a delay associated with generating supplemental aggregate data using the raw data that is generated based on time taken to generate at least a portion of the aggregated data;

creating at least one piece of reporting data based on the received aggregate data that satisfies the data retrieval job data, the data description metadata from the metadata storage, and the at least one piece of reporting data metadata from the reporting requirements using the interest-driven data visualization system;

associating visualization metadata with the at least one piece of reporting data using the interest-driven data visualization system, wherein the visualization metadata describes a visual appearance of the at least one piece of reporting data, and wherein the visualization metadata is automatically generated based upon the at least one piece of reporting data and the reporting data requirements using the interest-driven data visualization system, the visualization metadata comprising a portable visualization; and

generating a report based on the at least one piece of reporting data, the reporting data requirements, and the visualization metadata using the interest-driven data visualization system.

9. The method of claim 8, further comprising including an indication of the delay associated with generating the supplemental aggregate data in the generated report that is based on the received aggregate data metadata for the aggregate data that satisfies the retrieval job data in the generated report.

10. The method of claim 8, further comprising:

generating supplemental data retrieval job data based on the data retrieval job data and the received aggregate data using the interest-driven data visualization system;

transmitting the supplemental data retrieval job data to the interest-driven business intelligence system using the interest-driven data visualization system;

receiving supplemental aggregate data that satisfies the supplemental retrieval job data from the interest-driven business intelligence system using the interest-driven data visualization system;

updating the at least one piece of reporting data based on the supplemental aggregate data that satisfies the supplemental retrieval job data, the data description metadata, and the reporting data metadata using the interest-driven data visualization system; and

updating the report based on updated reporting data using the interest-driven data visualization system.

11. The method of claim 10, further comprising:

associating an alert with the supplemental data retrieval job data using the interest-driven data visualization system, wherein the alert comprises an action to be performed in response to receiving the supplemental aggregate data the satisfies the supplemental retrieval job data; and

performing the action associated with the alert using the interest-driven data visualization system when the supplemental aggregate data is received.

12. The method of claim 8, furthering comprising:

capturing a visualization snapshot based the generated report using the interest-driven data visualization system, wherein the visualization snapshot includes a portion of the reporting data, the reporting data requirements, and the visualization data metadata; and

storing the visualization snapshot using the interest-driven data visualization system.

13. The method of claim 12, further comprising transmitting the visualization snapshot to a remote system separate from the interest-driven data visualization system using the interest-driven data visualization system, wherein the remote system is configured to display the visualization snapshot without communicating with the interest-driven business intelligence system.

14. The method of claim 8, further comprising:

determining second system data description metadata using a second interest-driven business intelligence system and the interest-driven data visualization system, wherein the second interest-driven business intelligence system is separate from the interest-driven business intelligence system and the second system data description metadata describes new aggregate data available via the second interest-driven business intelligence system;

creating replacement reporting data based on the second system data description metadata using the interest-driven data visualization system;

determining a mapping between a portion of the replacement reporting data and the visualization metadata based on the reporting data requirements and the second system data description metadata using the interest-driven data visualization system; and

generating a replacement report based on the replacement reporting data and the second system data description metadata using the interest-driven data visualization system.