ACTIVITY & LOCATION BASED ANALYTICS
APPLICATIONS
SEAMLESS, REAL TIME MERGING OF GIS AND ERP SYSTEMS ALLOWING THE VISUALIZATION OF
RELATIONSHIPS, CONNECTIONS AND PATTERNS IN THE DATA FOR INTELLIGENT, INFORMED DECISION MAKING AND INCREASED EFFICIENCY
ABI WORKING GROUP
JOSEPH D. FARGNOLI
RITRE CORPORATION
ROCHESTER INSTITUTE OF TECHNOLOGY
DEPARTMENT OF COMPUTING AND INFORMATION SCIENCES [email protected] 585-298-8582
NOVEMBER 7, 2013
Agenda: GIS/ERP Integration for Commercial and Civil ABI
• Discuss current research issues surrounding the seamless integration of ERP and GIS systems as a practical ABI enabler.
• Examine the dynamic geo-enablement of ERP data to understand the visualization, spatial and temporal relationships between the data.
• Discuss components that integrate GIS data with an Enterprise Resource Planning (ERP) system in real time providing the ability to query, view and process business transactions in the ERP system.
• Look at examples of scalable Service Oriented Architecture based examples which reducing the go-live time for commercial/civil
implementation
Public Safety
Civil
Commercial
Education
Commercial and Civil Users are Practically Adopting ABI through GIS/ERP Integration
2Integrating GIS & BI to Visualize Better...Act Faster
Address the opportunity to provide organizations the capability to react to how location influences
changing business/mission processes in order to minimize risk and maximize opportunities
Applying the understanding of dynamic geographic based relationships to predict the impact on a business/mission outcome.
Actionable awareness of relationships between dynamic location information and
business/mission operations
Better Intelligence
Timely Actions.. Enhanced Efficiency
Reduced TCO - Improved Governance
Integrate existing ERP / Data Sources to geospatially based action
Fund Management:
Real Time Insight into Operations’ Expenditure in various Geographic Regions
Visualize Critical Vulnerabilities:
Management during Public Events / Emergency
Response
Healthcare:
Disease outbreak tracking / epidemic patterning
Asset Management:
Identify parts, facilities, or networks due for maintenance
Leverage & Unleash the Power of BI for Informed & Pro-Active Decision Making
Integrating Legacy Platforms into an ABI Framework
BOBJ IBM Cognos
MicroStrategy SharePoint
Esri Maps for BOBJ Esri Maps for IBM Cognos Esri Maps for
MicroStrategy Esri Maps for SAS
ESRI Product Expertise BI Platform expertise
Global Services
Delivery Resources
Global Professional Services
Service Execution
Esri Product Support
Esri Product Consulting Implementation Customization
Skills Incubation
Enhanced Training Culture
Advanced Technology Centre
Resources trained in
multi BI Platforms Methods & Procedures
• Low Turnaround Time
• Optimum Resource Utilization
• Excellent Quality standards
Research into the Cross Domain Platform Integration of BI and GIS Products and Process Standards Allows the Practical Implementation of Activity and Location Based Analytics
Public Safety ABI Solutions
The Real Time Crime Center solution improves the efficiency of Law Enforcement departments and also increases the safety of the police officers on field offering:
Common Operating Picture: Visualization of a common picture on a mapping interface by integrating data from various sources (Situational Awareness)
Integration with CAD, AVL and other Data Sources: Seamless integration and presentation of data in different formats and from various platforms in real time
Real Time Info: Ability to render real time information on a map to ensure police officers are well-informed (Asset Tracking, Satellite Tracking, Social Media Monitoring)
Route Analysis: Suggestions for best routes during operation or violent situations to manage situations efficiently and to reduce risk to police officers’ lives
Video Feed Integration: Availability of abundant live video feeds on map and option to view Plume Modeling: Provision for predicting the areas under risk in case of chemical and natural
hazards using different GIS models
Local Police Department
Architectural Overview
ArcGIS
• Imagery
• Data
• GeoProcessing
• Plume modeling
ArcGIS for SharePoint
• Geocoding
• Visualization
• Data integration
Fusion Core
• Workflow
• Intake forms
• Tracking
SharePoint
• Data integration
• Security
• Dashboards
• Office integration Police Data
• AVL
• Dispatch
• Gang Data
• Parolees &
Probationers
• Jurisdictions
City Services
• Maps
• Imagery
• Pictometry
• 311 Calls
• Parcel data
Cloud Services
• Street View
• Natural hazards
• Demographics
• Social networking feeds
An Emergency Management Configuration
Emergency Support Function
(ESF) Intelligent Maps Public
Information Logistics
Desktop & Models Planning & Analysis Risk Assessment Mobile
- Damage - Operations
ArcGIS Server
Portal for ArcGIS HTML Gallery ArcGIS Online ArcGIS Online Premium
Command
Existing Systems Enterprise
Database Operations
Tablet/Pad
ICS Alignment
Implementation Examples
Relating Information by Geography Aiding Computer Aided Dispatch
School reports
missing child
Parents notified/
located
Identify “best quick
suspects”
Dispatch officers/case workers to locate &
contact nearby/known child offenders
Gather name, contact info, address list
Identify high priority calls
Identify responder to call
Provide information on target destination
Make the responding officer safer &
more informed
Location Analytics for State & Local Governments
Drive mission-critical local governance objectives.
Quick, Efficient & Cost Effective data collection & management through Automated workflows &
Real Time Access to Data of all departments within organization.
Information infrastructure to facilitate optimum civic planning and development and a unified view into…
City Services : Maintenance of daily city services such as Public Transport management, Water Management, Solid Waste Management etc.
Planning & Development such as Town Planning
HealthTracking: Healthcare & wellness planning, Epidemic Control, Situational Awareness etc Property Tax Management: Property mapping, Revenue Analysis, Property Assessment
Public Safety: Fire Hazard & Mitigation, Flood management, Disaster Management , Crime Control management.
Citizen Portal: Municipal Problem Reporting, Citizen Service Management, Online Services
Commercial Application: Retail Product Distribution
Applications (web based and for the iPad) to help a client evaluate how GIS can add value to their critical business operations.
The Depletions Mapping Dashboard Application demonstrated the business intelligence capabilities of GIS by providing a map based sales dashboard for senior executives.
The Distributor Partner Manager Route Planner application developed for iPad,
demonstrated GIS’s routing and mobile capabilities. This application enabled a DPM to plan a route to visit client accounts and take notes on the go.
Commercial Application: Dashboards & Planning Tools
Sales Data
– Executive view
– Point of sale rolled up
through zip code, territory, region, business unit
Targeted Route Planner
– Route planner – Demographics – Segmentation
– Business Locations
Mobile Routing Manager
– Mobile (iPad) Route Planner – Sales data
– Distributor data
– Business locations
Integrating ERP and GIS
• Spatial View of Transactional Data
– Maintenance Notifications and Work Orders – Audit Status – Due, in-process, completed – Spatial analysis of historical data
• Data Updates from Map Interface
– Create, update and complete maintenance transactions – Maintain asset attributes from map interface
• Unified view of GIS and SAP attributes
• Attributes update happen in both backend systems
• User does not worry about where each attribute belongs
• Utility agencies benefitted
– Water, Sewer, Storm Drain, Gas Electricity, Telecom – Streets, Signal Shop
– Airport terminal and runway maintenance
• Locate where the network equipment is installed
• Contributes to find weaknesses in infrastructure before disaster hits
• Determine where the damage occurred
• Identify parts, facilities, or networks due for maintenance
Enterprise and Analytics
Water Utility Use Case – Fire Hydrant Audits
• Process Before Integration
• Paper based – field crew took paper maps
• Record observations and readings on paper
• Bring back papers to office
• Office staff created “Audit” notifications in SAP
• Complete data entry in SAP screens
• Where damage code was found, created another “Repair” notification
• Time consuming process, sometimes delayed, papers misplaced, etc.
• Difficult to track “Unaudited” hydrants
Asset and Work Management
Web Client
• Notifications
• Work Orders
• Spatial Query
• Temporal Query
Water Utility Use Case – Fire Hydrant Audits
• Benefits Achieved
Paperless, online process
Complete data entry through web browser – map interface
Automation in process flow and data entry
Where damage code was found, created another “Repair” notification
Huge time saving for field staff and office staff
Real time updates, errors, loss of data, etc eliminated.
“Due for Audit” and “Due for Repairs” Hydrants easily visible on the map.
• Implementation will be extended to other processes
Asset and Work Management
GIS/ERP Integration Features/Benefits
• Spatial View of Transactional Data
– Maintenance Notifications and Work Orders – Audit Status – Due, in-process, completed – Spatial analysis of historical data
• Data Updates from Map Interface
– Create, update and complete maintenance transactions – Maintain asset attributes from map interface
• Unified view of GIS and SAP attributes
• Attributes update happen in both backend systems
• User does not worry about where each attribute belongs
• Utility agencies benefits
– Water, Sewer, Storm Drain, Gas Electricity, Telecom – Streets, Signal Shop
– Airport terminal and runway maintenance
• Locate where the network equipment is installed
• Contribute to finding weaknesses in infrastructure before disaster hits
• Determine where the damage occurred
• Identify parts, facilities, or networks due for maintenance
Other Areas: Integrating GIS and Business Intelligence
• Linking of GIS and BI, two highly complementary technologies, in an integrated solution.
• Plugs GIS for BOBJ or for IBM Cognos directly into dynamic day-to-day Business Intelligence report viewing, authoring and deployment workflow.
Transportation
• Monitor traffic and regularity
• Enhance operational efficiency and finance control
• Monitor maintenance and investment actions
• Track billing and price options
• Enhance communication
Telecom
• Data Visualization & Reporting
• Geo-marketing & Trade Areas Analysis
• Regulatory & Environmental Compliance
• Resource Allocation
• Network Infrastructure Monitoring
• Sales Territory Management
