avantis.dss for wonderware...
TRANSCRIPT
Avantis.DSS for
Wonderware
Intelligence
AV TSS-01
Mike Scholman
Slide
1
2014 Software Global Client Conference
Mobile App: Please take a moment…
Check into Session by:
●Select Detailed Schedule
●Select the specific session
●Click on “Check in”
Take Session Survey by:
●Select Detailed Schedule
●Select the specific session
●Scroll Down to “Survey” and Provide Feedback
2014 Software Global Client Conference
Plant Data/
SCADA/Models
Role-Based Integrated Suite ERP
Access to Information Document
Management
Condition Based Maintenance
Remote Monitoring
EAM – Maintenance & Materials
Management
2014 Software Global Client Conference
Avantis.DSS 5.0 Offering
• Offer Key Performance Indicators based on industry best practices that can provide
value immediately
• Empower customers with information that is readily available, current, and
accompanied by a tool-set to further explore and manipulate that information
• Deliver an architecture that optimizes performance
• Enable role based dashboards to be tailored/extended on a customer basis
Deliver an out-of-the-box, easy-to-use
solution that translates transactional data
into meaningful information
2014 Software Global Client Conference
Avantis.DSS 5.0 - Value
● A pre-packaged solution requiring minimal configuration
● Includes a large selection of standard Maintenance, Purchasing and
Inventory KPI’s to get started quickly
● Built over a separate information data warehouse, to minimize
performance impact on the Avantis.PRO database
● Developed using industry leading best of breed tools
● Able to be tailored/extended on a customer basis
2014 Software Global Client Conference
Wonderware Intelligence Benefits
Leveraging Wonderware® Intelligence we deliver to decision makers a
rich, comprehensive role-based asset management analytic tool for
robust reporting and visualization
Intelligence offers the ability to:
• Collaborate & share metrics through an easy to configure web-based
dashboard
• Gain visibility into Key Performance Indicators on a site-wide, or corporate-
wide, basis
• Use existing skill sets, without deep IT requirements
2014 Software Global Client Conference
Flexible Access to Information
• Dashboards can be accessed everywhere;
• Any PC Browser,
• Mobile Safari Browser,
• Android App
• iPad App
2014 Software Global Client Conference
Who benefits?
Executives Decision making support
Information transparency
Plant Manager Cost Analysis
Maximize asset availability
Maintenance
Supervisors Repair vs. Replace
Inventory
Managers Turns analysis
Where Used
2014 Software Global Client Conference
Avantis.DSS Architecture
Wonderware Intelligence
Web Clients
Wonderware
Intelligence
Analytics Clients
Web clients access
published dashboards
Role based
dashboards
published
3rd Party Clients
Microsoft Office
Reporting Services
SharePoint Portal
View Dashboards & Information Browser
Create Dashboards & Analytics
Avantis ETL Server
Extraction &
Transformation
Process
(SSIS)
Avantis.PRO Subject Matter
SQL Server
Database
Analysis
Database
(Data Cubes)
Dashboard Server
Published
Dashboards
Ad-hoc Analytics
and Dashboard
design
Dashboard Server
retrieves updated data
from Analysis Database
Avantis.PRO
data extracted
to ETL Server
2014 Software Global Client Conference
Aligning Decision Making to Business Goals
Visualization through
Wonderware
Intelligence or tool of
your choice
Ad-hoc analysis,
consolidated
reporting
drill-down,
drill-through
• KPI’s based on
industry best
practices providing
value immediately
2014 Software Global Client Conference
Data Extraction with SSIS ● Data is extracted from the Avantis.PRO database via the execution of a set
of data transformation services (SSIS) packages
Avantis ETL Server
Extraction &
Transformation
Process
(SSIS)
Avantis.PRO
2014 Software Global Client Conference
Subject Matter SQL Database ● Data is stored in an operational data warehouse or subject matter SQL
Server database
Avantis ETL Server
Subject Matter
SQL Server
Database
Extraction &
Transformation
Process
(SSIS)
Avantis.PRO
2014 Software Global Client Conference
Avantis ETL Server
Analysis Services Database ● The Analysis Services database (a multidimensional database) aggregates
the data based on predefined cubes, which are defined by the measures and
dimensions.
● The cubes are populated with data during data extractions, then available for
analysis and monitoring.
Analysis
Database
(Data Cubes)
Subject Matter
SQL Server
Database
Extraction &
Transformation
Process
(SSIS)
Avantis.PRO
2014 Software Global Client Conference
Avantis.DSS Viewing Service ● Dashboards created in Wonderware Intelligence are viewed from web
browser or Intelligence client
● 3rd party clients such as Microsoft SharePoint could also be leveraged as the
visualization mechanism Wonderware Intelligence
Web Clients 3rd Party Clients
Avantis ETL Server
Analysis
Database
(Data Cubes)
Subject Matter
SQL Server
Database
Extraction &
Transformation
Process
(SSIS)
Avantis.PRO
2014 Software Global Client Conference
Sample Dashboards
2014 Software Global Client Conference
Demonstration
2014 Software Global Client Conference
Related Support, Services, Training & Expo Demos
Peter Barbier, Director of Avantis Support, Mike Scholman and Cindy Dean, both Senior Technical Support Analysts, are all here at the conference and available to answer any of your questions.
Support can be reached at 1-888-262-7111
Or via email at [email protected]
Support
Training
Contact Roger Attwell, our Training Manager,
for any questions about training availability.
Services
Expo Demos
Please come see the Avantis Demos on the
Expo floor.
We are located at Demo Stations :
#6 -Remote Electrical Equipment Monitoring
#9-Enterprise Asset Management
#10-Condition-Based Maintenance
Please see Alok Pathak, Manager of Implementation
Consulting, for all your service needs and inquiries. Alok
is present at the conference and available to answer any
of your questions.