Provide dashboards of public service requests made by residents to various departments in the City of Phoenix.

Government:

City of Phoenix

Category:

Data Analytics, Data Collection, CRM / Application Management, Resident Engagment

Budget:

Budget Not Determined Yet

Procurement Method:

RFP
View doc

Application Period:

October 16, 2019 - November 20, 2019

Q&A Period:

October 16, 2019 - November 6, 2019

Challenge

The City of Phoenix is seeking a mechanism to export the CRM data from our Microsoft Dynamics CRM platform to a SQL Server database in Azure solution to to facilitate rapid dashboarding so we can provide for our city leadership and residents with realtime dashboards on city service requests efficiencies.

Background

 The City of Phoenix utilizes Microsoft Dynamics CRM to facilitate service requests with various departments.   These requests can be requested via the portal at https://www.phoenix.gov/atyourservice  These requests cover the range of services from Water start/stops, Public Works trash can requests to reporting discrimination cases to Phoenix Police Public Records Requests to reporting homelessness. 

Requirements & Outcome

 1.     Provide a mechanism to export the CRM data to a SQL Server database in Azure. The City already utilizes Azure to host the Dynamics CRM, Azure B2C and other IaaS, PaaS based services from Microsoft. 
2.     Facilitate rapid dashboarding.  The objective of this challenge is to implement an ETL which exports the data to the SQL Server database in Azure on a configurable interval. 
3.     The City of Phoenix Business Intelligence and Data Analytics team will then utilize their Oracle analytics platform/OBIEE tools to create dynamic dashboards with data from the SQL Server.