MULTIPLE-CLIENT CENTRALLY-HOSTED DATA WAREHOUSE AND TREND SYSTEM

• US 20110167035A1
• Filed: 12/30/2010
• Published: 07/07/2011
• Est. Priority Date: 01/05/2010
• Status: Abandoned Application

• Current Assignee: Colleen Rita Cutler, Jacquilyn Debra Parker, Susan Kay Kesel
• Original Assignee: Colleen Rita Cutler, Jacquilyn Debra Parker, Susan Kay Kesel
• Inventors: Cutler, Colleen Rita, Parker, Jacquilyn Debra, Kesel, Susan Kay
• Application Number:
  US12/982,619
• Publication Number:
  US 20110167035A1
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A system for analyzing data for an industry may include a user that extracts source data from source systems, transforms the source data into key metrics data for a given time period, and loads the key metrics data into a file extract, a data warehouse including data tables that are customized for the industry, a web portal for accepting input of data within the file extract related to the industry, a transformation logic for mapping the data to data elements of one or more of the data tables, and a graphical dashboard that presents in graphical form information specific to the industry based on the data elements of one or more of the data tables.

Claims

1. A method for analyzing data for an industry, comprising:

extracting, by a user, source data from source systems;

transforming, by the user, the source data into key metrics data for a given time period;

loading, by the user, the key metrics data into a file extract;

providing data tables that are customized for the industry;

accepting input of the file extract;

mapping the inputted data to data elements of one or more data tables customized for the industry;

generating trends and metrics data relevant to the industry from the data elements of the one or more data tables; and

presenting the trends and metrics data.

2. The method of claim 1, wherein the generating includes producing the trends and metrics data from a subset of the one or more of the data tables according to business rules.

3. The method of claim 1, wherein the presenting includes presenting a graphical representation of the trends and metrics data.

4. The method of claim 3, wherein the graphical representation comprises graphical dashboards.

5. The method of claim 1, wherein the transforming by the user is based on the user'"'"'s knowledge of at least one or more of formulas, business rules, data mapping rules, and information regarding how other users may interpret data fields in the source systems.

6. The method of claim 1 further comprising providing a wizard to accept the input of data by the user and to map the inputted data into the data elements of the one or more of the data tables.

7. The method of claim 1, wherein the mapping the inputted data includes translating the inputted data from a first form to a second form.

8. The method of claim 1, wherein the one or more of the data tables comprises one or more of a contract table, a products table, a property table, a subscription table, a clients table, a business rule table, a client user table, and a client user property table.

9. The method of claim 1, further comprising transforming the data elements of the one or more data table into actionable information for the industry.

10. A system for analyzing data for an industry, comprising:

a user at a company that

extracts source data from source systems,

transforms the source data into key metrics data for a given time period, and

loads the key metrics data into a file extract;

a data warehouse including data tables that are customized for the industry;

a web portal for accepting input of data within the file extract related to the industry;

a transformation logic for mapping the data to data elements of one or more of the data tables; and

a graphical dashboard that presents, in graphical form, information specific to the industry based on the data elements of one or more of the data tables.

11. The system of claim 10, wherein the data warehouse includes a plurality of data tables that are customized for a plurality of industries.

12. The system of claim 10, wherein the information includes historical trends and metrics specific to the industry.

13. The system of claim 10, wherein subsets of the information is user-selectable and is presentable by the graphical dashboard.

14. The system of claim 13, wherein the subsets of the information is selected by applying business rules of a client.

15. The system of claim 10, wherein the graphical dashboard is operable to filter the information based on a choice of pre-defined options.