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

▶
e t l
SMART_READER_LITE
LIVE PREVIEW

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

Feb 14, 2023 308 likes •634 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

slide-1
SLIDE 1

The underestimated requisite to being data-driven

E.T.L.

slide-2
SLIDE 2

E.T.L.

1 Overview of our office 2 Background on open data 3 Our journey to ETL 4 Key takeaways

The underestimated requisite to being data-driven

slide-3
SLIDE 3

Open Data & Digital Transformation

Office of

slide-4
SLIDE 4
slide-5
SLIDE 5
slide-6
SLIDE 6
slide-7
SLIDE 7

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

slide-8
SLIDE 8

People Process Information Channels Infrastructure

+ Policy + Funding sources + Human resources + Physical infrastructure + Tech infrastructure

Building a service design practice

Evaluation lens

+ Context & history + Mindset and bias + Motivations + Needs + Power dynamics + Digital & analog workflows + Content and quality of information communicated across channels + Digital + Paper + Phone + Physical space + Person to person

slide-9
SLIDE 9

End-to-end service improvements

slide-10
SLIDE 10

Open Data

slide-11
SLIDE 11

11

slide-12
SLIDE 12
slide-13
SLIDE 13
slide-14
SLIDE 14
slide-15
SLIDE 15

Why open data

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

slide-16
SLIDE 16
slide-17
SLIDE 17
slide-18
SLIDE 18
slide-19
SLIDE 19
slide-20
SLIDE 20
slide-21
SLIDE 21
slide-22
SLIDE 22
slide-23
SLIDE 23
slide-24
SLIDE 24
slide-25
SLIDE 25
slide-26
SLIDE 26

Our journey to Extract Transform Load

slide-27
SLIDE 27

Voter registrations Voter turnout

slide-28
SLIDE 28
  • Scheduling
  • Validation
  • Alerts
  • Logging, debugging
  • Hosting, scalability
  • Maintenance
slide-29
SLIDE 29
slide-30
SLIDE 30

Takeaways

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

slide-31
SLIDE 31

Thanks!

@timwis tim.wisniewski@phila.gov