There is a lot of talk when it comes to how LLMs can best be deployed in the analytics space. What are implementation best practices? Are LLMs best suited with text-to-SQL or with a Semantic Layer underneath providing proper constraints?

These are fun discussions to have, but LLMs also present a massive opportunity for companies beyond normal analytics work. The team at Newfront has been building LLM-powered products for clients that are external facing, using a cross-functional group that consists of many data team members.

In this talk, they'll go over where data professionals fit best in building these sorts of products and how to get started in participating in direct value generation for your business.

Speaker: Patrick Miller Head of Data & AI Newfront

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

Entities, dimensions, and metrics. These things play crucial roles in allowing companies to create meaningful pictures of their data.

Max has spent the last 2.5 years using dbt with two different cleantech startups, experience he draws on to inform his approach to the challenge of matching and maintaining entities for more robust semantics. This talk will delve into the practical aspects of using the dbt Semantic Layer and Dot an LLM Slack plugin to provide matched insights directly to team members at Topanga.io.

Expect to learn about best practices in self-service, LLMs, data governance, and how to leverage the dbt Semantic Layer effectively. It’s a session geared toward beginners, intermediates, and pros alike

Speaker: Max Richman Head of Data and Financial Analysis Topanga.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

AI is transforming data development and engagement at ClickUp. By working to integrate AI at every stage—from data ingestion and transformation and even down to customer-facing systems—ClickUp is at the forefront. A key component of this initiative is a multi-step process to implement a Retrieval Augmented Generation (RAG) system. This involves several strategic steps, including an AI-integrated IDE for development and an in-house application designed to offer unique insights into the data stack, fully aligned with business operations. This approach simplifies information retrieval and streamlines processes for internal data teams and stakeholders. Join us to explore ClickUp’s approach to AI development and discover the benefits of AI in the data industry.

Speaker: Collin Lenon Senior Analytics Engineer ClickUp

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

Have you ever wanted to build an AI chatbot to query your data platform? Transforming a business user's natural language question into a valid SQL query that answers their question has huge potential to unlock improved self-service analytics. However, even state-of-the-art LLMs are prone to hallucination, which makes it hard to generate SQL queries that are both conceptually and syntactically correct.

In this talk, you'll learn how the team at M1 Finance tackled this problem using MetricFlow’s rich semantic modeling along with LLM-based tool invocation. This approach enables them to reliably produce valid SQL queries from natural language questions, avoiding issues of hallucination or incorrect metrics.

Speakers: Kelly Wolinetz Senior Data Engineer M1 Finance

Brady Dauzat Machine Learning Engineer M1

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

Learn best practices, challenges, and outcomes the NBA experienced as they scaled from zero to 35 monthly active contributors to their dbt Cloud project over the course of one year. Keelan will review the state of analytics before dbt, and how widespread adoption has resulted in improved uptime, time to value, and organizational trust in data. He'll share specifics of the challenges faced, and how they were able to implement best practices and new organizational norms at various stages of the journey to combat these workflow and cultural hurdles. He'll also share the frameworks he and his team built and standardized on as they democratized data analytics to dozens of practitioners, and how they capitalized on small pockets of "ah-ha!" moments to translate it into lasting behavioral change.

Speaker: Keelan Smithers Data Product Manager, Analytics Engineering NBA

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 the rapidly evolving landscape of data management, a multi-data platform strategy is essential for organizations seeking to harness the full potential of their diverse data sources. Learn how Fox uses dbt Cloud as a pivotal technology in orchestrating this strategy, enabling seamless integration, transformation, and analysis across multiple data platforms.

Speaker: Ramesh Madepalli Sr. Director, Architecture and Strategy Fox Corporation

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 cover all things Tableau and the dbt Semantic Layer. Gordon will show you how to configure and connect to the dbt Semantic Layer in Tableau. He will address the differences between using the semantic layer with Tableau Server and Desktop - in particular how the semantic layer can help eliminate tech debt on Tableau Server. There will also be a deep dive into best practices - for instance, how and why saved queries are such a powerful semantic layer feature for Tableau users.

Speakers: Madeline Lee Product Manager, Tableau

Gordon Rose Principal Solutions Architect 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

Self-serve! Genuine self-serve. The data team at the Philadelphia Inquirer has made crucial strides toward enabling it for their business users, with the dbt Semantic Layer playing a major role. Their journey started with a strong opinion on what self-serve is not. Hear about their journey, the obstacles they overcame along the way, and the outcomes they were able to drive in this talk.

Speaker: Brian Waligorski Lead Data Engineer The Philadelphia Inquirer

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

Join Collin as he shares learnings and best practices for scaling dbt on ClickUp's journey as the company rapidly grew from 100 to over 1,000 employees (without losing too much hair). This session is ideal for both new and experienced developers, at any stage of their scaling journey. He'll delve into very practical steps for setting up a robust development environment—covering everything from project structure and IDE setups to advanced CI/CD processes. He'll also share practical learnings, hands-on examples, and best practices for implementing various dbt capabilities as well as tradeoffs his team faced as they balanced cost and business impact at rapid scale.

Speaker: Collin Lenon Senior Analytics Engineer ClickUp

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

Learn how Hostinger, a leading European provider of web hosting solutions, leverages dbt to implement slowly changing dimensions (SCD)...and not go bankrupt while doing it at scale. They'll cover how they used the Debezium connector to tackle the challenges of change data capture (CDC), and how leveraging dynamic incremental predicates allowed them to scale their solution at a fraction of the cost using BigQuery.

Speakers: Augustinas Karvelis Analytics Engineer Hostinger

Valentinas Mitalauskas Analytics Engineering Lead Hostinger

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

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