CAP Data Dashboards 2022-2023

THE PROBLEM The San Francisco Office of Civic Engagement and Immigration Affairs (OCEIA) had a large dataset on the services provided by the Community Ambassadors Program (CAP). However, the multi-dimensional data lacked a clear and effective way to visualize and understand the information. This complexity made it difficult to evaluate program effectiveness and inform strategic decision-making. THE SOLUTION I led the development of data dashboards that visualize over 260,000 services provided by the Community Ambassadors Program (CAP) from 2022-2023, transforming complex datasets into actionable insights as a data engineer. I designed and developed over 20 interactive dashboards and graphs using Power BI, Excel, and SQL, ensuring accuracy and supporting data-driven strategies to help the stakeholders evaluate program effectiveness and make informed decisions.