Government

Projects and Public Policy Support

Developing New Data System for Washington State's Office of Minority and Women's Business Enterprises http://omwbe.wa.gov

State of Washington’s Office of Minority & Women’s Business Enterprises (OMWBE) has requested support from Seattle Data for Good in establishing a new data mart related to the Linked Deposit Program. Establishing this data mart will allow OMWBE to consolidate firmographic, financial, and other program specific information into a single source and generate standardized self-service reports to highlight the value of the Linked Deposit Program for the state. For more information contact Sarthak at msarthak90@gmail.com.

Project Overview:

State of Washington’s Office of Minority & Women’s Business Enterprises (OMWBE) has requested support from Seattle Data for Good in establishing a new data mart related to their Linked Deposit Program. Establishing this data mart will allow OMWBE to consolidate firmographic, financial, and other program specific information into a single source and generate standardized self-service reports to highlight the value of the Linked Deposit Program for the state.

Project Roadmap:

This project will have a three-phased approach to establish a data mart, and provide a reporting solution for OMWBE.

Phase 1:

-        Identify all data sources from OMWBE and State Treasurer’s Office

-        Explore all data sources for consistency and establish primary keys to tie data across all sources

-        Create additional fields/columns as necessary to generate new KPIs/metrics

Output: Proof-of-concept dataset within Excel with data from all sources

Tools needed: Microsoft Excel

Level of Effort (LoE): Low

Phase 2:

-        Identify platform for database (Access, Azure)

-        Upload all relevant data files into established database (all separate excel files)

-        Create database connection across all sources

-        Create training material for uploading and updating relevant data tables

Output: Final database of all data sources with all connections established to generate key metrics

Tools needed: Microsoft Azure DB Instance or Microsoft Access

Level of Effort (LoE): High

Phase 3:

-        Links Azure or Access database with Business Intelligence tool (Microsoft PowerBI)

-        Establish all connections as necessary within BI tool to join relevant datasets for reporting

-        Create KPI dashboard for OMWBE/State Treasurer’s Office

Output: Linked Deposit Program dashboard within PowerBI containing all key metrics for program reporting

Tools needed: Microsoft PowerBI

Level of Effort (LoE): Medium

Public Policy

We have volunteers who have experience in the area of public policy. If your organization needs support in this area please send us a contact form.