Process Intelligence in the Process Industries
Process Intelligence represents for Level 3 Process Systems what Business Intelligence represents for Level 4 Business Systems.
Process Intelligence provides holistic and drilled down views of process systems data, which are typically combined from online, real time control and instrumentation systems like DCS, PLCs, etc. The Process Intelligence data is typically used for plant performance reporting, but true Process Intelligence goes beyond reporting.
Process Intelligence can use data mining and other analytical technologies (i.e. OLAP applications) in order to process plant data and extract intelligence for exploratory analyses and predictive modeling requirements like root cause analysis and failure prediction.
This information can be then provided to plant management for further assessment of plant performance. Process Intelligence functionalites can be combined with similar information from the Business Systems in order to provide a consolidated view of both Corporate and Plant Performance Management Systems (CPPM).
Last, data from the control systems can be also extracted and incorporated into the CPPM or analyzed for exploratory and predictive purposes at the level of Control Intelligence.
Data Mining & Process Intelligence
ziconNET is a certified StatSoft Consulting Partner to provide Data Mining Consultancy Services and Process Intelligence Solutions based on the award winning STATISTICA Solutions from StatSoft.
Oil & Gas, Refining, Chemical and Petrochemical organizations are among the largest users of STATISTICA applications, benefiting from STATISTICA analytics and the STATISTICA platform results in hard and soft ROI by:
- Empowering scientists and engineers with the analytic and exploratory tools to make more sound decisions and gain greater insights from the precious data that they collect
- Saving their time by integrating analytics in their core processes
- Saving their time to focus on the delivery and packaging of effective analytic tools within the STATISTICA framework
- Increasing the level of collaboration across the organization by sharing study results, findings, and reports
STATISTICA provides a broad base of integrated statistical and graphical tools including:
Tools for basic research such as Exploratory Graphical Analysis, Descriptive Statistics, t-tests,Analysis of Variance, General Linear Models, and Nonlinear Curve Fitting.
Tools for more advanced analyses such as a variety of clustering, predictive modeling, classification and machine learning approaches including Principal Components Analysis, The STATISTICA platform meets the needs of both scientists and statisticians in your R&D organization.
Oil & Gas, Refining, Chemical and Petrochemical organizations have deployed STATISTICA within their manufacturing processes in several ways:
- These organizations have arrived at a greater understanding of their process parameters and their relationship to product quality by applying STATISTICA's multivariate statistical process control (SPC) techniques. STATISTICA integrates with their process information repositories and LIMS systems to retrieve the data required to perform these analyses.
- These organizations have also utilized the deployment capabilities of STATISTICA's Data Mining algorithms to integrate advanced modeling techniques such as Neural Network, Recursive Partitioning approaches (CHAID, C&RT, Boosted Trees), MARSplines, Independent Components Analysis, and Support Vector Machines. STATISTICA allows them to deploy a fully-trained predictive model in Predictive Modeling Markup Language (PMML), C++ and Visual Basic for ongoing monitoring of a process. These models based, once trained and evaluated on historical data, are deployed as "soft sensors" for the ongoing monitoring and control of process parameters..
Innovative Data Management & Integration is key for successful implementation of Process Intelligence
Locii Solutions and ziconNET have partnered to deliver an innovative approach in the design and implementation of Business Intelligence (BI) solutions. locii-InSight,which isdesigned specifically for multi-dimensional, analytical data models, can be further extended to integrate data from Level 3 and Level 2, 1, 0 systems, thus providing a holistic and integrated view of an entire enterprise and plant for pro-active decision making.
Using in-house techniques, Locii Solutions has developed a new methodology that dramatically accelerates and simplifies the creation of data warehouses and ETL (Extract, Transform, Load) software. In addition, locii Insight includes a new breed of Microsoft Excel formulas that allow an unskilled user to easily link spreadsheet cells to organisational data. This Excel formula approach revolutionises the production of reporting as a user simply opens a new Excel workbook and types a formula that creates an instantaneously updating data link. For example, a user can enter product codes into cells and write a formula to return the current sales, or enter account codes and type a formula to return the balance on the accounts. The user then saves the workbook on their hard drive and the data link is updated any time the user reopens their workbook. The locii-InSight solution provides the following components:
- Insight Server: hardware is integrated with a network and is specifically configured for high speed loading, updating and reporting.
- Insight Loader: utilising SQL Server Integration Services and code generation techniques, locii-Insight can update from a range of systems (SQL, AS400/DB2, Text Files, MS Access, Excel...)
- Insight Database: a high performance data warehouse using SQL Server 2008, tailored for maximum reporting speed.The Insight system ‘cleanses’ data automatically to ensure it is fully relational and identifies problematic or unusual data.
- Insight Cubes: built on the Insight database, and using SQL Analysis Services to build multidimensional images of company data, Insight cubes provide near-instantaneous reporting on over 200 million records.
- Insight Excel Client: with all the power of Excel and the exciting new BI features in Excel 2007/10 this client allows rapid navigation using pivot tables and charts with minimal training.
- Excel Ribbon Interface: Unique to locii Insight, the ribbon interface offers a revolutionary new environment for more advanced users to manipulate Insight data directly in Excel 2007/10
- Insight Web Reports/SharePoint: with SharePoint 2007/10 and/or SQL Reporting Services Insight can extend reports, dynamic dashboards and spreadsheets etc. directly to end users
The combined and integrated approach for Business, Process and Control System Intelligence is the next differentiator for safer, more efficient and profitable, and proactive operation of process plants.
View the White Paper by ziconNET below