Scaling data teams from zero is hard: there are no easy shortcuts, and it is hard to find clear examples to learn from. That’s why we are very excited to co-present the work we did at On Deck over the last year: starting in Summer 2021 we built a data team from scratch, relying heavily on dbt as the core data modelling environment. Come hear us talk about how we set up the team, prioritised the many different requirements from an ever expanding team of stakeholders and, after just a few months, succeeding in moving On Deck away from a no-code data architecture (with more than 400 SaaS tools) and towards a centralised data model in dbt. We think the lessons (and especially the pitfalls) are worth telling!

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

User stitching can be cumbersome; third-party tracking, expiring cookies, browser privacy features, and users not being logged in. These challenges require companies to rethink how they collect and use data, and how they want to establish a mutually beneficial relationship with their users. In this session, learn how to solve these problems with an architecture that allows you to implement and control first-party tracking with data creation and data modelling, enabling you to easily set up user stitching. Learn how this directly drives the development of smarter data products that leverage user identity resolution, leading to more user engagement and growth.

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

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

Lineage is a critical component of any root cause, impact analysis, and overall analytics heath assessment workflow. But it hasn’t always been easy to create, particularly at the field level. In this session, Mei Tao, Helena Munoz, and Xuanzi Han (Monte Carlo) tackle this challenge head-on by leveraging some of the most popular tools in the modern data stack, including dbt, Airflow, Snowflake, and ANother Tool for Language Recognition (ANTLR). Learn how they designed the data model, query parser, and larger database design for field-level lineage—highlighting learnings, wrong turns, and best practices developed along the way.

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

See how visual data modeling and dbt combine to improve interaction and understanding between analytics engineering practitioners, product owners, and business partners. We will demonstrate conceptual and logical modeling techniques and diagrams to establish common understanding, enhance business partner collaboration, enhance translation of requirements, and ultimately complement analytics engineering within dbt to improve time to value. Demonstrate how to pair data modeling concepts (conceptual, logical, physical) and tools (SqlDBM) to engage your customers and inform the analytics engineering with dbt and Snowflake. We will show how this workbench and tools complement the analytics lifecycle for engineers and data consumers alike. The workbench includes a dbt, a visual modeling tool, and phData Toolkit CLI.

This session requires pre-registration. Sign up here. If session is filled you are welcome to come to the room and join the waitlist onsite. Open seats will be made available 10 minutes after session start.

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

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

Data apps are the next wave in analytics engineering. The explosion of data volume and variety combined with an increasing demand for analytics by consumers, and a leap in cloud data technologies triggered an evolution of traditional analytics into the realms of modern data apps. Question is: How do you prepare for this wave? In this session we’ll explore real-world examples of modern data apps, and how the modern data stack is advancing to support sub-second and high concurrency analytics to meet the new wave of demand. We will cover: performance challenges, semi-structured data, data freshness, data modeling and toolsets.

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

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

The gap between engineering and business teams is widening. The better engineering teams get at iterating to support new features, the harder it is for business teams to keep up with the nuance in a rapidly evolving customer journey. In this session, Rachel Bradley-Haas (BigTimeData.io) takes a step back to explain why defining entities, relationships, and properties, helps build a scalable and cohesive data model that business users can action to accelerate PLG motions.

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

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