System and methods for integrated performance measurement environment

• US 9,990,408 B2
• Filed: 11/10/2016
• Issued: 06/05/2018
• Est. Priority Date: 11/10/2015
• Status: Active Grant

• Current Assignee: Openmetrik Incorporated
• Original Assignee: Openmetrik Incorporated
• Inventors: Sekar, Chandra
• Primary Examiner(s): Shanmugasundaram, Kannan
• Application Number:
  US15/348,856
• Publication Number:
  US 20170132300A1
• Time in Patent Office: 572 Days
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06Q 10/067 Enterprise or organisation modelling

Abstract

A system for integrated performance measurement environment comprises a plurality of distributed file systems; a database, wherein the database further comprises a layout details table, a layout definition table, and at least one raw data master file; at least one network; an extract-transform-load module in a memory; and a business logic module in the memory, wherein the business logic module further comprises metrics catalog and business intelligent plug-in blocks; and a collaboration module in the memory; and methods performing the same including extracting, transforming, and loading data into the system, retrieving data in accordance with rules in metrics catalog and business intelligent plug-in blocks, drilling down the metrics catalog and business intelligent plug-in blocks, and collaborating over the system.

Claims

1. A system for integrated performance measurement environment, comprising:

a plurality of distributed file systems storing a plurality of raw data sources;

a database receiving a plurality of raw data from the plurality of raw data source and assigning a plurality of attributes to the plurality of raw data, wherein the database further comprises a layout details table, a layout definition table, and at least one raw data master file, wherein the raw data is stored in the at least one raw data master file, wherein the at least one raw data master file is denormalized;

at least one network capable of transmitting the plurality of raw data from the plurality of raw data source to a process device;

an extract-transform-load module in a memory of the process device, which extracts, transforms, and loads the plurality of raw data into the database in accordance with a set of instructions in the extract-transform-load module;

a business logic module in the memory of the process device, which comprises a plurality of metrics and a plurality of business intelligent plug-in blocks to retrieve, filter, aggregate, convert, and display a plurality of data stored in the at least one raw data master file, wherein the business intelligent plug-in blocks further comprises at least one condition to process a plurality of stored data consisting of filtering, cutting out, combining a plurality of attributes of the plurality of stored data, aggregating, computing, time period, and a combination thereof;

a collaboration module in the memory of the process device, wherein the collaboration module further comprises a plurality of comment threads, an issue escalation system, an action item tracking, a milestone status tracking, and a plurality of root cause analysis process;

at least one graphical user interface, wherein an end user operates the at least one graphical user interface to define a format specification of a plurality of raw data to specify the format specification of the plurality of raw data in the plurality of raw data source; and

a set of graphical presentations of a plurality of processed data consisting of charts, graphs, reports, and tables, and a combination thereof, wherein the set of graphical presentations of a plurality of processed data is on the display device.

2. The system of claim 1 further comprising an online meeting module in the memory.

3. A method for integrated performance measurement environment, comprising:

providing, by a process device, at least one graphical user interface for a user to define format specification of a plurality of raw data to specify the format specification of the plurality of raw data in at least one raw data source;

receiving, by a process device, the format specification of the plurality of raw data in the at least one raw data source, wherein the plurality of raw data comprises at least one row, at least one column, and at least one value in accordance with the at least one row and the at least one column, wherein the format of specification comprises a plurality of rules for an extract, transform, and load (ETL) operation;

receiving, by the process device, a plurality of raw-data-process-instructions in the ETL operation, wherein the plurality of raw-data-process-instructions comprises the plurality of rules to reject an abnormality in the raw data and alert a user for the abnormality in the raw data;

receiving the plurality of raw data to be interpreted as an input from the at least one raw data source;

executing, by the process device, the ETL operation, wherein the ETL operation further comprises

an extract process comprising selecting from the plurality of raw data,

one or more transformation processes to aggregate and formulate the plurality of raw data, and

a load process comprising loading the plurality of raw data into a raw data master file by an order of the at least one row of the at least one raw data source in accordance with the format specification of the plurality of raw data;

processing the plurality of raw data and storing the plurality of raw data into appropriate locations in the raw data master file by mapping the plurality of raw data, and a plurality of attribute associated with the plurality of raw data into a prebuilt data dictionary structure;

generating, by the process device, a set of graphical presentations of the plurality of processed data consisting of charts, graphs, reports, and tables, and a combination thereof; and

providing the set of graphical presentations on a display device.

4. The method of claim 3, further comprising:

receiving, by the process device, at least one metric and at least one business intelligent plug-in block defined by at least a user;

retrieving a plurality of stored data from the raw data master file, by the process device, in accordance with at least one set of parameters in the at least one business intelligent plug-in block as defined by the user;

processing the plurality of stored data into a plurality of processed data, by the process device, in accordance with the at least one condition defined in the at least one business intelligent plug-in block, wherein the at least one condition to process the plurality of stored data consisting of filtering, cutting out, combining the plurality of attributes of the plurality of stored data, aggregating, computing, time period, and a combination thereof;

generating, by the process device, a set of graphical presentations of the plurality of processed data consisting of charts, graphs, reports, and tables, and a combination thereof; and

providing the set of graphical presentations on a display device.

5. The method of claim 4, further comprising:

receiving, by the process device, the at least one metric and the at least one business intelligent plug-in block upon clicking, the user, on one of the set of graphical presentations of the plurality of processed data, wherein the at least one metric comprises at least one query to retrieve the plurality of stored data with a child attribute in related to the plurality of processed data with a parent attribute;

retrieving the plurality of stored data from the raw data master file, by the process device, in accordance with at least one set of parameters in the at least one business intelligent plug-in block as defined by the user; and

processing the plurality of stored data into a plurality of processed data, by the process device, in accordance with the at least one condition defined in the at least one business intelligent plug-in block, wherein the at least one condition to process the plurality of stored data consisting of filtering, cutting out, combining the plurality of attributes of the plurality of stored data, aggregating, computing, and a combination thereof.

6. The method of claim 4, further comprising:

providing, by the process device, an input graphical user interface for an input to be associated with the business intelligent plug-in block, wherein the input graphical user interface is associated with a unique identification number of the business intelligent plug-in block;

accepting the input from the user, by the process device;

recording, by the process device, the input into the raw data master file in accordance with the unique identification number of the business intelligent plug-in block;

retrieving, by the process device, the input from the raw data master file upon another user clicking on the business intelligent plug-in block associated with the input; and

displaying the input, by the process device, on the input graphical user interface.

7. A method for integrated performance measurement environment, comprising:

providing, by a process device, at least one graphical user interface for a user to define format specification of a plurality of raw data to specify the format specification of the plurality of raw data in at least one raw data source;

receiving, by a process device, the format specification of the plurality of raw data in the at least one raw data source, wherein the plurality of raw data comprises at least one row, at least one column, and at least one value in accordance with the at least one row and the at least one column, wherein the format of specification comprises a plurality of rules for an extract, transform, and load (ETL) operation;

receiving, by the process device, the plurality of raw-data-process-instruction in the ETL operation, wherein the plurality of raw-data-process-instruction comprises the plurality of rules to reject an abnormality in the raw data and alert a user for the abnormality in the raw data;

receiving the plurality of raw data to be interpreted as an input from the at least one raw data source;

executing, by the process device, the ETL operation, wherein the ETL operation further comprises

an extract process comprising selecting from the plurality of raw data,

one or more transformation processes to aggregate and formulate the plurality of raw data, and

a load process comprising loading the plurality of raw data into a raw data master file by an order of the at least one row of the at least one raw data source in accordance with the format specification of the plurality of raw data;

processing the plurality of raw data and storing the plurality of raw data into appropriate locations in the raw data master file by mapping the plurality of raw data, and a plurality of attribute associated with the plurality of raw data into a prebuilt data dictionary structure;

receiving, by the process device, at least one metric and at least one business intelligent plug-in block defined by at least a user;

retrieving a plurality of stored data from the raw data master file, by the process device, in accordance with at least one set of parameters in the at least one business intelligent plug-in block as defined by the user;

processing the plurality of stored data into a plurality of processed data, by the process device, in accordance with the at least one condition defined in the at least one business intelligent plug-in block, wherein the at least one condition to process the plurality of stored data consisting of filtering, cutting out, combining the plurality of attributes of the plurality of stored data, aggregating, computing, time period, and a combination thereof;

generating, by the process device, a set of graphical presentations of the plurality of processed data consisting of charts, graphs, reports, and tables, and a combination thereof;

providing the set of graphical presentations on a display device;

receiving, by the process device, the at least one metric and the at least one business intelligent plug-in block upon the user clicking on one of the set of graphical presentations of the plurality of processed data, wherein the at least one metric comprises at least one query to retrieve the plurality of stored data with a child attribute in related to the plurality of processed data with a parent attribute;

retrieving the plurality of stored data from the raw data master file, by the process device, in accordance with at least one set of parameters in the at least one business intelligent plug-in block as defined by the user;

processing the plurality of stored data into a plurality of processed data, by the process device, in accordance with the at least one condition defined in the at least one business intelligent plug-in block, wherein the at least one condition to process the plurality of stored data consisting of filtering, cutting out, combining the plurality of attributes of the plurality of stored data, aggregating, computing, and a combination thereof;

generating, by the process device, a set of graphical presentations of the plurality of processed data consisting of charts, graphs, reports, and tables, and a combination thereof; and

providing the set of graphical presentations on a display device.

8. The method of claim 7, further comprising:

providing, by the process device, an input graphical user interface for an input to be associated with the business intelligent plug-in block, wherein the input graphical user interface is associated with a unique identification number of the business intelligent plug-in block;

accepting the input from the user, by the process device;

recording, by the process device, the input into the raw data master file in accordance with the unique identification number of the business intelligent plug-in block;

retrieving, by the process device, the input from the raw data master file upon another user clicking on the business intelligent plug-in block associated with the input; and

displaying the input, by the process device, on the input graphical user interface.