capital works operational dashboard

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


  1. 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

  2. Follow us on @CityofPAE www.cityofpae.sa.gov.au

  3. Introduction • Initiated 18 months ago to map capital works projects • ESRI Story Map created • Budget and expenditure transparency • Include scope/delivery of major projects Follow us on @CityofPAE

  4. Background Built with ESRI templates • Tabbed theme (Story Map) • Static pie chart information • Limited interactivity • Created Nov 2017 • Follow us on @CityofPAE

  5. Background • Built with ESRI’s Operations Dashboard • Configurable web app • Interactive and dynamic elements • Budget and expenditure • Launched August 2018 Follow us on @CityofPAE

  6. Capital Works Planning Model MS Excel Table Extract ETL T echnology One CPM c c GIS Layer Data Entry ETL T echnology One Finance - Budget - Actual GIS -Variations - SQL View T echnology One - Commitments - Update script Finance Extract T echnology One HR - All Staff listings based on position ArcGIS Online Follow us on @CityofPAE

  7. Building the Dashboard Follow us on @CityofPAE

  8. Smartphone compatibility Follow us on @CityofPAE

  9. How To Access Visit cityofpae.sa.gov.au • Development > Major Projects > Current Projects • Follow us on @CityofPAE

  10. Dashboard Demonstration Follow us on @CityofPAE

  11. Thank you Questions? Follow us on @CityofPAE

Recommend


More recommend