Creating / migrating metric metadata to dbt can be a pain, because the level of underlying data knowledge required to create the YAML files properly. You might have found yourself wondering, “is this worth it just to standardize metric definitions?”. This talk will tell you why it is definitely worth it… because the functionality you unlock goes beyond just standard metric definitions. Adopting the dbt standard metric syntax unlocks three additional possibilities for your data:

1. Automated time-aware metric calculations

2. Dynamic drill downs and segmentation to empower slice and dice analysis

3. Self-service dynamic transforms using templated SQL

Check slides here: https://docs.google.com/presentation/d/1nJHP2E6NGZ-KHG4_gNiI6w2lq4kjWgQIanAC9yf3cng

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

As your business and number of product lines grow, the out-of-the-box lead scoring in CRM tools starts becoming difficult to work with and lead scoring becomes that more important for sales teams. Join Ben Lewinsky as he shows how Culture Amp approaches multi-product lead scoring in their data warehouse using dbt.

Check the slides here: https://docs.google.com/presentation/d/1NOyZLs1QUf6HQqF6jusx32OjUb-Gi-PTnmiDQ8EFKM8/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

You’re probably familiar with the dbt-utils package, but how many others have you explored? If you’re looking to cut development time, make your next audit less painful, or wield dbt metrics confidently, join Elize and Dave as they dig into three of their most essential dbt packages—codegen, audit_helper, and metrics —in this hands-on workshop.

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

In this workshop, you’ll learn how to create and document macros that leverage the powerful introspective features of dbt to perform dynamic modeling including: run result storage in your warehouse, dynamic value lookup in models, and leveraging model metadata in macros.

You’ll learn how to: - Create macros to store your dbt run results within your data warehouse - Leverage internal dbt graph data for dynamic modeling - Incorporate dbt best-practices when developing macros

Prerequisites: - Basic familiarity with ANSI SQL - Some familiarity using Jinja and writing macros - Experience with dbt required

Check Notion document here: https://www.notion.so/6382db82046f41599e9ec39afb035bdb

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

What was the most recent data skill you developed? How did you go about doing that? With an ever-growing industry of skills, knowledge, frameworks, and tools, Amy Chen (dbt Labs) will unpack how data folks prioritize what to learn and how they actually learn them in this interactive session.

Check the slides here: https://docs.google.com/presentation/d/1-O3Woc3TpE8fG-HYWSAUa7sHcQp1NgrWNmE3lBIn60U/edit

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Using data to grow revenue is a lofty goal thrown around by most business leaders these days, but leaders (and the data teams that support their goals) often don’t have a clear understanding of what needs to happen on the ground to actually make this come to reality. Data teams are looking for the right combination of modern tools, best practices, and company culture to meaningfully impact their company’s goals and revenue.

In this panel discussion, Census CEO Boris Jabes, Carta VP of Data and Analytics Julia King, and ClickUp Head of Analytics Marc Stone will break down what it really means to operationalize your data to drive revenue, and what every company can do to make this a reality, no matter their team size.

Check the slides here: https://docs.google.com/presentation/d/1CDuaVUm3yxwbcjNXMv1JcAv9PdfZFM80kwbvl9yYRtU/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Have you ever deployed a model without fully understanding the downstream effects? In this talk, we'll explore how to ensure quality throughout the model deployment process - answering questions, like: When are dbt tests not enough? Is it possible to conduct a quality PR review in under 5 minutes? How do we detect breaking changes before they reach production?

Check the slides here: https://docs.google.com/presentation/d/1ELeHag880v8bmJDmMaES95k90wu-twDXDg-aZGyP7AQ/edit#slide=id.g158fcd520ea_0_155

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Product manager turned analytics manager, Caroline Rhodes (Wellframe), asks whether analytics teams really need PMs, or whether their presence can actually slow down, or misdirect your team. Attendees of this session will walk away knowing how to make this call based on their own use cases and ambitions.

Check the slides here: https://docs.google.com/presentation/d/1MAW_WfTGdygR7pBj7utwV5o--vlKQbLM25XhmLH8aEU/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

dbt adoption has exploded—often before users had the resources and best practices at their disposal to inform strong project structure. But all is not lost! With the collective experience of 6 dbt-using data teams under their belt, Kelly Burdine and Michelle Ballen know exactly how to take your project from worst to first.

Check the slides here: https://docs.google.com/presentation/d/1P9kY0a9UAwp1Z3YrQGqhkn6hn4npKcf9lwDV1KNZ7tU/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

In this session participants will learn:

1. How a product analytics platform can help you understand User Flows — how users are flowing in and out of certain features.

2. The impacts that certain features can have on engagement and retention. - Understanding User and Product-Feature Usage Patterns - Quantify Impact on User Engagement - Quantify Impact on User Retention

3. Prioritize Roadmap Features Using Data Insights

4. Ensure insight fidelity and compliance with data quality and privacy tools that a PM can use

5. Increase product adoption by activating user behavior data

Check the slides here: https://docs.google.com/presentation/d/1G6qIbWkzMp_IXACvuJw1oBb46BjbV7_jCeWk5P6rOlk/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

How do you support exponentially growing companies without breaking as a data team? The answer is increasing your leverage with tools and processes. This session centers around four principles to achieve this goal: 1. don’t reinvent the wheel, 2. make your own job easier, 3. save time for innovation, and 4. invest in onboarding.

First, the first data leader at Vendr, the SaaS buying platform with customers like GitLab, Brex, and The Washington Post, will share his learnings on building a stack and team that scaled as the company grew 10x from 30 to 300 employees in under two years.

Second, we’ll give a demo of how Metaplane pulls lineage and metadata from a modern data stack that is centered around dbt. By the end of the demo, you’ll know how to setup tests, extract lineage throughout your data stack, and triage data quality alerts.More details coming soon!

Check the slides here: https://docs.google.com/presentation/d/15dQJIGeGhG0WGO6MLXtxWhmf8neY-u0c8ZLRG9GJB-s/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Roleplaying games? Roleplaying games in data? You read that right. To Ian, there's more commonality in roleplaying games and the data world than most of us think. In this session, Ian Fahey (dbt Labs) will draw on his vast experiences in roleplaying games and analytics engineering work to walk through the adventuring classes of "the world's most popular tabletop roleplaying game" (Dungeons and Dragons) and talk about how they can inform data professionalism.

Check the slides here:https://docs.google.com/presentation/d/16Wm4ChDPORvEkDxUu3-mHBYRLJtwUTRdP7rj-LIrUB4/edit#slide=id.g1571952a68b_0_12

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

For too long, there's been contention between business and data teams. Incoming requests to a data team span from adding one specific column for one specific use case, to updating logic for a point in time question—the priorities stack up, and data teams find themselves sifting through a myriad of lower-level requests, unable to work on higher, more transformational deliverables. At Sigma, we're flipping the script by enabling analysts and stakeholders alike to iterate and explore in a familiar spreadsheet UI, with the scale and performance unlocked by modern cloud data warehouses. In this talk, we'll cover how we deploy Sigma internally (powered by dbt and dbt cloud metadata) to truly give the power to generate insights from data back to the business, and create a more effective feedback loop when working with our own data team.

Check the slides here: https://docs.google.com/presentation/d/11jGG6OSwwjtT6gRVpse9VSPjW_mIpYPUfRBx5TSttjk/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Whether you’re building a BI team, or transitioning from service-based to data-as-a-product, having stakeholders from across your organization understand your initiatives is key to unlocking org-wide growth. In this session you'll learn how Kate Schiffelbein (Kentik) has navigated the same process—to turn skeptics into supporters, and engage with all levels of the organization.

Check the slides here: https://docs.google.com/presentation/d/12vj-k3KebjI2VsFe0q02n5WEgeAQQt0D3FPQZRdR2mU/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

As analysts lean further into analytics engineering workflows, they’ll need to source opportunities for more hands-on experience. Forunately, this is achieveable just by applying a fresh framework to existing analytics projects. In this session with Brittany Krauth (Degreed), you’ll learn how to approach common problems through the analytics engineering workflow.

Check the slides here: https://docs.google.com/presentation/d/1RO7EAbHqcxsRWp40EKusANwD5IwUAoEs/edit?usp=sharing&ouid=110788023771657617483&rtpof=true&sd=true

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

For the first time in dbt, you can now run Python models, making it possible to supplement the accessibility of SQL with a new level of power and flexibility.

When is it useful to use Python, and when should you stick with SQL instead? What might a multilingual dbt project look like in practice, and what could it make possible for your team?

Join Jeremy Cohen, Cody Peterson, and Leah Antkiewicz to explore these questions in this interactive session.

Check the slides here: https://docs.google.com/presentation/d/1e3wB7EQ0EXugGhfCjVCp_dDFEbY_uKyVjMqG1o7alnA/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Does a two-step deployment workflow for developing, testing, and deploying code to dbt Cloud sound possible? Sunrun thinks so. Join James Sorensen and Jared Stout to learn how they used Github Actions and API integrations with dbt Cloud and Jira to entirely automate the CI/CD workflow, saving the team time and worry when moving through SOX certification.

Check the slides here: https://docs.google.com/presentation/d/1ZecU0-TN8SxNFpdKdkVksuDjpUy6XiaulqBdfqhLb68/edit#slide=id.g15507761f0b_0_10

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Automation will make your dbt development faster and safer — but how do you get started? In this workshop we'll introduce you to the "Software Development Life Cycle" and some of the automation opportunities it offers from pre-commit to CI and beyond.

This workshop is ideal for the decision maker who is planning for their team or for the intermediate to advanced dbt developer who wants to become more efficient and learn a thing or two from software workflows. We'll talk about how automation can minimize the risk of code changes, shorten your time to merge, and improve quality and standardization throughout your projects.

Bring your laptop with dbt 1.0+ installed to follow along or just come and watch the walk-through! You'll start this workshop with a simple dbt project and end with local pre-commit automation on your computer and a framework for further improvement and iteration.

Check the step-by-step workshop guide here: https://blog.montrealanalytics.com/automating-dbt-development-workflows-with-pre-commit-b6c7ca708f7

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Supplying users with the most relevant data is a time-consuming challenge. By combining the power of dbt with machine learning (ML) analysis, companies are able to focus on the most relevant segments in the data that have the greatest impact on key metrics and how they change over time. Leveraging the Sisu Decision Intelligence Engine, dbt users, analysts, and data scientists focus their efforts where they have the greatest impact. Sisu's AI/ML-powered automated analytics identifies relevant data and predicts changes, helping focus data exploration, speed insights, and drive successful outcomes.

Check Notion document here: https://www.notion.so/6382db82046f41599e9ec39afb035bdb

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Let’s get down to business! Most business users don't want to be bogged down in the data modeling and complexities that us data folk work so hard to accomplish and overcome. Instead, business users and leadership members want the dashboards and numbers they care about. In this session, Matthew Hoss (Element Biosciences) shares his four-step approach to modeling and creating turnkey cost dashboards, all sitting on top of a Netsuite/Fivetran/Snowflake/dbt/Tableau data stack, that help business users get the answers they need, quickly.

Check the slides here: https://docs.google.com/presentation/d/1VVZwm2Kloy1aeewqbB--7WfxIifnpIZflx9V8Q2N-x0/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Many transformations are fine candidates for concretizing with dbt. But there are transformations that live in the data science world that are not well-suited for dbt—and probably for good reason. Consider the total set of all transformations, from mandatory pre-processing steps to sophisticated statistical transformations (e.g., converting data types versus computing robust measures of central tendency). The question quickly becomes: How do data teams decide which transformations to push down to dbt and which to leave up in the notebook?

In this panel discussion led by Allan Campopiano (Deepnote), analytics engineers, data engineers, and data scientists discuss what transformation means to them, where and when transformation happens in their stack, and how to collaborate effectively between high- and low-level forms of transformation.

Check the slides here: https://docs.google.com/presentation/d/1uqi1C2gpBnsMp-BTvjltmjlnedWKqEzwonZjrewOWNk/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Our new economic reality is sending data teams into uncharted territory for justifying tools and technology—especially those with traditionally nebulous ROI. Does this make data teams a cost center? In this talk, Chetan Sharma (Eppo) will share clear steps to calculating ROI by comparing traditional data actions without clear revenue return (bespoke dashboards, ad-hoc data pulls), against things like data-supported product development testing, operations execution, and GTM planning.

Check the slides here: https://docs.google.com/presentation/d/1NLC3Kvv8aNlestCqh8VjyFE6weLr0zzbWjh6Qb9mL5Q/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Academia/open science is an as-yet untapped market for analytics engineering, as well as one that could majorly benefit from the tight coupling of data transformation and software engineering best practices. But introducing dbt into this context comes with its own set of challenges. In this session, Šimon Podhajský (iLife Technologies), explains what’s slowing progress here,, and what academics can do to progress this work.

Check the slides here: https://docs.google.com/presentation/d/1aw_cs6V0n-oT9Lp7Vq3MNcRbthEFJEYwcvkCBfuzlR0/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

Are you sold on dbt, but unsure as to how you’ll handle deployment, orchestration and job scheduling? Are you evaluating dbt and looking for an easy way to spin up a proof of concept while seeking buy in from stakeholders? Look no further! In this workshop we will show you how to containerize your dbt project and execute jobs using GCP’s serverless computing products Cloud Run, Build and Scheduler. If you have an interest in dbt orchestration, devops, or serverless cloud architecture, this workshop is for you!

Check the slides here: https://docs.google.com/presentation/d/1NiG0MFkOvw5MNpCZFF74VDuX-jHZpO4a8bHUadukoPI/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.

As data science and machine learning adoption grew over the last few years, Python moved up the ranks catching up to SQL in popularity in the world of data processing. SQL and Python are both powerful on their own, but their value in modern analytics is highest when they work together. This was a key motivator for us at Snowflake to build Snowpark for Python: to help modern analytics, data engineering, and data science teams generate insights without complex infrastructure management for separate languages.

Join this session to learn more about how dbt's new support for Python-based models and Snowpark for Python can help polyglot data teams get more value from their data through secure, efficient and performant metrics stores, feature stores, or data factories in the Data Cloud.

Check Notion document here: https://www.notion.so/6382db82046f41599e9ec39afb035bdb

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.