As organizations increasingly adopt modern data stacks, the combination of dbt and AWS Analytics services emerged as a powerful pairing for analytics engineering at scale. This session will explore proven strategies and hard-learned lessons for optimizing this technology stack to use dbt-athena, dbt-redshift, and dbt-glue to deliver reliable, performant data transformations. We will also cover case studies, best practices, and modern lakehouse scenarios with Apache Iceberg and Amazon S3 Tables.

AI is transforming data teams - maybe you're anxious, excited, or kind of bummed. I'll share how I went from AI skeptic to enthusiast, how analytics engineering is evolving, and how data teams can finally deliver on promises we've been making for years.

Conagra’s brand teams needed a dynamic, centralized way to track and analyze macro and micro events affecting business performance. Previously, teams relied on manual Excel processes to compare shipments, consumption trends, and promotions against external factors like weather and consumer pricing data. This approach led to inefficiencies, inconsistencies, and limited adoption.

In this session, Matthew Henkel (Sr Analyst Advanced Analytics) and Manav Purohit (Director Analytics Engineering) will showcase the Event Impact Tracker, a Sigma-powered data app that:

Unifies external & internal data for better event-driven decision-making Leverages input tables to allow users to log and track internal events Enables easy adoption with an Excel-like, user-friendly experience Join this session to see a demo of the app and hear how Conagra transformed event tracking into a scalable, data-driven process with Sigma Data Apps.

➡️ Learn more about Data Apps: https://www.sigmacomputing.com/product/data-applications?utm_source=youtube&utm_medium=organic&utm_campaign=data_apps_conference&utm_content=pp_data_apps

➡️ Sign up for your free trial: https://www.sigmacomputing.com/go/free-trial?utm_source=youtube&utm_medium=video&utm_campaign=free_trial&utm_content=free_trial

sigma #sigmacomputing #dataanalytics #dataanalysis #businessintelligence #cloudcomputing #clouddata #datacloud #datastructures #datadriven #datadrivendecisionmaking #datadriveninsights #businessdecisions #datadrivendecisions #embeddedanalytics #cloudcomputing #SigmaAI #AI #AIdataanalytics #AIdataanalysis #GPT #dataprivacy #python #dataintelligence #moderndataarchitecture

Riot Games, creator of hit titles like League of Legends and Valorant, is building an ultimate gaming experience by using data and AI to deliver the most optimal player journeys. In this session, you'll learn how Riot's data platform team paired with analytics engineering, machine learning, and insights teams to integrate Databricks Data Intelligence Platform and dbt Cloud to significantly mature its data capabilities. The outcome: a scalable, collaborative analytics environment that serves millions of players worldwide.

You’ll hear how Riot Games: - Centralized petabytes of game telemetry on Databricks for fast processing and analytics - Modernized their data platform by integrating dbt Cloud, unlocking governance for modular, version-controlled data transformations and testing for a diverse set of user personas - Uses Generative AI to automate the enforcement of good documentation and quality code and plans to use Databricks AI to further speed up its ability to unlock the value of data - Deployed machine learning models for personalized recommendations and player behavior analysis

You'll come away with practical insights on architecting a modern data stack that can handle massive scale while empowering teams across the organization. Whether you're in gaming or any data-intensive industry, you'll learn valuable lessons from Riot's journey to build a world-class data platform.

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 us for an insightful session where we delve into the innovative ways the NBA is leveraging Generative AI (GenAI) to revolutionize data insights and transform the world of sports and entertainment analytics.

Speakers: Keelan Smithers Data Product Manager, Analytics Engineering NBA

Mark Hay CTO & Co-Founder TextQL

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

Want to learn more about dbt Cloud’s cross-platform mesh vision? Want to brainstorm how open table formats are of value to analytics engineers? Want to talk with peers who are considering or scoping how to use dbt and lakehouses to orchestrate workloads across platforms to solve business problems?

In this peer exchange, participants talk with peers and think through any and all of the above.

Speakers: Anders Swanson I serve the realm dbt Labs

Ulrik Svanborg Møller Lead Data Engineer Vestas Wind Systems

William Krill Data Engineer Vestas Wind Systems

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

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

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

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

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

There are undoubtedly similarities between the disciplines of analytics engineering and DevOps: in fact, dbt was founded with the goal of helping data professionals embrace DevOps principles as part of the data workflow. As the embedded DevOps engineer for a mature analytics engineering function, Katie Claiborne, Founding Analytics Engineer at Duet, observed parallels between analytics-as-code and infrastructure-as-code, particularly tools like Terraform. In this talk, she'll examine how analytics engineering is a means of empowerment for data practitioners and discuss infrastructure engineering as a means of scaling dbt Cloud deployments. Learn about similarities between analytics and infrastructure configuration tools, how to apply the concepts you've learned about analytics engineering towards new disciplines like DevOps, and how to extend engineering principles beyond data transformation and into the world of infrastructure.

Speaker: Katie Claiborne Founding Analytics Engineer Duet

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 Virgin Media O2 uses dbt Cloud to enhance call center efficiency, personalize customer communications, and accelerate data science workflows. In this session, we will share details about our innovative continuous flow system, developed using best practices from Toyota Kanban, and how it helps reduce operational waste and costs. We will also highlight a number of capabilities within dbt Cloud that support continuous data flows by automating manual tasks.

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

Speakers: Arun Kumaravel Senior Analytics Engineer Virgin Media O2

Oliver Burt Lead Analytics Engineer Virgin Media o2

Gordon Curzon Head of Analytics Engineering Virgin Media O2

In today's data-driven world, harnessing the power of data is no longer an option but a necessity for businesses to thrive. For product engineering teams in particular, timely access to accurate and contextual data is crucial for making informed decisions and monitoring success. In this conversation, Aakriti Kaul and Scott Henry, Data Scientists at Cisco, dive into Duo Security’s data modernization journey, bolstered by dbt Cloud and embedded context in data, aimed at empowering product teams with data access and insights to drive innovation.

At the end of this session we hope to leave attendees with the following takeaways: • Understand how an Embedded Data science model creates value across Product, Engineering and Data teams • Learn practical strategies for implementing dbt within product development workflows to accelerate decision making and drive innovation, in partnership with Analytics Engineering teams • Gain insights from real-world case studies of Duo’s Product Data teams that have successfully leveraged dbt to provide access to data and insights for product teams • Gain insights from our organizational experience using dbt to provide product teams with self-service access to contextual datasets

The presentation is designed for data scientists, analytics engineers and other professionals involved in product development who are interested in leveraging data to drive decision making and embedding context within their data workflows. Whether you're new to dbt or looking to optimize your existing data analytics workflows, this session will provide valuable insights and practical strategies for harnessing the power of dbt in partnership with product engineering teams.

Speakers: Aakriti Kaul Data Scientist Duo Security @ Cisco

Scott Henry Data Scientist Duo Security @ Cisco

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

A recap of Coalesce 2024—from dbt Labs—in Las Vegas. Coalesce is the premier analytics engineering conference for data practitioners looking to hone their craft, connect with peers, and get energized about the future of data.

The Lakehouse architecture has emerged as the ideal data architecture for the AI age. It 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.

Speaker: Thor List, Senior Field Engineering Manager, Databricks

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

Supercharge your analytics engineering with the power of automated CI checks. Learn how FINN, a global car subscription service, has harnessed the capabilities of automated CI checks to maintain the delicate balance between swift development and robust data pipeline quality as they've scaled their data teams. Dive into insights and strategies to ensure quality without sacrificing speed and discover how to improve your data operations.

Speakers: Chiel Fernhout, Software Engineer, Datafold; Jorrit Posor, Tech Lead Data Engineering, FINN GmbH; Felix Kreitschmann, Senior PM, Data, FINN Auto

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