ADROIT SCADA INTELLIGENCE
HMI – SCADA – LIFE CYCLE MANAGEMENT
Adroit SCADA Intelligence is an out-of-the-box data warehousing and business intelligence solution that collects, processes and organises historical data from disparate data sources into a structured industry standard data model (ISA-95 Expanded Equipment Hierarchy). The resulting information is then made available on a common platform to enable informed decision making.
Adroit SCADA Intelligence is developed on Microsoft SQL 2008 R2 Enterprise. Microsoft Business Intelligence solutions scale to the growing needs of your organization and provide the agility to respond quickly to changes.
The Adroit SCADA Intelligence Application
- The Adroit SCADA Intelligence Manager is used to configure data connectors, define how and when data is to be processed, database archiving, system backups, monitor system performance, processing durations and system error logs.
- The Adroit SCADA Intelligence Analyser allows users to do ad hoc analysis on both the Data Warehouse and the Operational Data Store using drag and drop functionality.
Adroit SCADA Intelligence Product Architecture
Adroit SCADA Intelligence can retrieve time based historical data from multiple data sources.
The Extract Transform Load (ETL) process adds predefined context and other attributes to the summarised data and stores this in the data warehouse. Thus the captured data is transformed into information.
The summarised information is stored in a multidimensional Data Warehouse. This is an optimised data store with specific focus around data management and retrieval. The contextualised raw data, for higher resolution analysis, is stored in an Operational Data Store (ODS).
The information is modelled into an On-Line Analytical Processing (OLAP) cube which enables information to be queried and analysed efficiently using any OLAP compliant Business Intelligence (BI) or reporting.
The presentation layer is how information or key performance indicators (KPIs) are presented or visualised by end users. These can take the form of dashboards, scorecards, reports, or interactively through software such as Excel and/or the Adroit SCADA Intelligence Analyser.
Application of ADROIT SCADA Intelligence
- Production Reporting
- Equipment Performance
- Overall Equipment Efficiency
- Network Performance
- Operator Performance
- Environmental Management
- Carbon Footprint Reporting
- Water Balance Reporting
- Distribution Management
- Quality Management
- Telemetry Network Management
Industries using ADROIT SCADA Intelligence
- Mining, Metals and Minerals
- Facilities Management
- Food and Beverage
- Oil and Gas
Reduced Configuration Time
The Adroit SCADA Intelligence software is quick and easy to install. The items and context model can be easily configured through the Adroit SCADA Intelligence Manager or the Microsoft Excel import I export functionality. This reduces implementation time, effort and therefore cost of your Adroit SCADA Intelligence solution.
Adroit SCADA Intelligence comes standard with report templates, sample reports and report parts that can be used to create custom reports. This allows for rapid development and customisation of your Adroit SCADA Intelligence solution.
Seamless Excel Analysis
Standard OLAP functionality in Excel enables users to connect to the Adroit SCADA Intelligence data cube directly. This familiar and intuitive environment allows users to easily do ad hoc analysis and reporting off their data with little or no training.
Adroit SCADA Intelligence is built on the Microsoft Bl platform that allows for the seamless integration into SharePoint technologies.
The Adroit SCADA Intelligence Analyser User Interface
Without any other software it is possible to use the standard Adroit SCADA Intelligence Analyser to extract information in trends and other standard views. User defined reports can be created, stored and shared with other interested parties.
Multiple Data Sources
Data can be collected from Microsoft SOL databases, manual data input and 3rd party applications such as SCADA Historians (Citect Historian and Wonderware’s lnSOL).
Transform Raw Data Into information
Time based historical data is one dimensional, however the real world is not. Adroit SCADA Intelligence allows users to add context which transforms the data into information adding enormous value in the process.
ISA-95 Structured Equipment Hierarchy
Adroit SCADA Intelligence allows data to be contextualised into the S95 extended physical model. This model is an industry accepted standard used to organise enterprise data.
Microsoft SQL Reporting Services
Adroit SCADA Intelligence is built on the Microsoft Bl platform and as such allows users to take full advantage of the applications that leverage the technology. Features include:
- Web based reporting can be made available on the web via SQL Server Reporting Services (SSRS).
- Reports available in different formats: (email, Excel, PDF and HTML).
- Scheduling reports: Reports can be scheduled or created on demand.
- Drill down functionality from reports: Users can drill down from reports in data for further detailed analysis.