SLIDE 1
Follow us on @CityofPAE www.cityofpae.sa.gov.au
Follow us on @CityofPAE www.cityofpae.sa.gov.au
Capital Works Operational Dashboard Presented by Leanne Hodge - - PowerPoint PPT Presentation
Capital Works Operational Dashboard Presented by Leanne Hodge - - PowerPoint PPT Presentation
Capital Works Operational Dashboard Presented by Leanne Hodge Geographic Information Systems Officer 18 th October 2018 Follow us on @CityofPAE www.cityofpae.sa.gov.au Follow us on
SLIDE 2
SLIDE 3
Follow us on @CityofPAE
- Initiated 18 months ago to map capital works projects
- ESRI Story Map created
- Budget and expenditure transparency
- Include scope/delivery of major projects
Introduction
SLIDE 4
Follow us on @CityofPAE
- Built with ESRI templates
- Tabbed theme (Story Map)
- Static pie chart information
- Limited interactivity
- Created Nov 2017
Background
SLIDE 5
Follow us on @CityofPAE
- Built with ESRI’s Operations
Dashboard
- Configurable web app
- Interactive and dynamic
elements
- Budget and expenditure
- Launched August 2018
Background
SLIDE 6
Follow us on @CityofPAE
Capital Works Planning Model
ETL
MS Excel
Data Entry
T echnology One Finance Extract
T echnology One CPM
T echnology One Finance
- Budget
- Actual
- Variations
- Commitments
T echnology One HR
- All Staff listings based on position
ETL
GIS Layer Table Extract ArcGIS Online
GIS
- SQL
View
- Update script
c c
SLIDE 7
Follow us on @CityofPAE
Building the Dashboard
SLIDE 8
Follow us on @CityofPAE
Smartphone compatibility
SLIDE 9
Follow us on @CityofPAE
- Visit cityofpae.sa.gov.au
- Development > Major Projects > Current Projects
How To Access
SLIDE 10
Follow us on @CityofPAE
Dashboard Demonstration
SLIDE 11
Follow us on @CityofPAE