Real-time or event-based analysis of process data

A computing system that implements a data processing service, the computing system comprising:

• memory;
• one or more processing units coupled to the memory;
• and
• one or more non-transitory computer readable storage media storing instructions that, when loaded into the memory, cause the one or more processing units to perform operations for:
• generating planning data for a process having a process ID, the process having a plurality of operations, each operation having an operation ID, wherein the planning data comprises planned input element use data for the plurality of operations;
• storing the planning data in a first database table having a first format;
• receiving data from a plurality of data sources associated with the plurality of operations of the process having the process ID, wherein the data comprises input element use data;
• storing the received data in a second database table having the first format;
• querying the first and second tables to retrieve at least a portion of the planning data and the input element use data;
• for multiple operations of the plurality of operations, comparing a planned data value for the operation with an input element use value for the operation to generate a variance value;
• generating a report comprising the multiple variance values;
• and
• rendering the report for display.

In a computing environment, a method comprising:

• receiving data over a network from a plurality of hardware sensors associated with a plurality of operations, the data comprises input element use data, wherein the operations are associated with a process having a process ID;
• storing the data in one or more database tables;
• querying a database for a process specification associated with the process ID, the process specification comprising a hierarchy of nodes, where a node represents a particular operation and the hierarchy describes an operation sequence for the process having the process ID;
• querying the database for planning values associated with the hierarchy of nodes;
• comparing the planning values with the data to determine one or more variance values;
• and
• generating a report comprising the one or more variance values.