e t l
play

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

Feb 14, 2023 •308 likes •630 views

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

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

  2. 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

  3. Office of Open Data & Digital Transformation

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

  8. 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

  9. End-to-end service improvements

  10. Open Data

  11. 11

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

  26. Our journey to E xtract T ransform L oad

  27. Voter registrations Voter turnout

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

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

  31. Thanks! @timwis tim.wisniewski@phila.gov

Recommend

More recommend