AnEx Learning Summit 2024

[damonmcc]

On 10/23, we're presenting as part of OTI's Analytics Exchange. Our event (link) is called "DuckDB and dbt: How to build a modern data pipeline".

OTI plans to collect slides and materials before the event. They didn't give an exact data, planning for 10/11.

• share slides with OTI
• practice presentation with DE on 10/22
• revise slides from practice feedback
• revise code
  • @sf-dcp's ideas in old repo here
  • from practice feedback
• ensure all code runs

materials

From pervious discussions and OTI's advise, we probably want:

• slides to give background and details
• a repo with code to serve as a tutorial: anex-summit-2024-demo

background

I started this personal repo to learn and experiment with duckdb + dbt: https://github.com/damonmcc/duckdb-dbt

Our School of Data 20204 PLUTO slides

Slides from a dbt presentation I gave to Finn, Max, and Amanda

[damonmcc]

significant notes from 10/22 practice

• make it clear they don't have to run code
• less focus on DCP DE team and infra
• go through ETL blackbox slides without explaining boxes
• describe why DuckDB is helpful
  • problem -> how we normally work -> why it didn't work
• for DuckDB slides
  • "it can be a faster, better DataFrame"
  • keep amount of jargon low
• describe why dbt is helpful
  • when SQL queries getting unruly
  • organizing SQL code
• note that dbt requires a DB (before the demo)
• try using notebooks to run code rather than CLI
• stop for Qs after each demo (5 minutes max?)