Symend is a leading customer engagement solution that has adopted dbt at wide scale with over 70,000 model runs processing 186 million records daily across multiple environments in a multi-tenant environment. To manage this complexity, they rely on dbt Cloud to streamline processes and drive efficiency and have revolutionized data operations to achieve unprecedented efficiency, reliability, and speed at massive scale.

Raman will share insights, experiences, and best practices for leveraging dbt at scale, including how they have achieved a 70% decrease in daily warehouse computing costs, a 60% reduction in data engineering hours, and a dramatic 90% decrease in debugging issues. In addition, he'll share using dbt Cloud has not only reduced latency and improved data rebuild times, but has also instilled trust in our data and data teams, enabling them to ship data products faster and at a lower cost.

Speaker: Ramanpreet Singh Engineer Manager, Analytics Symend

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Are you looking to optimize your data workflows and elevate data quality in Snowflake? The analytics engineering team at Lyst achieved just that with innovative dbt macros…and it’s time to share the wealth!

In this session, Naomi will share two game-changing dbt macros that streamline data pipelines, reduce redundant efforts, and ensure robust data quality. Learn how her team’s approach to querying the dbt DAG identifies outdated models and simplifies pipeline migrations by detecting downstream impacts. Plus, uncover a fresh strategy for enhancing primary key testing on incremental models, resulting in instant efficiency and accuracy improvements.

You will walk away with actionable next steps to adopt these macros and best practices in your organization.

Speaker: Naomi Johnson Director of Data Platform Lyst

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Dive into Chick-fil-A's data-centric culture, where efficient data transformation is pivotal for operational success. With data serving as a cornerstone, teams must rapidly process, clean, and validate vast volumes of data across diverse departments. Leveraging a robust toolkit including dbt and Databricks, Chick-fil-A is managing over 30 dbt projects seamlessly. Hear from the Chick-fil-A analytics engineering team as they explore the intricacies of scaling data transformation initiatives and the pivotal role dbt plays in overcoming challenges inherent in managing data at such scale. Gain insights into the specific obstacles addressed by dbt and how its features empower Chick-fil-A's teams to navigate complex data landscapes with agility and precision.

Speakers: Tony Yuan Senior Principal Team Leader Chick-fil-A

Dustin Dorsey Principal Data Architect Onix

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Jonny will showcase how the team at EQT, one of the world's largest private equity firms, is leveraging the dbt Discovery API, data contracts, tagging, and other dbt features to power discovery through their intranet — and by extension, how this also enables the team to support LLMs for live querying of their data.

Speaker: Jonny Reichwald Analytics Lead EQT

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Storebrand is a financial institution in Norway with several independent verticals — banking, pensions, insurance, asset management, properties — and horizontals across corporate and personal markets. To meet the matrix of data needs, Storebrand has needed to develop several data warehouses. They're now two years into the journey of building a new data platform, based on Snowflake and dbt, with four people in the platform team — and they're now scaling that central platform to the whole enterprise, with dbt Mesh. This requires automation of infrastructure and permissions to be regulatory compliant, data governance, clear separation of duties between the platform team and the data teams — for example, who has the responsibility for data masking and GDPR deletions? — a great developer experience, and a lot of good will. This presentation will try to answer how they've done it so far, and their plans to scale it from here.

Speaker: Eivind Berg Tech Lead Data Platform Storebrand

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Founded in 1952, nib has become one of Australia's fastest growing health funds, leveraging advanced data practices to drive its expansion. With dozens of dbt projects and thousands of dbt models interacting across the organization, the data team has built processes and frameworks to effectively govern these models. We will talk through the organic growth of dbt at nib — now at 70 active users, from analytics engineers to data analysts — outlining how the team uses meta tags, metadata analysis, and data lineage to manage changes and enhance data accessibility. We will also discuss the internal processes developed at nib that promote democratization and collaboration in our analytics engineering team.

Speakers: Pip Sidaway Data Product Manager nib

Juliana Zhu Lead Data Engineer nib

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Eric will share the team's experience with dbt and tell the development story of bringing Workday FinOps cost analysis to cloud engineers and stakeholders. He will describe how the team is using dbt, Trino and Lightdash to build a new data platform that is now a key part of their data-driven business decision process in multiple organizations within Workday. Plus, he'll show how they created a secure, efficient, and scalable platform — through dbt governance features — to drive those successful data projects.

Speakers: Eric Pu Senior Software Engineer Workday

Pattabhi Nanduri FinOps Data Engineer Workday

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Centralize, harmonize, and streamline. That’s how Roche delivers self-service analytics to the thousands of people in its pharma commercial sector. Dbt is powering the backend solution that combines over 60 transactional systems into a harmonized simplified data model. By adopting a version-controlled approach and enabling end-to-end lineage tracking, we achieved significant reduction in duplication and accelerated time-to-insight for data-driven decision-making. The transition from a heterogeneous technology stack to standardized ways of working has fostered greater flexibility in allocating resources across the organization to address diverse use cases. Additionally, the scalable nature of this platform allows us to easily replicate successful data solutions globally. We further augmented our capabilities by integrating generative AI into our Redshift data warehouse, empowering the creation of innovative data products using dbt. This presentation will share practical lessons learned, architectural insights, and the tangible business impact realized from this data platform modernization.

Speaker: João Antunes Lead Engineer Hoffmann-La Roche

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

For the data team Invitation Homes, the job is personal. The company is focused on delivering high-touch services and high-quality experiences all in the name of helping people find their dream home. Matching a family to their home and making sure they’re happy enough to continue with their lease is a largely data driven process. This session will explore how dbt Cloud is powering the data transformation pipelines that fuel Invitation Homes’ Resident Experience dashboard, and how that dashboard delivers significant business value for the company and its customers.

Speakers: Bhavin Mehta Sr Director, Enterprise Data and Analytics Invitation Homes

Hemchand Koch Lead Data Product - Platform Invitation Homes

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

In this session, led by dbt co-founder Drew Banin, we’ll explore how dbt Copilot is transforming analytics workflows today and provide a preview of exciting AI features coming soon. Powered by AI, dbt Copilot helps you move up the stack by automating the mundane so you can focus on the highest-leverage problems.

Speaker: Drew Banin Co-founder dbt Labs

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

This session will explore a few key metrics that can be used to steer your business in the right direction. Retention rate, lifetime value and payback time are crucial for estimating growth, understanding user behavior and determining marketing spend. Those are needed in turn for companies to make informed decisions and drive the business forward so it is important to get them right. While some rules may be specific for each company, this talk will present the work undertaken at Rebtel to calculate these metrics using SQL, and how you could implement similar models quickly.

Speaker: Quentin Coviaux Data Engineer Rebtel

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Explore the latest features added to dbt Core this year, shaped by community feedback and collaboration. Learn how community-driven efforts influenced development and get a sneak peek at what’s coming next for dbt Core. Whether you’re a seasoned user or new to dbt, this session will keep you in the loop on the latest innovations and what’s ahead.

Speaker: Grace Goheen Product Manager dbt Labs

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Over the past 8 years, dbt, Cloud data warehouses and the dbt viewpoint have dramatically changed the workflow for data practitioners, raising the bar on what great data work looks like and altering the nature of the types of problems we focus on day to day. Jason Ganz lived this transition firsthand and now, he believes, we’re on the cusp of another transformation in how data work gets done. Come hear about how new technologies like Generative AI and new workflows like the Analytics Development Lifecycle will transform data work and how to think about that in your own role and career trajectory.

Speaker: Jason Ganz Senior Manager, Developer Experience dbt Labs

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

"Look at these beautiful dbt models! Why are we still experiencing the same friction with stakeholders?" This talk from experts at dbt Labs argues that we solved the first stage of building "Transformations" (via the 2024 State of Analytics Engineering report) and now we're now in the second stage: "The Philosophy of Transformations". And all roads lead to "metrics".

Speakers: Erica Louie Sr. Analytics Manager dbt Labs

Andrew Escay Lead Data Analyst dbt Labs

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

The dbt Labs 2024 State of Analytics Engineering report highlights that stakeholder data literacy remains a problem in the modern data workplace. Data stakeholders and data professionals can both benefit from learning foundational data literacy concepts that foster their ability to reason about working with data in a business environment. In this talk, an expert from Great Expectations covers two key concepts that they've applied in their own career when framing data fundamentals: “the data supply chain” and “ML in a nutshell.”

Speaker: Rachel House Senior Developer Advocate Great Expectations

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

This talk isn't about data quality tests. Why? Well, because there’s no shortage of tools and processes for testing your data, monitoring your data, and alerting your team when the pipeline breaks. Instead, this is a talk about what happens after the alarm goes off.

Data incidents can quickly snowball into much more than simply fixing the issue. Juggling comms, diagnosing the issue, ownership of the failure, your DMs lighting up…we’ve all been there and understand just how stressful it can be.

In this session, Matilda covers a number of tool and product agnostic approaches teams can adopt to improve how they manage data incidents. These are practical steps any data team can follow to improve how they’re resolving, communicating, and learning from their incidents, with the goal of providing more resilient data systems.

Speaker: Matilda Hultgren Data Analyst - Product incident.io

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Community Spotlight Honorees Bruno and Dakota from phData cover various advanced pipelines and when to implement them.

Speakers: Dakota Kelley Sr Solution Architect phData

Bruno Souza de Lima Senior Data Engineer phData

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

The Houston Food Bank (HFB) is the largest food bank in the country, serving 18 southeast Texas counties and distributing over 120 million meals in the last fiscal year through our network of 1,600+ community partners to the 1 million-plus food-insecure persons in the region.

Over the last 2+ years, HFB has leveraged dbt to modernize our data stack. Initially working with dbt Core, our data team's engineers centralized, streamlined, and automated data pipelines to provide critical KPIs to HFB Leadership. Fast-forward to today, our data team of 10, which includes engineers, analysts, and other specialists, uses dbt Cloud to manage all data transformations in our data warehouse, which now supports 30+ integrations and 70+ reports that deliver 180+ metrics to stakeholders across the organization. This organizational transformation has saved countless hours for our staff, improved organizational trust in data significantly by identifying and managing sources of truth, and delivered key insights to stakeholders across our entire organization.

A handful of examples include: - Identifying corporate donor opportunities by mining donor and volunteer data - Increasing the number of opportunities for federal and grant-based funding by being able to generate metrics across an ever-increasing number of data sources - Assessing the efficiency of school-based programs by analyzing the proportion and volume of students served to the food-insecure population of that school

HFB is committed to being a data leader in the food banking space, and we’re hoping our journey using dbt can inspire other non-profits to leverage the platform as well.

Speakers: Erwin Kristel Data Analyst Houston Food Bank

Benjamin Herndon-Miller Data Engineer Houston Food Bank

Susan Quiros Data Analyst II Houston Food Bank

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

This session is a practical guide to changing how you operate in response to the Cambrian explosion of AI and LLM technologies. In your future, everyone at the company will have access to an LLM with unfettered access to your data warehouse. Do you feel afraid? The Data team at Hex did too. They'll share how they had to change how they worked to adapt, and what data leaders and practitioners need to be thinking about for their own teams.

Speakers: Amanda Fioritto Senior Analytics Engineer Hex Technologies

Erika Pullum Analytics Engineer Hex Technologies

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements

Since the beginning of 2024, the Warner Brothers Discovery team supporting the CNN data platform has been undergoing an extensive migration project from dbt Core to dbt Cloud. Concurrently, the team is also segmenting their project into multi-project frameworks utilizing dbt Mesh. In this talk, Zachary will review how this transition has simplified data pipelines, improved pipeline performance and data quality, and made data collaboration at scale more seamless.

He'll discuss how dbt Cloud features like the Cloud IDE, automated testing, documentation, and code deployment have enabled the team to standardize on a single developer platform while also managing dependencies effectively. He'll share details on how the automation framework they built using Terraform streamlines dbt project deployments with dbt Cloud to a ""push-button"" process. By leveraging an infrastructure as code experience, they can orchestrate the creation of environment variables, dbt Cloud jobs, Airflow connections, and AWS secrets with a unified approach that ensures consistency and reliability across projects.

Speakers: Mamta Gupta Staff Analytics Engineer Warner Brothers Discovery

Zachary Lancaster Manager, Data Engineering Warner Brothers Discovery

Read the blog to learn about the latest dbt Cloud features announced at Coalesce, designed to help organizations embrace analytics best practices at scale https://www.getdbt.com/blog/coalesce-2024-product-announcements