Systems for collecting, aggregating, and storing data, generating interactive user interfaces for analyzing data, and generating alerts based upon collected data
Systems and methods for aggregating and storing different types of data, and generating interactive user interfaces for analyzing the stored data. In some embodiments, entity data is received for a plurality of entities from one or more data sources, and used to determine attribute values for the entities for one or more given time periods. The plurality of entities may be categorized into one or more entity groups, and aggregate attribute values may be generated based upon the entity groups. A first interactive user interface is generated displaying the one or more entity groups in association with the aggregated attribute values associated with the entity group. In response to a received indication of a user selection of an entity group, a second interactive user interface is generated displaying the one or more entities associated with the selected entity group, each entity displayed in association with the attribute values associated with the entity.
1. A computer system comprising:
a non-transitory computer-readable storage medium storing program instructions; and
one or more computer processors configured to execute the program instructions to cause the computer system to:
access or receive sensor data from one or more sensors associated with physical assets, the sensor data comprising measurements over a time period;
using the sensor data, aggregate attribute values associated with a group of one or more physical assets to determine one or more aggregate attribute values for the time period; and
in response to a user selection of the group of the one or more physical assets, generate a first interactive user interface including:
indications of the one or more aggregate attribute values for the group for the time period, and
indications of attribute values for each of the one or more physical assets of the group for the time period.
2. The computer system of claim 1 , wherein the first interactive user interface further comprises, for each of the one or more aggregate attribute values, a graph illustrating values of the aggregate attribute value over multiple previous time periods.
3. The computer system of claim 2 , wherein the first interactive user interface further comprises, for each of the one or more aggregate attribute values, a change value indicating a change in the aggregate attribute value from a previous time period.
4. The computer system of claim 1 , wherein the first interactive user interface further comprises one or more attribute values comprising at least an operational status and a production value.
5. The computer system of claim 1 , wherein the one or more computer processors are configured to execute the program instructions to further cause the computer system to:
access job data corresponding to a plurality of jobs, each job being associated with at least one physical asset of the one or more physical assets of the group, a job time, and a job cost;
access production data comprising production values determined over time associated with the one or more physical assets of the group;
associate each job with a cumulative cost, the cumulative cost indicating a total cost of jobs associated with physical assets of the group and based on the job costs;
associate each job with a production value, based at least in part upon the job time; and
generate a chart plotting cumulative costs against production values for the plurality of jobs.
6. The computer system of claim 5 , wherein each job is associated with a production value change, based upon a first production value associated with a first time and a second production value associated with a second time, the first time occurring before the job time associated with the job, and the second time occurring after the job time.
7. The computer system of claim 1 , wherein the one or more computer processors are configured to execute the program instructions to further cause the computer system to:
in response to a physical asset being in a non-operational status, flag the physical asset for review by the user, wherein the physical asset is associated with a reason for non-operation;
in response to a received indication that the user has reviewed the physical asset, unflag the physical asset; and
re-flag the physical asset for review by the user in response to a detection that a designated period of time has passed since the user has previously reviewed the physical asset, or in response to detection of a change in a condition associated with the reason for non-operation, wherein the detected change is inconsistent with the reason for non-operation.
8. The computer system of claim 7 , wherein the designated period of time is based at least in part upon an attribute value or job status associated with the reason for non-operation.
9. The computer system of claim 7 , wherein the condition is associated with an attribute value of the physical asset, and wherein the detected change corresponds to a detection that the attribute value is not within an undesired value range.
10. The computer system of claim 7 , wherein the condition is associated with a job status, and wherein the detected change corresponds to a change of the job status.
11. A computer-implemented method comprising:
accessing or receiving sensor data from one or more sensors associated with physical assets, the sensor data comprising measurements over a time period;
using the sensor data, aggregating attribute values associated with a group of one or more physical assets to determine one or more aggregate attribute values for the time period; and
in response to a user selection of the group of the one or more physical assets, generating a first interactive user interface including:
indications of the one or more aggregate attribute values for the group for the time period, and
indications of attribute values for each of the one or more physical assets of the group for the time period.
12. The method of claim 11 , wherein generating the first interactive user interface further comprises displaying, for each of the one or more aggregate attribute values, a graph illustrating values of the aggregate attribute value over multiple previous time periods.
13. The method of claim 12 wherein generating the first interactive user interface further comprises displaying, for each of the one or more aggregate attribute values, a change value indicating a change in the aggregate attribute value from a previous time period.
14. The method of claim 13 , wherein generating the first interactive user interface further comprises displaying one or more attribute values comprising at least an operational status and a production value.
15. The method of claim 11 , further comprising:
accessing job data corresponding to a plurality of jobs, each job being associated with at least one physical asset of the one or more physical assets of the group, a job time, and a job cost;
accessing production data comprising production values determined over time associated with the one or more physical assets of the group;
associating each job with a cumulative cost, the cumulative cost indicating a total cost of jobs associated with physical assets of the group and based on the job costs;
associating each job with a production value, based at least in part upon the job time; and
generating a chart plotting cumulative costs against production values for the plurality of jobs.
16. The method of claim 15 , wherein each job is associated with a production value change, based upon a first production value associated with a first time and a second production value associated with a second time, the first time occurring before the job time associated with the job, and the second time occurring after the job time.
17. The method of claim 11 , further comprising:
in response to a physical asset being in a non-operational status, flagging the physical asset for review by the user, wherein the physical asset is associated with a reason for non-operation;
in response to a received indication that the user has reviewed the physical asset, unflagging the physical asset; and
re-flagging the physical asset for review by the user in response to a detection that a designated period of time has passed since the user has previously reviewed the physical asset, or in response to detection of a change in a condition associated with the reason for non-operation, wherein the detected change is inconsistent with the reason for non-operation.
18. The method of claim 17 , wherein the designated period of time is based at least in part upon an attribute value or job status associated with the reason for non-operation.
19. The method of claim 17 , wherein the condition is associated with an attribute value of the physical asset, and wherein the detected change corresponds to a detection that the attribute value is not within an undesired value range.
20. A non-transitory computer-readable medium having software instructions embodied thereon, the software instructions executable by one or more hardware processors to cause the one or more hardware processors to:
access or receive sensor data from one or more sensors associated with physical assets, the sensor data comprising measurements over a time period;
using the sensor data, aggregating attribute values associated with a group of one or more physical assets to determine one or more aggregate attribute values for the time period; and
in response to a user selection of the group of the one or more physical assets, generate a first interactive user interface including:
indications of the one or more aggregate attribute values for the group for the time period, and
indications of attribute values for each of the one or more physical assets of the group for the time period.