TO: Committee of the Whole - Finance, Administration, and Communications
FROM: Mayor Angela Birney
DEPARTMENT DIRECTOR CONTACT(S):
Technology and Information Services
Michael Marchand
425-556-2173
DEPARTMENT STAFF:
Technology and Information Services
Melissa Brady
Information Services Manager, Enterprise Data and GIS
TITLE:
title
Enterprise Data and GIS Program Update
OVERVIEW STATEMENT:
recommendation
The Enterprise Data Management and Geographic Information System (EDM/GIS) group is part of the City of Redmond's Technology and Information Services Department. The EDM/GIS Group is tasked with developing, maintaining and administrating the City's enterprise data programs. We would like to provide Council an overview of major 2023 Enterprise Data and GIS Program accomplishments and to also highlight some current work that is being done in 2024. Partners are noted in parenthesis.
Major 2023 Accomplishments
Demographics Dashboard Phase 1 and 2 (Planning)
* Interactive Dashboard released in 6/2023 on Redmond.gov
* Dashboard shows Population and Housing data, Covered Employment data
* Demographics and Statistics | Redmond, WA
Environmental Sustainability Dashboard Phase 2 (Executive)
* Interactive Dashboard originally released in March 2022
* Phase 2 data included Fish Barrier on Class 2 Streams and Stream Length Complexity Good or Better
* Phase 1 data refreshed in 2023
* Environmental Sustainability Data Dashboard | Redmond, WA
D365/Dynamics AX Reporting Platform (Finance)
* Internal Reporting Platform developed for financial data merging our legacy Dynamics AX and D365
* Migrated from Excel reports to modern Microsoft Power BI
* Reports include Budget vs. Actuals, Voucher Transactions, Project Reports, Purchase Requisitions and more.
* Future phases include publishing financial reports to Redmond.gov
Fire Prevention EnerGOV Reporting Platform (Fire)
* Operational Reports for Fire Prevention from EnerGOV permitting system
* Reports include Development Pe...
Click here for full text