E.T.L. The underestimated requisite to being data-driven E.T.L. - PowerPoint PPT Presentation

E.T.L. The underestimated requisite to being data-driven

E.T.L. The underestimated requisite to being data-driven Overview of our office 1 Background on open data 2 Our journey to ETL 3 Key takeaways 4

Office of Open Data & Digital Transformation

Co-creating prevention, diversion, and intake service improvements with staff, service partners, and people experiencing homelessness

Building a service design practice Evaluation lens Information People Process Channels Infrastructure + Context & history + Digital & analog + Content and + Digital + Policy + Mindset and bias workflows quality of + Paper + Funding sources + Motivations information + Phone + Human resources + Needs communicated + Physical space + Physical infrastructure + Power dynamics across channels + Person to person + Tech infrastructure

End-to-end service improvements

Open Data

11

Why open data Improves transparency and accountability 1 Drives business 2 Enable data-driven decisions 3 Empowers and informs 4 Drives civic engagement 5

Our journey to E xtract T ransform L oad

Voter registrations Voter turnout

Scheduling Logging, debugging ● ● Validation Hosting, scalability ● ● Alerts Maintenance ● ●

Takeaways ETL is unavoidable 1 Build in-house competency 2 Consider it when investing in new systems 3 Leverage existing infrastructure and expertise 4

Thanks! @timwis tim.wisniewski@phila.gov