Salesforce and other CRMs are the beating heart of sales and go-to-market operations. When CRMs are in conflict with the data warehouse as competing sources of truth or separate silos everyone loses.

Join Erika and Sean as they shares how Hex's Data and RevOps functions have partnered to integrate data into Salesforce to prevent data silos, empower their sales reps, and understand their performance—and how Hex's learning lessons can be applied to your own org.

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

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

Airbyte supports loading data into a wide array of databases and data warehouses. We must enforce the same structure and transformations in each of these tools, and writing different transformations for each would be prohibitive. Instead, we use dbt to write this code once and reuse it for every database and data warehouse that we support. In an effort to improve our support across all these tools, we are also introducing a dbt Cloud integration within Airbyte Cloud. This will allow Airbyte Cloud users to leverage the lessons we’ve learned and build their own custom transformations using dbt Cloud.

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

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

Should you consider building a Data App?

How many times has your product team asked for data science models to be available in realtime to serve feature flags and product recommendations to customers? They don’t, but they should, and with data apps the data team can make this a reality.

Join TJ Murphy of Multi Media LLC, Kevin Chao from Ramp, and Tejas Manohar from Hightouch to hear examples of data apps in the real world. Their aim is to give data practitioners a framework for when and why to use the warehouse for production applications, and why the data team is the right team for this undertaking.

TJ will walk through the data apps he built at Minted, including a user personalization service and marketing automation tools. At Minted, the data team supported a GraphQL layer on top of the warehouse that supported both web and mobile app personalization on a per user basis.

Kevin Chao will share how Ramp, a fintech leader valued at $8B, is using dbt and Hightouch to power compliance via Snowflake as the source of truth.

Tejas will share how Supr Daily, the Instacart of India, runs product recommendations in their mobile app and automatically sends push notifications at opportune moments to convert users at a higher rate.

Lastly, TJ will give a practical overview of architecture, and a checklist of what to think through before building a Data App.

Check the slides here: https://docs.google.com/presentation/d/1LMuuuvVy3QD2ZAltp5c1Eh5Ik4LgM0q-AMlThsZVR40/edit#slide=id.g166573b6b47_0_0

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

The days of unrestrained cloud spending are coming to an end. In the coming months, data teams will increasingly be asked to better understand, monitor and reduce their data warehouse spend. The problem? Practitioners aren't equipped with the tools to do this well. In this talk, Ian Whitestone (Shopify) and Jonathan Talmi (Snapcommerce) will share their own end-to-end process for cutting warehouse spend, diving into the actual strategies they've deployed to give practitioners immediately actionable processes and techniques to keep costs controlled.

Check the slides here: https://docs.google.com/presentation/d/1SDONuIrAHbdDF0YyZ5krmAnibUTJbL9qosEeoDjFRPM/edit#slide=id.p

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/.

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/.