AVEVA PI DataLink

AVEVA PI DataLink, a Microsoft Excel add‐in, enables users to pull information from their AVEVA PI System directly into a worksheet.

Get a demo Get our product brochure

Presentation

Easily use your operations data in spreadsheets

Microsoft Excel, a globally popular software, is widely used by engineers, operators, and analysts. Similarly, AVEVA™ PI Server has been a leading operations information management software for years. Our Microsoft Excel add-in, AVEVA PI DataLink, seamlessly integrates these two powerful tools. With AVEVA PI DataLink, users can retrieve, contextualize, analyze, visualize, and report on time-series data from AVEVA PI Server directly within Excel. Combining special AVEVA PI DataLink functions with Excel's native analysis features, it becomes a potent innovation tool. AVEVA PI DataLink offers a cost-effective environment for non-programmers to swiftly perform complex analysis, experimentation, and ad hoc investigations.

Download product brochure

AVEVA PI Data Link features

Get a demo

Create flexible reports

Leverage your reliable data to derive actionable insights within a familiar spreadsheet environment. With AVEVA PI DataLink, users can seamlessly transform trusted data into actionable information directly within well-known spreadsheet platforms, enabling efficient decision-making processes and enhancing productivity.

View data in context

AVEVA PI DataLink enables users to integrate asset models and event data from AVEVA PI Server directly into spreadsheets, enhancing the understanding and interpretation of the data presented in reports. This contextualization ensures that insights derived from spreadsheet analyses are based on comprehensive and relevant information, facilitating informed decision-making processes.

Perform complex analysis

Unlock the capability to conduct intricate analysis effortlessly. AVEVA PI DataLink empowers users to perform sophisticated data analysis tasks with ease. Whether it's advanced calculations, trend analysis, or comparative studies, the tool provides the functionality needed to delve deep into data and extract valuable insights for informed decision-making.

Gain perspective

Access comprehensive historical and future data with precision using AVEVA PI DataLink. This tool allows users to retrieve high-fidelity data, both from the past and projected into the future, enabling thorough analysis and reporting. By harnessing this feature, organizations can make informed decisions based on a comprehensive understanding of their data trends and patterns.

Stay current

Ensure the ongoing relevance and accuracy of your dashboards and reports with automatic updates provided by AVEVA PI DataLink. This feature allows for the seamless and regular refreshing of data, ensuring that your visualizations and analyses reflect the most current information without the need for manual intervention.

Operations analysis

Streamline operations analysis with AVEVA PI DataLink, which automates the integration of data identified by specific tags, events, or calculated values directly into pre-existing spreadsheets. This functionality reduces the need for manual data manipulation, saving valuable time and effort for users.

Sustainability

Visibility is crucial in control. AVEVA PI DataLink empowers process companies by providing insights into water, electricity, and thermal energy consumption, facilitating better management practices aimed at promoting sustainability and efficiency.

Compliance reporting

Industries subject to environmental regulations leverage AVEVA PI DataLink to create compliance monitoring spreadsheets and generate necessary reports. This ensures adherence to regulatory requirements while streamlining the reporting process for improved efficiency and accuracy.

Business process improvements

Transitioning from manual spreadsheets, an energy generator in West Europe empowered its power-trading team to proactively access real-time data from every plant. This shift led to accelerated results and a reduction in errors, highlighting the efficiency and accuracy gains achieved through the adoption of automated data retrieval processes.

AVEVA PI Data Infrastructure bundle

Learn more about the bundle

Collect and Contextualize with AVEVA PI Server

Collect your data in real time, analyze, and notify users.

Visualize with AVEVA PI Vision

Visualize information through dynamic self-service dashboards.

Learn more

Share with AVEVA Data Hub

Create a connected community and share information in the Cloud.

Learn more

They talk about us

They use AVEVA Pi

Discover all the success stories

“By Pfizer already having an Enterprise Agreement, I am like a kid in a candy store. I can just use and install as many tags as I like in the PI System without any extra costs.”

David Rabon

Team Lead, Automation Services at Pfizer

“Now we spend less time looking for data and more time analyzing it. Kellogg’s increased mean time between failures rate by 180%. By channeling digitized operations data into AVEVA PI Server and analyzing it in context, Kellogg’s significantly reduced failure rates and cut critical control points by 64%.”

Emilio Angles

Power Controls and Information Systems Manager, Kellogg’s

“There is only one loading facility. We had to push more ore through with no additional capital investments. All we could do was apply a bit of smarts to what we had and see what we could do.”

Michel Plourde

Director of Innovation and Technology, ArcelorMittal

“Asset optimization is possible at minimal cost with basic technical skill using AVEVA PI System infrastructure.”

Lloyd Melrose

Group Control and Instrumentation Engineer, Illovo Sugar Africa

“We've achieved some of the more obvious efficiencies, but to reach our 2025 goal we need to go deeper. That increasingly requires things like user engagement, campus engagement, and optimization. In the last five years, the use of real-time data and the PI System has become increasingly integral to our operations and our goals.”

David Trombly

Engineering Supervisor, UC Davis