View Important Policies and System Requirements for this course

Interested in registering 5 or more engineers for a course? Contact us for information and rates.

INSTRUCTOR: 
Alfredo Cely, P.E., MSEM, M.ASCE

This course is part of the Geographic Information Systems for Asset Management Certificate Program.

Purpose and Background

The main intent of this course is to assist practitioners in development, maintenance, and operation of spatial databases within infrastructure management applications. Spatial databases are the brain of spatial information systems used to manage infrastructure asset data for private and public agencies, such as municipal utility agencies, state transportation departments, or regional telecommunication companies. The structure and use of asset management spatial databases and processes should be planned in advance because they are an integral part of the development of Asset Management GIS platforms. This course is divided into three key chapters. In the first chapter, the course will cover key elements needed for the development of spatial databases. Through the second chapter, practitioners will learn effective methods used to maintain asset management databases used for spatial analysis. And in the last chapter, concepts will be covered in the management required to operate spatial databases successfully within asset management applications.

Benefits and Learning Outcomes

Upon completion of this course, you will be able to:

• Based on a specific asset management GIS application, develop a framework for calculating the return on investment for the new platform.
• Using a return on investment (ROI) framework, calculate the ROI for a specific GIS asset management application.
• Identify two industry practices for the development of sustainable enterprise information portals.
• Create a GIS development plan that uses at least 3 of the 7 success strategies outlined by the National Council of Highway Research Program for implementing GIS tools in asset management.
• Based in a motivation factor, develop an action plan for implementing a GIS application within an asset management agency.
• Based on an asset management action category, determine at least one performance measurement to be used to evaluate a new GIS application.
• Describe at least two differences between internal and external programmatic risks within asset management agencies.
• Use at least three strategies for promoting sustainable enterprise information portals.
• Analyze and properly employ public bid tabulations.
• Develop unit price databases.

Assessment of Learning Outcomes

Achievement of the learning outcomes by attendees will be assessed through (3) exams.

Who Should Attend?

• Public agency engineers and planners
• Consultant engineers
• A/E contractors
• GIS analysts and project managers

How to Earn your CEUs/PDHs

This course is worth 2.4 CEUs/24 PDHs. To receive your certificate of completion, you will need to complete (3) exams and receive a passing score of 70% or higher.

How do I convert CEUs to PDHs?

1.0 CEU = 10 PDHs [Example: 0.1 CEU = 1 PDH]

---

Course Outline

Week 1: Determining a Return-on-Investment Framework
Course Introduction & Week Introduction
Using a Benefit Cost Analysis Approach
Learning Exercise - Decision Making and Asset Management Investments
Benefit and Cost Categories
Methods for Estimating Benefits
Performance Measurement
Assessment of Returns on Investment
Learning Exercise - Advantages and Disadvantages of Quantitative Methods
Conclusion

Week 2: Calculating the Return on Investment
Introduction
Return on Investment Methodology
Define Purpose and Identify Impacts
Learning Exercise - Asset Management Investment Checklist
Evaluate Available Data
Establish Modeling Framework
Collect Data and Conduct Analysis
Estimate ROI and Summarize Results
Learning Exercise - Apply Engineering Economic Metrics
Conclusion

Week 3: Sustainable Enterprise Information Portals
Introduction
Cloud and On-Premise IT Infrastructure - I
Cloud and On-Premise IT Infrastructure - II
Learning Exercise - Cloud and On-Premise Cost Comparison
Distributed Software Architecture
Layered and Event-Driven Systems
Use of Open Source and Existing Software
Microservices Architecture
Learning Exercise - Application of Microservices
Conclusion

Week 4: Seven Ingredients for Success in Asset Management
Introduction
Main Elements for Asset Management Success
Management Commitment and Alignment
Learning Exercise - Building Blocks for Asset Management
GIS Tools and Proactive Data Stewardship
Foundational Geospatial Data
Data Standards and Management Systems
Coordinated Data Collection
Learning Exercise - Challenges and Strategies
Conclusion
Exam: Weeks 1-4

Week 5: Performance Management
Introduction
Overview of Performance Management
Evaluation Approach - I
Evaluation Approach - II
Learning Exercise - Five Steps for Performance Measurement
Recommended Measures - I
Recommended Measures - II
Gap Assessment
Learning Exercise - Measure Types and Performance Measures
Conclusion

Week 6: Risk Management
Introduction
Internal and External Nonprogrammatic Risks
Higher Consequence Risks for Threats and Hazards
Risk Assessment Process
Identify Hazards and Develop Threat Scenarios
Risk Mitigation Strategies and Priorities
Institutional Risk Management Responsibilities
Learning Exercise - Case Study # 1
Conclusion

Week 7: Financial Metrics
Introduction
Lagging and Leading Measures
Financial Sustainability Metrics
Learning Exercise - Differences in Financial Metrics
Percent of Conditions Meeting Target
Asset Sustainability Ratio
Debt Ratio
Financial Adequacy Measures
Learning Exercise - Sustainability Index Calculation
Conclusion

Week 8: Life-Cycle Planning
Introduction
Overview of Life Cycle Planning
Key Life Cycle Planning Concepts
Learning Exercise - Organize a Life Cycle Plan
Life Cycle Planning Approach to Managing Infrastructure Assets
Five Steps to Create Life Cycle Plans
Selecting Assets and Defining Strategies
Set and Develop Scenarios to Provide Financial Planning Inputs
Learning Exercise - Life Cycle Planning Scenarios
Conclusion
Exam: Weeks 4-8

Week 9: Strategies for Promoting Sustainable Enterprise Information Portals
Introduction
Acceptance of New Concepts
Develop Workforce - I
Learning Exercise - Successful Messages
Develop Workforce - II
Training, Champions, and Communication
Establish and Maintain Policies
Evaluate and Share Outcomes
Learning Exercise - Procurement Policies
Conclusion

Week 10: Integrating Data
Introduction
Goals of Data Integration
Data Integration Benefits
Learning Exercise - Business Processes and Benefits
Analysis of Requirements
Data and Process Flow Modeling
Database Design and Specifications
Challenges to Data Integration
Learning Exercise - Integration Challenges and Strategies
Conclusion

Week 11: Incorporating Asset Valuation
Introduction
Benefits of Asset Valuation - I
Benefits of Asset Valuation - II
Learning Exercise - Estimates Versus Absolutes
U.S. Valuation Process
Asset Valuation as an Investment
Balancing Value and Depreciation
Asset Valuation Performance Measures
Learning Exercise - Depreciated and Historic Cost Conclusion

Week 12: Maintenance Sustainability Ratio
Introduction
Select Maintenance Activities
Data Analysis
Maintenance Expenditure Analysis
Legislative Reporting
Combining Ratios into an Index
Learning Exercise - Case Study # 2
Week and Course Conclusion
Exam: Weeks 9-12