talk-data.com talk-data.com

Event

dbt Coalesce 2020

2020-12-09 YouTube Visit website โ†—

Activities tracked

4

Filtering by: Data Modelling ×

Sessions & talks

Showing 1โ€“4 of 4 ยท Newest first

Search within this event →
Building a marketing attribution model with dbt

Building a marketing attribution model with dbt

2020-12-21 Watch
video
Evy Kho (Grailed)

This video covers what you'll need to build a marketing attribution data model and why it's important to have one to evaluate your business. It covers how the team at Grailed has built data models in an effort to determine where their users come from, where their orders come from, and more. It shares the value these models have unlocked for our marketing team and what it might unlock for yours!

Speaker: Evy Kho, Senior Operations Analyst, Grailed

Kimball in the context of the modern data warehouse: what's worth keeping, and what's not

Kimball in the context of the modern data warehouse: what's worth keeping, and what's not

2020-12-15 Watch
video
Dave Fowler (Chartio)

Dimensional modeling described in the Kimball Toolbook was in its 3rd edition 15 years ago yet is still the latest in data modeling advice. So much is different in cloud warehouses that many of those best practices are now bad practices. In this video Dave Fowler, the founder of Chartio and author of Cloud Data Management goes over what no longer applies, and what does.

How to complete a data modeling project at a $6B company

How to complete a data modeling project at a $6B company

2020-12-15 Watch
video
Vincey Au (Canva)

What does it take to implement a data modeling project when working at a company that's in hypergrowth? In this video, Vincey Au will take us through a recent project to incorporate mobile app data into Canva's sessionization model, with the added complexity of having to make this work on petabytes of data. She'll share some of the lessons learned along the way, and what they'd do differently if they were doing it again.

How to Audit Your Directed Acyclic Graph (DAG) and Create Modular Data Models

How to Audit Your Directed Acyclic Graph (DAG) and Create Modular Data Models

2020-12-10 Watch
video
Christine Berger (Fishtown Analytics)

In a world where creating new models in as easy as creating new files, and creating links between those models is as easy as typing ref, a directed acyclic graph (DAG) can get pretty unwieldy!

A complex DAG makes it difficult to understand the upstream and downstream dependencies of a particular table.

The goal is to create a modular data model using staging models (base_, stg_) and marts models (int_, dim_, fct_).

In this video, Christine Berger of Fishtown Analytics will teach you how to apply the concepts of layering and modularity to your dbt project, all with a fun kitchen metaphor to keep things fresh!

Learn more about dbt at: https://getdbt.com https://twitter.com/getdbt

Learn more about Fishtown Analytics at: https://fishtownanalytics.com https://twitter.com/fishtowndata https://www.linkedin.com/company/fishtown-analytics/