~/talk

Data Plumbing 101 - ETL Pipelines for Everyday Projects

Talkat PyCon.DE 2017 · 2017-10-25..10-27· [data-visualization, python]
links:none on file
slides:none on file

Claims a concrete setup that turns dozens of brittle scripts into a traceable pipeline, reducing a tangled “17 import scripts” workflow to managed tasks. Implements an actual library Ozelot that glues Luigi and SQLAlchemy to provide an ORM base, database session handling, Luigi task classes and an ORM target marker for task completion. Shows a running ETL pipeline, a reproducible relational data model and a small interactive dashboard built on the imported data.

AI-written summary · about

  1. 0:00Intro
  2. 8:30Data Model
  3. 17:00Interactive Explorer
  4. 20:25Conclusion
  5. 22:40Questions
  6. 26:05Demo
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.