This session shares Rivian’s journey building an analytics ecosystem from scratch over the last two years, centered around dbt and dbt Cloud. Through this work, Rivian is driving towards a healthy data mesh that links data and developers across many domains at the company, to enable rapid growth and value as they ramp to produce their new fleet of EVs and keep the world adventurous.

Speakers: Will Bishop, Manager, Data Science Analytics, Rivian

Register for Coalesce at https://coalesce.getdbt.com

Fanduel, America's leading sports betting company, migrated all of its data pipelines to integrate with dbt Cloud in order to make data transformation processes more reliable, scalable, and maintainable.

In this presentation, the Fanduel team shares the challenges faced during the migration, including overcoming the inertia of established data infrastructure, integrating with legacy systems, and ensuring a smooth transition without disrupting ongoing data operations. The migration process fostered newfound collaboration among data analysts, product owners, and engineers, with the added benefit of accommodating future business needs.

Speakers: Phillip Tan, Technical Program Manager, Fanduel; Michael Lee, Senior Data Engineer, Fanduel; Harry Williams, Senior Data Engineer, FanDuel

Register for Coalesce at https://coalesce.getdbt.com

With dbt and the modern data stack, onboarding and surfacing data has never been more manageable for analytics engineers. Still, 85% of data products never make it into production. Why do data practitioners struggle to create data products that engage the people who actually use them?

Join Jake and Nate as they discuss how integration and collaboration can drive user engagement, ultimately leading to increased adoption. They’ll present guiding principles and three real world examples of data products designed to center and empower business users to: - Replace the need for seeds using materialized Sigma input tables - Create and manage HubSpot contacts and segments using Sigma’s HubSpot template - Sync insights from Sigma directly to downstream systems using the Hightouch integration.

The lessons learned from building a data platform at Sigma will provide everyone a framework for fostering collaboration between data teams and business users so they can raid insights, move up the leaderboard, and level up their gameplay no matter what data stack they use.

Speakers: Nate Meinzer, Director of Partner Engineering, Sigma Computing; Jake Hannan, Senior Manager, Data Platform, Sigma Computing

Register for Coalesce at https://coalesce.getdbt.com

In this session, Yijun Cao and Dakota Kelley highlight how dbt plays a key role in MuleSoft’s modern data analytics framework. As MuleSoft continues to grow, the data platform engineering team encountered some challenges with the data transformations. The session dives deeper into the specific challenges faced by the team and demonstrates how dbt’s features including CI/CD, testing, documentation and lineage help overcome these challenges.

Speakers: Yijun Cao, Data Platform Engineer, Salesforce; Dakota Kelley, Solution Architect, phData

Register for Coalesce at https://coalesce.getdbt.com

During the data team's short tenure (2.5 years) at ClickUp, they have built and scaled a fully modern data stack and implemented a warehouse-first data strategy. ClickUp's data is comprised of thousands of dbt models and upstream/downstream integrations with nearly every software at ClickUp. ClickUp uses dbt Cloud and Snowflake to power dozens of downstream systems with audience creation, marketing optimization, predictive customer lifecycle ML, a PLG/PLS motion, and much more. This session covers the foundational principles ClickUp follows and how warehouse-first thinking has unlocked tremendous value for ClickUp.

Speakers: Marc Stone, Head of Data, ClickUp

Register for Coalesce at https://coalesce.getdbt.com

Continuous Integration (CI) in dbt Cloud makes it easy to test every change you make prior to deploying. It’s a hallmark of mature analytics workflows. We’ve made some major improvements to dbt Cloud CI, so it’s easier than ever to prevent breaking changes, save on costs, and keep those pesky stakeholders happy.

Join the dbt Labs product team on this magical journey to a world of better data quality, and see for yourself what CI can do for you.

Speaker: Grace Goheen, Product Manager, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

Leveraging the power of RudderStack and dbt, Canadian Football League’s (CFL) data team abstracts the complexity of data in the warehouse and provides their marketing team with highly targeted audiences across a large variety of platforms and data sources. During this session we’ll hear how CFL went from manually sharing CSV files to modeling targeted segments, directly focused on OKRs, in their warehouse.

Speakers: Eric Dodds, Head of Product Marketing, RudderStack; Dave Musambi, Sr. Director, Business Intelligence, Canadian Football League

Register for Coalesce at https://coalesce.getdbt.com

Join Ryan Dolley and Jan Soubusta for a journey into the world of end-to-end analytics pipelines and how they can be a data engineer's best friend.

Learn how to automate boring tasks and create a safe haven for data engineers using the dynamic duo: dbt for transformative magic and GoodData for analytics awesomeness.

Combined with an data extraction and orchestration tools, you form the Voltron of easy to automate end-to-end analytics flows bringing data from source systems all the way through BI and to your end users.

And don't miss the grand finale where they reveal an alternative deployment on dbt Cloud that's so easy to orchestrate your coffee mug could do it. Prepare to laugh, learn, and level up your data game!

Speakers: Ryan Dolley, VP of Product Strategy, GoodData; Jan Soubusta, Distinguished Software Engineer, GoodData

Register for Coalesce at https://coalesce.getdbt.com

dbt has been adopted as an industry standard, now used by more than 25,000 organizations. For larger companies with more complex deployments, however, it can still be a challenge to sustain efficient collaboration around data development without sacrificing governance. Here is how dbt Cloud is helping to overcome that challenge.

Speakers: Jeremy Cohen, Product Manager, dbt Labs; Cameron Afzal, Product Manager, dbt Labs

The Lakehouse architecture unites the structured world of analytics with the rapidly evolving world of AI.

But what really makes something a “Lakehouse” and why should you care? In this session, Databricks discusses the key components of a lakehouse, what you should look for when adapting this paradigm and how Databricks and dbt are together enabling analytics engineers, analysts and data scientists to collaborate together on a single unified platform. You’ll hear from a customer about how they leveraged dbt Cloud on Databricks to deliver powerful customer experiences quickly and efficiently. Ken Wong shares the latest capabilities of Databricks platform and provides a sneak peek of upcoming features.

Speakers: Ken Wong, Senior Director of Product Management, Databricks; Samuel Garfield, Analytics Engineer, Retool

Register for Coalesce at https://coalesce.getdbt.com

Learn how dv01 uses dbt Cloud and BigQuery to create a scalable and modern data pipeline for offerings in loan warehousing analytics. These products serve an esoteric niche of finance and are run by a team of financial analysts with deep industry expertise.

With the challenge of tracking the performance of millions of loans from various sources and file structures, the team initially relied on Excel-based workflows. However, as the client base grew, they needed a reliable solution: a scalable data pipeline with dbt Cloud and BigQuery that allows the team to scale into a growing market and provide innovative new products and services.

Explore the transformative power of dbt Cloud in modernizing unscalable data processes, fostering skill development, and driving success in the specialized world of loan warehousing finance.

Speaker: David Maguire, Data Engineer, dv01

Register for Coalesce at https://coalesce.getdbt.com

In this session, gain strategic guidance on how to deploy dbt Cloud seamlessly to a team of 5-85 people. You'll learn best practices across development and automation that will ensure stability and high standards as you scale the number of developers using dbt Cloud and the number of models built up to the low thousands.

This session is a great fit for folks with beginner through intermediate levels of experience with dbt. In basketball terms, this talk covers mid-range shooting skills, but does not go into detail about 3-pointers, let alone half court shots. Likewise, this talk is not for people who are brand new to dbt and aren't familiar with the basic architecture of dbt and the modern data stack.

Speakers: Chris Davis, Senior Staff Engineer, Udemy, Inc.

Register for Coalesce at https://coalesce.getdbt.com

Seven years ago, in the early days of dbt, dbt Labs was building capabilities that made data developers more productive. dbt gained traction. It took off. Today, dbt is the standard for data transformation. It has never been easier to build and ship data products. This has created a new challenge – complexity.

Drew Banin, Co-Founder and Product Manager at dbt Labs, and Michelle Ark, former dbt power user who is now a Staff Software Engineer at dbt Labs, share the latest releases in dbt and how they help organizations navigate complexity.

Speakers: Drew Banin, Co-Founder, dbt Labs; Michelle Ark, Staff Software Engineer, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

In this session, learn how Prime Therapeutics' data team was able to implement dbt for multiple teams and environments in a highly-controlled way without compromising security or performance. With multiple teams and environments, it was essential to manage and maintain consistent policies across environments while helping share best practices to improve their dbt implementations.

Speakers: Jill Aakhus, Principal Analytics Engineer, Prime Therapeutics; Anubhav Pareek, Data Analytics Engineer, AICG

Register for Coalesce at https://coalesce.getdbt.com

Take a look at how the finance data team at Snowflake leverages dbt to drive strategic decision-making within the finance and accounting organizations. This talk spans topics including development velocity, cost governance, and data stewardship.

Speakers: Sandra Herchen, Analytics Engineering Manager, Snowflake; Jack Peele, Business Intelligence Analyst, Snowflake

Register for Coalesce at https://coalesce.getdbt.com

Unlike transforming staged data to marts, ingesting data into staging requires robustness to data volume and type changes, schema evolution, and data drift. Especially when performing change data capture (CDC) on large databases (~100 tables to a database), we’ll ideally reinforce our dbt models with automatic:

• Mapping of dynamic columns and data types between the source and the target stag
• evolution of stage table schemas at pace with incoming data, including for nested data structures
• parsing and flattening of any arrays and JSON structs in the data.

Manually performing these tasks for data at scale is a tall order due to the many permutations with which CDC data can deviate. Waiting to implement them in mart transformation models is potentially detrimental to the business, as well as doesn’t reduce the complexity. Santona Tuli shares learnings from integrating dbt Core into high-scale data ingestion workloads, including trade-offs between ease-of-use and scale.

Speaker: Santona Tuli, Head/Director of Data, Upsolver

Register for Coalesce at https://coalesce.getdbt.com

Join us for story hour, as we follow two intrepid analytics engineers working in a large dbt project as they go on a journey to meshify their dbt project, with help from a ✨special guest✨

Along the way, learn about dbt-meshify - a new CLI tool to automate the creation of model governance and cross-project lineage features in your dbt project. dbt-meshify refactors your code for you, helping you add model contracts, versions, groups, access, cross-project lineage, and more -- all in a matter of minutes! No bespoke YAML writing needed.

Speakers: Grace Goheen, Product Manager, dbt Labs; Nicholas Yager, Principal Analytics Engineer, HubSpot; Dave Connors, DX, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

The Guild team migrated to Snowflake and dbt for their data warehousing needs and immediately saw the benefits of standardizing model structure, DRYer logic, data lineage ,and automated testing on Pull Requests.

But leveraging dbt didn’t solve everything. Pain points around maintaining model logic, handling historical data, and integrating data from over 60 source systems meant that analysts still struggled to provide a unified view of the business. The team knew that they needed to level up their processes and modeling again, and chose to adopt Data Vault (DV).

Brandon and Rebecca take you behind the scenes of this decision to explain the benefits of Data Vault. They highlight DV’s ability to handle complex data integration requirements while remaining agile and demonstrate that it complements other modern data concepts like domain-driven design and data mesh.

Attendees learn what Data Vault is, when it can be a key component of a successful data strategy, and instances where it’s not the right fit. Walk away with practical tips to successfully transition based on a real-world implementation.

Guild transformed their data warehouse; you can too!

Speakers: Brandon Taylor, Senior Data Architect, Guild; Rebecca Di Bari Staff Data Engineer , Guild

Register for Coalesce at https://coalesce.getdbt.com

In the dbt Labs on dbt series, you get a behind-the-scenes look at how dbt Labs uses data. You’ll learn how dbt Labs thinks about the role of data, how data developers collaborate with business leaders, and the technical decisions we’ve made in our own dbt project.

In this session, Brandon Thomson, Analytics Lead at dbt Labs, digs deeper into the technical details of the Campaign 360, a powerful marketing analytics asset used by every member of the marketing team. You'll learn about the technical decisions made during the build of this product and explore the finished asset.

Join this session to learn about dbt Labs' journey and leave with ideas that you can implement in your dbt project today.

Speaker: Brandon Thomson, Analytics Lead, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

The final session of Coalesce 2023! Join us for Community Awards and closing thoughts. We recognize 10 individuals who have contributed significantly to the success of the dbt Community. Some of them will be with us in person, and some others will be tuning in online. All Community Award recipients are recognized and presented with a unique, never-before-seen swag item!

After the awards, we end with closing thoughts and announce the location for Coalesce 2024!

Speakers: Amada Echeverría, Global Community Lead, dbt Labs; Tristan Handy, CEO, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com/

With increased adoption of dbt and ever growing data volumes, data teams are increasingly looking to make their dbt deployments more efficient. The problem? Practitioners aren’t equipped with the tools and strategies to do this well. In this talk, Ian Whitestone and Niall Woodward of SELECT share a variety of dbt cost and performance optimization best practices, diving into the actual strategies they’ve deployed with numerous companies to give practitioners immediately actionable techniques they can apply to their own projects.

Speakers: Ian Whitestone, Co-founder, SELECT; Niall Woodward, Co-Founder, SELECT

Register for Coalesce at https://coalesce.getdbt.com

In this session, you'll learn tips and tricks from La-Z-Boy on how to modernize infrastructure and tackle complex retail and manufacturing data problems using dbt and Fivetran. Hear from a data leader about their experience and how you can replicate their success. Start your session off with some comfortable data movements to make sure you can extract as much information as possible from our loaded session on data transformation.

Speakers: Alex Hauer, Lead Product Marketing Manager, Fivetran; Selwyn Samuel, Director of Data Analytics & Enterprise Architecture, La-Z-Boy

Register for Coalesce at https://coalesce.getdbt.com

In the dbt Labs on dbt series, you get a behind-the-scenes look at how dbt Labs uses data. You’ll learn how dbt Labs thinks about the role of data, how data developers collaborate with business leaders, and the technical decisions we’ve made in our own dbt project.

In this session, Elize Papineau, Senior Data Engineer at dbt Labs, digs deeper into the technical details of the cost optimization project at dbt Labs. You'll learn how the team leveraged query tags in dbt to make model performance monitoring possible, the process for analyzing model performance, the implementation of warehouse specific configurations at the model level, and how the team measures the effectiveness of optimizations and translates it into cost savings.

Watch to learn about dbt Labs' journey and leave with ideas that you can implement in your dbt project today.

Speaker: Elize Papineau, Sr. Data Engineer, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

Two public servants at the City of Boston and the State of California are tasked with improving data services and data engineering practices within their respective governments. As part of the modernization process, they are adopting dbt and associated tools within their respective teams.

This session discusses the similarities and differences between the implementations of dbt, and how some of the constraints and challenges of working in government shape both the technical and social design of data services. The speakers will reflect on successes, challenges, and lessons learned about adopting modern data tooling in state and local governments.

Speakers: Jenna Jordan, Data Engineer, City of Boston; Ian Rose, Senior Data Engineer, California Office of Data and Innovation; Laurie Merrell, Senior Analytics Engineer, Jarvus Innovations

This session addresses the problem of how to leverage dbt Cloud to support domain user development for a migration from a centralized analytics environment towards a distributed data mesh analytics environment.

Speaker: Holly Burch, Data Architect, Sharp HealthCare

Register for Coalesce at https://coalesce.getdbt.com