Custom-branded analytic applications in a multi-tenant environment

• US 9,870,543 B2
• Filed: 10/11/2013
• Issued: 01/16/2018
• Est. Priority Date: 08/12/2013
• Status: Active Grant

• Current Assignee: GoodData Corporation
• Original Assignee: GoodData Corporation
• Inventors: {hacek over (S)}itina, Ji{hacek over (r)}, Svoboda, Zdenek, Valka, Ondrej, Sedlacek, Jakub, Kostal, Zdenek, Damarla, Chanakya C., Palan, Hubert, Plattner, Oliver H.
• Primary Examiner(s): Dickerson, Tiphany B
• Application Number:
  US14/051,469
• Publication Number:
  US 20150046204A1
• Time in Patent Office: 1,558 Days
• Field of Search: 705 729- 733, 705 738
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management

Abstract

A consolidated business intelligence platform provides customized business analytics for a plurality of customer databases, each associated with a corresponding plurality of customers. Responsive to a request from a user for a customized business intelligence interface, the system determines a customer of the plurality of customers with which the user is affiliated; accesses a set of customization parameters for the determined customer, the customization parameters including a set of data analytics parameters and a set of data display parameters; and identifies, from the plurality of customer databases, a customer database associated with the determined customer. The system analyzes a dataset from the identified customer database using the set of data analytics parameters, and then formats the analyzed dataset for display based on the set of data display parameters, thereby generating the customized business intelligence interface for transmission to the user.

Claims

1. A method for providing customized business analytics at a multi-tenant platform of a business intelligence system, the method comprising:

maintaining, at a datastore, a plurality of customer databases associated with a corresponding plurality of customers, wherein a customer is associated with a plurality of users;

maintaining the business intelligence system, the maintaining comprising, for each of the plurality of customers;

receiving a set of data analytics parameters for the customer, the set of data analytics parameters including one or more data analysis metrics, each data analysis metric having a metric definition specifying a measure of performance associated with a business of the customer; and

storing, the set of data analytics parameters for the customer;

receiving, by the multi-tenant platform, a first query associated with a first customer, from a first client device distinct from the business intelligence system;

responsive to receiving the first query;

accessing, by a processor of the multi-tenant platform of the business intelligence system, a first set of data analytics parameters for the first customer, the first set of data analytics parameters previously stored in the business intelligence system;

identifying, from the plurality of customer databases, a first customer database associated with the first customer;

generating, by the processor, a first customized query from the first query, the first customized query using the first set of data analytics parameters, the first set of data analytics parameters defining at least a first data analysis metric associated with the first customer, the first customized query configured to return a first dataset based on the metric definition of the first data analysis metric;

executing the first customized query using the first customer database to determine a first dataset based on the first data analysis metric;

formatting the first dataset for display, thereby generating a first user interface configured to visualize the first dataset based on the first data analysis metric; and

sending the first user interface to the first client device associated with the first customer;

receiving, by the multi-tenant platform, a second query associated with a second customer, from a second client device distinct from the business intelligence system, the second query identical to the first query; and

responsive to receiving the second query;

accessing, by the processor of the multi-tenant platform of the business intelligence system, a second set of data analytics parameters for the second customer, the second set of data analytics parameters previously stored at the business intelligence system;

identifying, from the plurality of customer databases, a second customer database associated with the second customer;

generating, by the processor, a second customized query from the second query, the second customized query using the second set of data analytics parameters, the second customized query being distinct from the first customized query, the second set of data analytics parameters defining at least a second data analysis metric associated with the second customer, the second customized query configured to return a second dataset based on the metric definition of the second data analysis metric;

executing the second customized query using the second customer database to determine a second dataset based on the second data analysis metric;

formatting the second dataset for display, thereby generating a second user interface configured to visualize the second dataset based on the second data analysis metric; and

sending the second user interface to the second client device associated with the second customer.

2. The method of claim 1, wherein:

each database of the plurality of customer databases includes data representative of corresponding source data stored at a corresponding customer location; and

maintaining, at the datastore, the plurality of customer databases associated with the corresponding plurality of customers comprises, for a particular database corresponding to a particular customer;

retrieving representations of source data from a customer location corresponding to the particular customer; and

periodically updating the particular database based on modifications to the source data stored at the customer location.

3. The method of claim 1, wherein the set of data analytics parameters for each given customer comprise one or more parameters, the one or more parameters custom-provided by the given customer and stored in the multi-tenant platform, the set of data analytics parameters defining an analytical framework for processing business intelligence data stored in a customer database associated with the given customer.

4. The method of claim 1, further comprising:

responsive to receiving the first query;

accessing, at the multi-tenant platform, a first set of data display parameters including one or more parameters, custom-provided by the first customer to control visual appearance of the first user interface, wherein the first dataset is formatted for display based on the first set of data display parameters; and

responsive to receiving the second query;

accessing, at the multi-tenant platform, a second set of data display parameters including one or more parameters, custom-provided by the second customer to control visual appearance of the second user interface,

wherein the second dataset is formatted for display based on the second set of data display parameters.

5. The method of claim 4, wherein the first and the second set of data display parameters define visual display properties of one or more of:

text content displayed on the first or the second user interface,

graphical content displayed on the first or the second user interface, or

metadata content associated with the first or the second user interface.

6. The method of claim 1, wherein the set of data analytics parameters for a given customer is custom-provided by the given customer to control functionality of customized business analytics and query-customization for the given customer.

7. The method of claim 1, further comprising, providing a given customer, modification rights to a set of data analytics parameters for the given customer, thereby enabling the given customer to modify one or more parameters of:

a set of data analytics parameters associated with the given customer and

a set of data display parameters associated with the given customer.

8. The method of claim 1, further comprising, upon sending a customized user interface for display to a user, disabling the user from modifying one or more parameters of a set of data analytics parameters, thereby assigning the user, view-only rights to one or more user interface elements of the customized user interface.

9. The method of claim 1, further comprising, upon sending a customized user interface for display to a user, providing the user, modification rights to one or more parameters of the set of data analytics parameters to modify one or more user interface elements of the first or the second user interface.

10. The method of claim 1, wherein the generated user interface comprises one or more of:

a dashboard, a business report, a goal tracking interface, a performance tracking interface, one or more charts for data visualization.

11. The method of claim 1, wherein processing a customized query for a given user using a corresponding customer database comprises:

analyzing data from the corresponding customer database by applying one or more of;

statistical, aggregation, or dimensional data analysis methodology to process data of the customer database to obtain statistical trends underlying the data.

12. The method of claim 1, wherein the multi-tenant platform of a business intelligence system comprises:

a unified metadata layer that stores a plurality of sets of customization parameters correspondingly for the plurality of customers, including a set of data analytics parameters and a set of data display parameters for each given customer;

an analytics engine that is configured to, responsive to receiving a query from a user associated with the given customer, generate a customized query corresponding to the given customer by modifying the received query using the previously stored set of data analytics parameters for the given customer; and

an application layer configured to, responsive to receiving a request from the user, generate a user interface for transmission to the user.

13. A business intelligence system, comprising:

one or more processors;

memory; and

one or more programs stored in the memory, the one or more programs comprising instructions that when executed by the one or more processors, cause the one or more processors to;

maintain, at a datastore, a plurality of customer databases associated with a corresponding plurality of customers, wherein a customer is associated with a plurality of users;

maintain the business intelligence system, the maintaining comprising, for each of the plurality of customers;

receiving a set of data analytics parameters for the customer, the set of data analytics parameters including one or more data analysis metrics, each data analysis metric having a metric definition specifying a measure of performance associated with a business of the customer; and

storing, the set of data analytics parameters for the customer; and

receive a first query associated with a first customer from a client device distinct from the business intelligence system;

responsive to receiving the first query;

access, a first set of data analytics parameters for the first customer, the first set of data analytics parameters previously stored in the business intelligence system;

identify, from the plurality of customer databases, a first customer database associated with the first customer;

generate a first customized query from the first query, the first customized query using the first set of data analytics parameters, the first set of data analytics parameters defining at least a first data analysis metric associated with the first customer, the first customized query configured to return a first dataset based on the metric definition of the first data analysis metric;

execute the first customized query using the first customer database to determine a first dataset based on the data analysis metric;

format the first dataset for display, thereby generate a first user interface configured to visualize the first dataset based on the first data analysis metric; and

send the first user interface to the first client device associated with the first customer;

receive a second query associated with a second customer, from a second client device distinct from the business intelligence system, the second query identical to the first query; and

responsive to receiving the second query;

access a second set of data analytics parameters for the second customer, the second set of data analytics parameters previously stored at the business intelligence system;

identify, from the plurality of customer databases, a second customer database associated with the second customer;

generate a second customized query from the second query, the second customized query using the second set of data analytics parameters, the second customized query being distinct from the first customized query, the second set of data analytics parameters defining at least a second data analysis metric associated with the second customer, the second customized query configured to return a second dataset based on the metric definition of the second data analysis metric;

execute the second customized query using the second customer database to determine a second dataset based on the second data analysis metric;

format the second dataset for display, thereby generating a second user interface configured to visualize the second dataset based on the second data analysis metric; and

send the second user interface to the second client device associated with the second customer.

14. A non-transitory computer-readable storage medium containing computer program code comprising instructions for:

maintaining, at a datastore, a plurality of customer databases associated with a corresponding plurality of customers, wherein a customer is associated with a plurality of users;

maintaining a business intelligence system, the maintaining comprising, for each of the plurality of customers;

receiving a set of data analytics parameters for the customer, the set of data analytics parameters including one or more data analysis metrics, each data analysis metric having a metric definition specifying a measure of performance associated with a business of the customer; and

storing, the set of data analytics parameters for the customer; and

receiving a first query associated with a first customer, from a first client device distinct from the business intelligence system;

responsive to receiving the first query;

accessing a first set of data analytics parameters for the first customer, the first set of data analytics parameters previously stored in the business intelligence system;

identifying, from the plurality of customer databases, a first customer database associated with the first customer;

generating a first customized query from the first query, the first customized query using the first set of data analytics parameters, the first set of data analytics parameters defining at least a first data analysis metric associated with the first customer, the first customized query configured to return a first dataset based on the metric definition of the first data analysis metric;

executing the first customized query using the first customer database to determine a first dataset based on the data analysis metric;

formatting the first dataset for, thereby generating a first user interface configured to visualize the first dataset based on the first data analysis metric; and

sending the first user interface to the first client device associated with the first customer;

receive a second query associated with a second customer, from a second client device distinct from the business intelligence system, the second query identical to the first query; and

responsive to receiving the second query;

accessing a second set of data analytics parameters for the second customer, the second set of data analytics parameters previously stored at the business intelligence system;

identifying, from the plurality of customer databases, a second customer database associated with the second customer;

generating a second customized query from the second query, the second customized query using the second set of data analytics parameters, the second customized query being distinct from the first customized query, the second set of data analytics parameters defining at least a second data analysis metric associated with the second customer, the second customized query configured to return a second dataset based on the metric definition of the second data analysis metric;

executing the second customized query using the second customer database to determine a second dataset based on the second data analysis metric;

formatting the second dataset for display, thereby generating a second user interface configured to visualize the second dataset based on the second data analysis metric; and

sending the second user interface to the second client device associated with the second customer.

15. The non-transitory computer-readable storage medium of claim 14, wherein:

each database of the plurality of customer databases includes data representative of corresponding source data stored at a corresponding customer location; and

maintaining, at the datastore, the plurality of customer databases associated with the corresponding plurality of customers comprises, for a particular database corresponding to a particular customer;

retrieving representations of source data from a customer location corresponding to the particular customer; and

periodically updating the particular database based on modifications to the source data stored at the customer location.

16. The non-transitory computer-readable storage medium of claim 14, further comprising:

responsive to receiving the first query;

accessing a first set of data display parameters including one or more parameters, custom-provided by the first customer to control visual appearance of the first user interface, wherein the first dataset is formatted for display based on the first set of data display parameters; and

responsive to receiving the second query;

accessing a second set of data display parameters including one or more parameters, custom-provided by the second customer to control visual appearance of the second user interface,

wherein the second dataset is formatted for display based on the second set of data display parameters.

17. The non-transitory computer-readable storage medium of claim 16, wherein the first and the second set of data display parameters define visual display properties of one or more of:

text content displayed on the first or the second user interface,

graphical content displayed on the first or the second user interface, or

metadata content associated with the first or the second user interface.

18. The non-transitory computer-readable storage medium of claim 14, further storing instructions for, providing a given customer, modification rights to a set of data analytics parameters for the given customer, thereby enabling the given customer to modify one or more parameters of:

a set of data analytics parameters associated with the given customer and

a set of data display parameters associated with the given customer.

19. The non-transitory computer-readable storage medium of claim 14, further storing instructions for, upon sending a customized user interface for display to a user, disabling the user from modifying one or more parameters of a set of data analytics parameters, thereby assigning the user, view-only rights to one or more user interface elements of the first or the second user interface.