By the end of 2020, create a County Data Policy and County Data Strategy (including an implementation & sustainability plan) to: 1) drive decisions and enhance business outcomes; 2) improve data efficiency, consistency, quality, and security; and 3) promote departments data sharing.
By the end of 2023, complete at least two projects utilizing and refinishing this structure to provide a model for all future data projects.
January 2022
Data catalog - Vendor work is complete, transitioned project ownership to Business Intelligence team on January 11, 2022 to start onboarding known data sets and work with G3O4 Subject Matter Experts to bring Sheriff, Community Justice Alternatives, and Health data into the tool. Continue to work with the vendor's Customer Success Manager for ongoing training or support.
Data Strategy - Team Member is working to document and outline recommendations and decisions for the next major items remaining related to the data strategy, specifically the data governance committee, data support structure, and data culture shift/training program. This includes identifying questions and direction needed from county leadership. The goal is to have these ready for team review in March and leadership review in June.
Unified Credit Card Processing - The team is finalizing draft RFP, it expected to be released in Feb, and vendor selection by June.
July 2021
Data.world (data catalog software) implementation is in process. The internal team will begin working in the catalog in the next few weeks. The team continues to work on identifying people and processes to assist in accessing the data across the County. The team has started to establish the responsibilities of data stewards and data owners.
March 2021
The data catalog software vendor has been selected, and the team is currently working through the contracting process.
October 2020
Policy is out for employee comments. Data Analyst begins on November 5, 2020. Data catalog selection is hopeful by the end of 2020.
July 2020
Preparing for July 29th Commissioner session to review updated objective & proposed policy. Data Strategy is nearly complete.
- The team is working on a work plan or timeline to break down how/when this Data Strategy will be worked on by the team.
Drafting BBoard page layout, scheduling time with Internal Communication staff to discuss.
Recruiting 3-4 Data User Group (DUG) members to fully join the team, allowing DUG to revert back to the lunch-time/fun data group that it was formerly.
Unified Credit Card Processing project team is reviewing the current policy and preparing for the county-wide kick off with all department/office cc contacts (to review the project scope/timeline, and expectations for each participant).
April 2020
Restructuring the Objective - the main focus is on the Data Strategy and providing structure and security for the County to use and share data. Need to:
- Update objective language
- Create a Data Strategy policy
- Create Objective Plan (outlines cornerstones and supporting goals to achieve Data Strategy - how we will know that this objective was successful)
Presented to Dept Heads on 3/13 to introduce the concept - well received.
Starting to work on providing county updates via Inside Information & Objective BBoard page.
Credit Card Project: Assistant County Manager & the Treasurer are sponsoring, requested carryover funding. The project prioritized by ITSC. The team is starting to structure the project and prepare for kick-off in June.
January 2020
Service Proposal has been approved. The team has prepared or is currently working on:
- Data Analyst job description (in progress, finalizing with HR)
- High-level timeline of projects (work in progress)
- RACI matrix (outlines roles and tasks for our team/DUG)
- Unified Credit Card Processing project (created a new charter for the work needed, taking this through the new Governance process for prioritization)
The DUG (Data User Group) has started on the Data Strategy framework that will support all of our projects. The DUG subcommittees have completed initial work on Roles and Responsibilities, best practices, and metadata requirements. Additional subcommittees are addressing:
- Gathering requirements and evaluating data cataloging tools
- Accessing data issues and general pain points (including root cause analysis)
- Data request and data onboarding processes
Foundational client directory - the client directory will be the foundation that all of the other client-data projects will build from (County Whitepages, Index of County Services, and Offender/Client Repository). We are starting to gather requirements and build user stories in preparation for the Data Analyst.
November 2019
The team is working on cleaning up and clarifying the project names/descriptions to be better understood across the county. Three of the four projects are centered on client data - the next step for these is to create a single client list. To do this, the team has identified 6 universal client data attributes and is investigating/documenting what data sources are used in the county and which offer access to these 6 attributes.
Data User Group (DUG) has agreed to work with our team on creating a Data Strategy. DUG will be tackling the preliminary work needed to move forward with the three people-data projects.
- Preliminary work: Define roles (data stewards), process/framework, identify/document data sources - including sharing and matching across systems
- The basic framework developed by Q1 2020
- DUG will also work on data cataloging once a tool is selected
- The objective team will then be able to move forward with individual projects to access data in specific ways (ex: Providing offender/client information to HS and CJS)
August 2019
Initial four projects have been identified. Selected projects are 1) Developing and maintenance of general Resident Directory 2) Offender/Client compliance repository 3) Unified Service Experience / Index of County Services, service recommendation 4) Standardization of County-wide Credit Card Processing. Service Proposal submitted for additional resources, short term person, and data tool.
May 2019
The Objective Team did the following:
- Reviewed the initial potential project idea list - (12 ideas), at a high level. The team felt we need more specific project information (problem statement, etc) to better understand project outcome, how it impacts, what problem we are solving before we go into detailed discussion and prior to selection.
- Discussed and agreed on developing a list of project selection criteria and a selection model. The team will start putting a shared document to collect ideas on selection in the next meeting, to start developing a selection model.
- The general consensus - First project shall be selected in a month or so, using the agreed/weighted selection criteria/model, then evolve the model based on the learning and experiences from the first one.
- Proposed few new approaches a) Developing a data strategy document to assist in data governance/ sharing model in future b) A project delivery framework that includes business road-show to gather and also help validate project ideas.
- Discussed selecting project management tools, the methodology will be needed as soon as the first project is selected.