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 time;
using the sensor data, determine one or more attribute values for the physical assets for a time period, wherein the one or more attribute values correspond to physical properties of the physical assets;
determine a first group comprising one or more of the physical assets;
aggregate the attribute values of the one or more physical assets of the first group to determine one or more aggregate attribute values for the first group for the time period; and
in response to a user selection of the first group, generate a first interactive user interface including:
indications of the one or more physical assets of the first group,
indications of the one or more aggregate attribute values for the first group for the time period, and
indications of the one or more attribute values for each of the one or more physical assets of the first 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 3 , wherein the one or more attribute values comprise 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 first 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 first group;
associate each job with a cumulative cost, the cumulative cost indicating a total cost of jobs associated with physical assets of the first 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.