Dear PI Community!

I am working for an energy company. We are using PI to store and visualise the data from gas wells.

I am looking for efficient ways to do statistical analysis of the data in PI (e.g. average pump speed for wells located in various fields, etc).

I normally do this type of analysis in Excel using PI DatLink, however this is very time consuming due to large quantities of data.

Is there a better way to do statistical analysis of the data stored in PI?

Regards,

Alexey

If you have reoccurring needs, then you may be better off using PI Integrator and prepare the data view for consumptions with tools like PowerBI.

If it's rather occasional analysis, then perhaps the use of BI tools with PI SQL Client may be an option for you?

For both uses, you will need PI AF in order to standardize your wells.