We'll explain how Spectacles makes dbt developers more confident and efficient by revealing the impact of their proposed changes on Looker—preventing dashboard outages and angry analysts.

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

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

This fast paced course will focus on rapidly teaching you the basics of dbt. We’ll cover the foundational knowledge you’ll need to experience the power of dbt. You will walk away understanding how dbt enables rapid development of transformation code, quality assurance, and deploying your transformations on a schedule.

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

Everyone is talking about data lineage these days, and for a good reason. Data lineage helps ensure better data quality across your modern data stack. But not everyone speaks the same lineage language. Data engineers use lineage for impact and root cause analysis. Analysts and Analytics engineers use lineage to trace jobs and transformations in their warehouses. And consumers use lineage to understand why data never reached their expected destination. This results in a narrow, siloed view lineage in which only one group benefits. It’s time to stop using siloed lineage views for pretty graphs and start using end-to-end lineage to drive focused actions. In the talk, you will learn:

• How data quality tailors to specific needs of data engineers, analysts, & consumers

• How data lineage should drive actions

• A real-world example of end-to-end data lineage with Airflow, dbt, Spark, and Redshift

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

Striim is a unified data streaming and integration product that offers change capture (CDC) enabling continuous replication from popular databases to target data warehouses. John will show how you can use Striim and dbt to stream and model data to deliver fresh insights to all your business consumers.

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

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

The tech talent shortage is now just the tech talent situation—it’s here to stay. But when growth is glamorous, throwing bodies at a problem is still winning out over doing more with less. Until this year. The current economic climate is showing us that it’s time to make “efficient” the new “sexy.” In this talk, Matthieu DiMercurio (Dialogue.co) shares how to cultivate executive buy-in to unite Data, Engineering, and IT in a joint endeavor to automate tasks, build smarter systems, and cut costly silos.

Check the slides here: https://docs.google.com/presentation/d/1_qpYiP1h5O_f-Zi4_-SdsSBdcHSVNfJShpMmdj5TFEg/edit#slide=id.g158dd6daaf3_0_114

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 the slides here: https://docs.google.com/presentation/d/1xJEyfg81azw2hVilhGZ5BptnAQo8q1L7aDLGrnSYoUM/edit?usp=sharing

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

M&A can be fast-paced and messy, but companies often count on the data team to provide stability in metrics and data consolidation. After Dutchie acquired two companies in March 2021, the data team needed to integrate datasets from those companies into existing data platforms, and has some takeaways that may be helpful towards data practitioners one day finding themselves in a similar situation.

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

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

Do you enjoy waking up in the morning and playing the daily Wordle puzzle? Have you been wishing there was a similar game for you to play, but was built specifically for data folks? Well, you are in luck!

Join Joe Markiewicz (analytics engineer by day, video game maker by night) as he explains his inspiration and how he leveraged dbt and BigQuery to create a new video game aimed at helping experienced analysts keep their SQL skills sharp and data newcomers increase their SQL literacy.

Check the slides here: https://docs.google.com/presentation/d/1C1qUZEcpfBa6oA_CTHGx3GR1WLW3s2adVXnX2BRKVWA/edit

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

What do you do when you find out that your team is being tasked with building a single platform that should be able to serve everyone's data needs, no matter whether they are internal (from within your company) or external (your customers)? What's more it's expected to be fast, stable, granular, sophisticated, simple, scalable, usable, easy to maintain, compatible… the list goes on.

Well, time to find a new-school solution. We'll walk you through our story of how and why we built Slido's dataAPI using everyone's favourite Analytics Engineering tool, dbt.

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

Python model support is one of the hottest topics in the dbt Community Slack right now—but also one of the most intangible. What’s possible? What’s practical? What’s the point? In this session, Eda Johnson (Snowflake) will show how Snowpark Python further enhances a dbt + Snowflake development experience by supporting new workloads, including Machine Learning within your dbt DAGs.

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

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

At Preset, we offer a managed service for Apache Superset, the most popular open source business intelligence platform (by Github stars) in the world. We believe the future of BI is not only rooted in open source but also adopts the best ideas from the software development life cycle. To that end, we've created a workflow that enables you to manage Superset datasets, charts, and dashboards as code and we integrated dbt into our platform. In this talk, I'll showcase the speed and change management benefits that are enabled by this workflow of managing core BI assets using dbt and version control.

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

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

Two teams of three data analysts compete in a series of challenges in this ultimate showdown. Who will reign supreme?

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

dbt’s powerful capabilities allow data teams to deliver data products and analytics solutions to solve business problems faster than ever. Yet still, even with the best modern technologies, challenges arise. How can you be certain what your building will stand up to changing requirements? How can you connect disparate parts of your business to derive new insights? The answer may be a blast from the past—but the fundamentals never change. Learn how to apply fundamental techniques—like dimensional modeling—to modern tools, helping you to build scalable and reusable solutions to solve data problems today, and in the future.

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

for a few use cases like static and passive data catalogs. However, active metadata can be the key to unlock a variety of use cases, acting as the glue that binds together our diverse modern data stacks (e.g. dbt, Snowflake, Fivetran, Databricks, Looker, and Tableau) and diverse teams (e.g. analytics engineers, data analysts, data engineers, and business users)! At Atlan, we’ve worked closely with modern data teams like WeWork, Plaid, PayU, SnapCommerce, and Bestow. In this session, we’ll lay out all our learnings about how real-life data teams are using metadata to drive powerful use cases like column-level lineage, programmatic governance, root cause analysis, proactive upstream alerts, dynamic pipeline optimization, cost optimization, data deprecation, automated quality control, metrics management, and more. P.S. We’ll also reveal how active metadata and the dbt Semantic Layer can work together to transform the way your team works with metrics!

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

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

Data teams are tasked with integrating a growing number of data sources, and enabling broad, self-service access to a consistent and unified view of that data to a growing number of technical and non-technical data consumers for analytics. In this session, learn how dbt and the Dremio open lakehouse platform work together to simplify data architectures, unify data sources, and get insights into the hands of data consumers fast, and how the new connector delivers a seamless user experience across platforms.

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

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

When Prateek Chawla, founding engineer, joined Monte Carlo in 2019, he was responsible for spinning up our data platform from scratch. He was more of a backend/cloud engineer, but like with any startup had to wear many hats, so got the opportunity to play the role of data engineer too. In this talk, we’ll walk through how we spun up Monte Calro’s data stack with Snowflake, Looker, and dbt, touching on how and why we implemented dbt (and later, dbt Cloud), key use cases, and handy tricks for integrating dbt with other popular tools, like Airflow, and Spark. We’ll discuss what worked, what didn’t work, and other lessons learned along the way, as well as share how our data stack evolved over time to scale to meet the demands of our growing startup. We’ll also touch on a very critical component of the dbt value proposition, data quality testing, and discuss some of our favorite tests and what we’ve done to automate and integrate them with other elements of our stack.

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

dbt makes easy things easy and hard things possible. But there’s a few things that you really shouldn’t try if you value your time—and sanity. In this light-hearted session, Randy Pitcher (dbt Labs) will share some of the most common (and egregious) dbt workarounds that can tank your project, productivity, and pride.

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

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

Building consistent, trustworthy data sets may start with analysts, but to make it work, we have to bring others to the table. I’ll share a business person’s take on how rethinking BI will help get trusted data to every corner of your organization – and eliminate those “my number says this…” conversations. I’ll show what Mode’s been working on to bring metrics to life for both data teams and business teams since Benn’s fateful blog post last year. Spoiler alert: it starts outside the tools by bringing teams closer together, crafting common language, and moving at the speed of business today.

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

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

There’s no “one-size-fits-all” when it comes to one’s career journey. This workshop will give you a framework to refactor and/or develop your data career path, from data engineers to business analysts, individual contributors to managers. We’ll outline a structure for unique career path development. This workshop will benefit individual contributors who work for rapidly growing companies and want help managing up, and managers who want to further their career while also building career paths for their teams!

Check the slides here:https://docs.google.com/presentation/d/10XZCyQ9JT8Zle9FgbxIU7HNFKas0OU9pGzLXcFJdZNg/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/.

Your CCO slacks you at 9pm. A multi-million-dollar account is underperforming, and your quarter’s churn goal is on the line. But what does underperforming mean? Who decided? And why are you only just hearing about it now? It’s your job to answer all of those questions—before tomorrow morning. In his session, Adam Whitaker (Bluecore) shares how his team compeltely redesigned their customer retention and reporting programs with a new way to build reliable deal forecasts, automate operations and alerting, and swap opaque health scores for real-time actual/projection comparisons.

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

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

In this session, Guillermo Sanchez, (GoDataDriven) will attempt to summarize the last four major socio-technical changes that data teams have faced in the last few years, and why dbt plus the highly contentious data mesh might be the answer to each.

Check the slides here: https://drive.google.com/file/d/1LRmAJt3roIASxgJKIFsqbyZPcQrxjhAR/view?usp=sharing

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

The Databricks Lakehouse Platform unifies the best of data warehouses and data lakes in one simple platform to handle all your data, analytics and AI use cases. Databricks now includes complete support for dbt Core and dbt Cloud and you will hear from Conde Nast using dbt and Databricks together to democratize insights. We will also share best practices for developing and productionizing dbt projects containing SQL and Python, governing data with standard SQL, and exciting features on our roadmap such as materialized views for Databricks SQL.

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