Greenman-Pedersen, Inc. (GPI) is a multi-disciplinary civil engineering firm with projects covering the eastern half of the United States. While the information GPI uses to manage clients and projects is stored in an Enterprise Resource Planning (ERP) Software, it is not easily viewable in a map, and therefore unavailable for any spatial analyses.
The Innovation Team at GPI has used the existing ERP data to create an Internal Mapping Application for assisting directors, project managers, engineers, marketing specialists, and other employees to realize various operational efficiencies using previously unmapped data.
This presentation will cover the end-to-end dataflow of the project. Beginning at the initial inputs in the ERP software, and the ETL (Extract, Transform & Load) process where the data is geocoded, cleaned and transformed using a combination of SQL and Python. The data is then securely provided to GPI staff using ArcGIS Online and ArcGIS Enterprise.
While the application is still in beta staff have already begun utilizing the data to enhance their existing workflows, particularly in marketing and branch logistics. Others, such as our corporate safety team, are using it to create completely new workflows which will save significant time and effort in their day-to-day tasks.