Explore the pivotal role of metadata monitoring in revolutionizing your data team’s operations. Uncover how metadata serves as the key ingredient in addressing cost-related challenges, data monitoring, and mitigating ever-growing data sprawl. Discover its crucial function in cost-effective data management and compliance assurance.

Using real-world examples and practical tips, learn how to empower data stewards to proactively address systemic issues, optimize storage and resource allocation, and strategically guide the evolution of data infrastructures to align with organizational goals. Understand how to unlock the potential of metadata, and gain a fresh perspective on optimizing your data strategy.

Speaker: Etai Mizrahi, Co-Founder & CEO, Secoda

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

In this session, learn how Prime Therapeutics' data team was able to implement dbt for multiple teams and environments in a highly-controlled way without compromising security or performance. With multiple teams and environments, it was essential to manage and maintain consistent policies across environments while helping share best practices to improve their dbt implementations.

Speakers: Jill Aakhus, Principal Analytics Engineer, Prime Therapeutics; Anubhav Pareek, Data Analytics Engineer, AICG

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

Take a look at how the finance data team at Snowflake leverages dbt to drive strategic decision-making within the finance and accounting organizations. This talk spans topics including development velocity, cost governance, and data stewardship.

Speakers: Sandra Herchen, Analytics Engineering Manager, Snowflake; Jack Peele, Business Intelligence Analyst, Snowflake

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

Unlike transforming staged data to marts, ingesting data into staging requires robustness to data volume and type changes, schema evolution, and data drift. Especially when performing change data capture (CDC) on large databases (~100 tables to a database), we’ll ideally reinforce our dbt models with automatic:

• Mapping of dynamic columns and data types between the source and the target stag
• evolution of stage table schemas at pace with incoming data, including for nested data structures
• parsing and flattening of any arrays and JSON structs in the data.

Manually performing these tasks for data at scale is a tall order due to the many permutations with which CDC data can deviate. Waiting to implement them in mart transformation models is potentially detrimental to the business, as well as doesn’t reduce the complexity. Santona Tuli shares learnings from integrating dbt Core into high-scale data ingestion workloads, including trade-offs between ease-of-use and scale.

Speaker: Santona Tuli, Head/Director of Data, Upsolver

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

Join us for story hour, as we follow two intrepid analytics engineers working in a large dbt project as they go on a journey to meshify their dbt project, with help from a ✨special guest✨

Along the way, learn about dbt-meshify - a new CLI tool to automate the creation of model governance and cross-project lineage features in your dbt project. dbt-meshify refactors your code for you, helping you add model contracts, versions, groups, access, cross-project lineage, and more -- all in a matter of minutes! No bespoke YAML writing needed.

Speakers: Grace Goheen, Product Manager, dbt Labs; Nicholas Yager, Principal Analytics Engineer, HubSpot; Dave Connors, DX, dbt Labs

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

The Guild team migrated to Snowflake and dbt for their data warehousing needs and immediately saw the benefits of standardizing model structure, DRYer logic, data lineage ,and automated testing on Pull Requests.

But leveraging dbt didn’t solve everything. Pain points around maintaining model logic, handling historical data, and integrating data from over 60 source systems meant that analysts still struggled to provide a unified view of the business. The team knew that they needed to level up their processes and modeling again, and chose to adopt Data Vault (DV).

Brandon and Rebecca take you behind the scenes of this decision to explain the benefits of Data Vault. They highlight DV’s ability to handle complex data integration requirements while remaining agile and demonstrate that it complements other modern data concepts like domain-driven design and data mesh.

Attendees learn what Data Vault is, when it can be a key component of a successful data strategy, and instances where it’s not the right fit. Walk away with practical tips to successfully transition based on a real-world implementation.

Guild transformed their data warehouse; you can too!

Speakers: Brandon Taylor, Senior Data Architect, Guild; Rebecca Di Bari Staff Data Engineer , Guild

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

No one believes the marketing attribution model. Companies want clarity about how to attract and land high value customers. It’s easy to get lost trying to build an attribution model that reflects reality without lying or oversimplification. What if there was a better way? This session helps any analyst, analytics engineer, or marketing professional that has ever had to grapple with attribution or conversion analytics.

Speaker: Amanda Fioritto, Analytics Engineer, Hex

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

In the dbt Labs on dbt series, you get a behind-the-scenes look at how dbt Labs uses data. You’ll learn how dbt Labs thinks about the role of data, how data developers collaborate with business leaders, and the technical decisions we’ve made in our own dbt project.

In this session, Brandon Thomson, Analytics Lead at dbt Labs, digs deeper into the technical details of the Campaign 360, a powerful marketing analytics asset used by every member of the marketing team. You'll learn about the technical decisions made during the build of this product and explore the finished asset.

Join this session to learn about dbt Labs' journey and leave with ideas that you can implement in your dbt project today.

Speaker: Brandon Thomson, Analytics Lead, dbt Labs

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

The final session of Coalesce 2023! Join us for Community Awards and closing thoughts. We recognize 10 individuals who have contributed significantly to the success of the dbt Community. Some of them will be with us in person, and some others will be tuning in online. All Community Award recipients are recognized and presented with a unique, never-before-seen swag item!

After the awards, we end with closing thoughts and announce the location for Coalesce 2024!

Speakers: Amada Echeverría, Global Community Lead, dbt Labs; Tristan Handy, CEO, dbt Labs

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

With increased adoption of dbt and ever growing data volumes, data teams are increasingly looking to make their dbt deployments more efficient. The problem? Practitioners aren’t equipped with the tools and strategies to do this well. In this talk, Ian Whitestone and Niall Woodward of SELECT share a variety of dbt cost and performance optimization best practices, diving into the actual strategies they’ve deployed with numerous companies to give practitioners immediately actionable techniques they can apply to their own projects.

Speakers: Ian Whitestone, Co-founder, SELECT; Niall Woodward, Co-Founder, SELECT

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

The self-serve revolution remains unrealized despite BI tools from Business Objects to Tableau and Looker all aiming for that holy grail. What went wrong? This talk argues that for self-serve to work, it has to work the way humans already work.

Speaker: Paul Blankley, CTO / Co-founder, Zenlytic

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

A financial institution's success hinges on its ability to remain competitive in the digital space and the evolve its data culture. Fifth Third’s vision for data modernization isn’t just about adopting the latest technologies; it’s about enhancing the employee experience with data and promoting Data Product ownership. This breakout explores the bank’s transition from legacy to modern data architecture, showcasing its realistic commitment to people, process and technology.

Speakers: Kayleigh Lavorini, VP - Director of Product Ownership | Data Strategy, Fifth Third Bank; Ben Rottinghaus, SVP | Senior Director, Data Engineering, Fifth Third Bank

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

This panel discussion led by Data Clymer brings together data leaders from some of the top professional sports organizations in the U.S. to explore how sports and similar mid-size businesses are leveraging data and analytics engineering best practices to fuel revenue growth, improve business efficiencies, and drive fan engagement.

Speakers: Jesse McCabe, Vice President Marketing, Data Clymer; Keelan Smithers, Data Product Manager, Analytics Engineering, NBA; Paimon Jaberi, Managing Director of Strategy and Analytics, Seattle Seahawks; Jared Chavez, Senior Data Engineer, Pacers Sports & Entertainment

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

As analytics engineers, we know that getting the data model right is crucial for successful data analytics. However, communicating requirements and needs can be a challenge, especially for junior data team members. After noticing too many post-PR revisions and missed requirements, Wellthy began developing a communication framework that has helped streamline and clarify the requirements gathering process for new models.

Their framework is designed to help analysts visualize and anticipate what they need from a dataset, resulting in a more efficient and effective data modeling process for the analytics engineer. In this talk, Kelly Pook shares Wellthy's experiences and best practices using these frameworks, as well as the benefits seen in terms of accuracy, efficiency, and time savings.

Speaker: Kelly Pook, Senior Analytics Engineer, Wellthy

In this session, you'll learn tips and tricks from La-Z-Boy on how to modernize infrastructure and tackle complex retail and manufacturing data problems using dbt and Fivetran. Hear from a data leader about their experience and how you can replicate their success. Start your session off with some comfortable data movements to make sure you can extract as much information as possible from our loaded session on data transformation.

Speakers: Alex Hauer, Lead Product Marketing Manager, Fivetran; Selwyn Samuel, Director of Data Analytics & Enterprise Architecture, La-Z-Boy

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

In the dbt Labs on dbt series, you get a behind-the-scenes look at how dbt Labs uses data. You’ll learn how dbt Labs thinks about the role of data, how data developers collaborate with business leaders, and the technical decisions we’ve made in our own dbt project.

In this session, Elize Papineau, Senior Data Engineer at dbt Labs, digs deeper into the technical details of the cost optimization project at dbt Labs. You'll learn how the team leveraged query tags in dbt to make model performance monitoring possible, the process for analyzing model performance, the implementation of warehouse specific configurations at the model level, and how the team measures the effectiveness of optimizations and translates it into cost savings.

Watch to learn about dbt Labs' journey and leave with ideas that you can implement in your dbt project today.

Speaker: Elize Papineau, Sr. Data Engineer, dbt Labs

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

Artyom Keydunov, Co-founder & CEO of Cube, discusses the future for the semantic layer, uniting BI tools, embedded analytics, and AI agents. This new approach brings together data, enabling data tools to introspect data model definitions and seamlessly interoperate within the data stack. By embracing this new approach—data practitioners will reap the benefits with enhanced user experiences, quicker data delivery, and streamlined workloads. See how a semantic layer can harmonize your data tools to drive maximum impact for yourself and end-users.

Speaker: Artyom Keydunov, Co-founder & CEO, Cube Dev

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

Two public servants at the City of Boston and the State of California are tasked with improving data services and data engineering practices within their respective governments. As part of the modernization process, they are adopting dbt and associated tools within their respective teams.

This session discusses the similarities and differences between the implementations of dbt, and how some of the constraints and challenges of working in government shape both the technical and social design of data services. The speakers will reflect on successes, challenges, and lessons learned about adopting modern data tooling in state and local governments.

Speakers: Jenna Jordan, Data Engineer, City of Boston; Ian Rose, Senior Data Engineer, California Office of Data and Innovation; Laurie Merrell, Senior Analytics Engineer, Jarvus Innovations

This session addresses the problem of how to leverage dbt Cloud to support domain user development for a migration from a centralized analytics environment towards a distributed data mesh analytics environment.

Speaker: Holly Burch, Data Architect, Sharp HealthCare

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

Prioritizing the right sales opportunities is pivotal for any SaaS company's growth, but what happens after your initial success? Jessica Zhang, Data Science Manager at Notion, traces Notion's footsteps from its foundational days to its present-day lead scoring techniques. Learn how modern tools like dbt, Census, and Snowflake enable the Notion team to iterate quickly. More than a journey, this session is a lesson on evolving a data science model in response to changing business assumptions and fresh user insights.

Speakers: Jessica Zhang, Data Science Manager, Notion; Jeff Sloan, Sr. Data Community Advocate, Census

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

In this session, Jeremy Cohen, product manager at dbt Labs, does an in-depth walk-through of the new dbt Cloud releases shared on-stage during the Keynote & Product Spotlight. This session focuses on changes to the dbt Cloud IDE and new ways to develop with dbt.

Wherever you write code, see the future of dbt development in action.

Speakers: Jeremy Cohen, Product Manager, dbt Labs; Greg McKeon, Product Manager, dbt Labs

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

In the rapidly evolving landscape of data technology, the integration of Snowflake and dbt has revolutionized the creation and management of data applications. Now, developers can harness their combined capabilities to build superior, scalable, and sophisticated data applications.

With Snowflake’s cloud-based architecture, developers can access boundless storage, computing, and seamless data sharing. Additionally, Snowpark Python enables the performance of data transformation, analytics, and algorithmic functions within Snowflake, presenting developers with a new realm of opportunities. Incorporating dbt further enhances the synergy, allowing developers to streamline data workflows in an agile, model-driven environment.

This session covers how the Snowflake and dbt partnership can pave the way toward building better, future-proof data applications that cater to the dynamic needs of businesses in the digital era.

Speaker: Tarik Dwiek, Head of Technology and Application Partners, Snowflake

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

Now that you can write models in Python, a new world of possibility has opened up. In this session, Christopher Marland introduces you to Snowpark and how it integrates with dbt, before demonstrating a real-world use case where Python transformations outperform SQL, starting from raw data and moving through to a completed analysis.

This talk is ideal for people who are familiar with PySpark but new to dbt, or who are experienced dbt users and curious about taking advantage of their new Pythonic superpowers from inside of a familiar development environment.

Speaker: Christopher Marland, Snowflake Solutions Architect, Aimpoint Digital

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

When a startup is in its early stages, the data infrastructure is typically built with the best intentions, but doesn’t necessarily scale, and often predates many modern data tools available today. Years later, you might find yourself juggling complexity and tech debt when providing insights. This talk shares the journey Unbounce embarked on to modernize their data stack, including approaches to the following hurdles: demonstrating value and ROI to leadership for buy-in; deciding which tools to adopt; coordinating with data engineers and data analysts to deliver the cross-team project; and ensuring there were no interruptions to stakeholders throughout the migration.

Speaker: Morgan Cabot, Analytics engineering technical lead, Unbounce

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

Advances in LLM technology and the semantic layer have made AI-powered data analytics easy. Nothing special. Par for the course.

Wait, you haven't seen yet? Don't worry, we'll show you. But I gotta warn you, it's pretty boring stuff. You just ask for whatever data you want, and then the computer gets it for you. Yes, seriously!

So what is still impressive in October 2023? Well, good old fashioned human ingenuity and improvisational skill. Computers may have gotten pretty good at crunching the numbers, but you still can't replace good old fashioned meat and bone when it comes time to present those numbers to the big boss.

In this session, Izzy Miller and Matt David put that to the test with a live game of Dashboard Karaoke— with an AI twist. Random audience members take turns using Hex's Magic AI to generate entire analytical reports on datasets of their choosing. Then, our handpicked data practitioners have to improvise a compelling presentation of the results on the spot, explaining the intricacies and trends of data they've never seen. And of course, there will be plenty of time for audience questions ;)

Speakers: Izzy Miller, Developer Advocate, Hex; Matt David, Product Marketing Lead, Hex

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