Community sessions at Coalesce 2023

output.txt

Quote-to-Cash: Automating accounting's end-of-month close process (and passing our first SOX audit)
    Amber Oar (Rocket Money)
    2023-10-17 11:00:00

Peer exchange: Defining role boundaries in big orgs
    Jerrie Kumalah (SeatGeek), Phoenix Jay (KHealth)
    2023-10-17 12:15:00

Transforming healthcare by putting data in the driver’s seat at Vida Health
    Trenton Huey (Vida Health)
    2023-10-17 12:30:00

How Fanduel migrated a mature data organization
    Phillip  Tan (Fanduel), Michael Lee (Fanduel), Harry Williams (FanDuel)
    2023-10-17 13:30:00

Peer exchange: Strategies for skill acquisition
    Alexander Butler (Harness)
    2023-10-17 13:45:00

Warehouse-first data strategy at ClickUp
    Marc Stone (ClickUp)
    2023-10-17 14:30:00

From coast to coast: Implementing dbt in the public sector
    Jennifer Jordan (City of Boston, Department of Innovation & Technology), Ian Rose (California Office of Data and Innovation), Laurie Merrell (Jarvus Innovations)
    2023-10-17 14:30:00

60 sources and counting: Unlocking microservice integration with dbt and Data Vault
    Brandon Taylor (Guild), Rebecca Di Bari (Guild)
    2023-10-17 14:30:00

Building end-to-end ML pipelines using dbt and Snowpark
    Krishna Kakatur (Sidecar Health), Ken Nguyen (Sidecar Health)
    2023-10-17 15:15:00

Leveraging dbt Cloud for a distributed domain-driven development environment
    Holly Burch (Sharp HealthCare)
    2023-10-17 15:30:00

Driving toward data mesh at Rivian
    Will Bishop (Rivian)
    2023-10-17 15:30:00

Getting the data model right the FIRST time
    Kelly Pook (Wellthy)
    2023-10-17 15:30:00

dbt turbocharge: Boosting performance of your data models
    Juan Manuel Perafan (Xebia Data)
    2023-10-18 11:00:00

Learnings and practices for dbt at scale
    Jill Aakhus (Prime Therapeutics), Anubhav Pareek (AICG)
    2023-10-18 12:30:00

Analytics in Bloom: Improve your team's data literacy with pedagogy
    Faith Lierheimer (Parsyl)
    2023-10-18 12:30:00

10x-ing developer experience with Databricks, Delta, and dbt Cloud
    Chris Davis (Udemy, Inc.)
    2023-10-18 13:30:00

Beyond metrics modernization at Fleetio
    Jeffrey Chen (Fleetio)
    2023-10-18 13:30:00

Peer exchange: Building community in distributed teams
      (None)
    2023-10-18 14:00:00

Business process occurrence, volume, and duration modeling using dbt Cloud
    Jason Hodson (Routable)
    2023-10-18 14:30:00

A complete beginner's guide to Snowpark in dbt
    Christopher Marland (Aimpoint Digital)
    2023-10-18 15:30:00

How Rebtel increased data product value: A migration story
    Quentin  Coviaux (Rebtel)
    2023-10-18 15:30:00

Leveraging dbt Cloud to transform loan warehousing: scalable data pipelines empower financial analysts
    David Maguire (dv01)
    2023-10-18 15:30:00

dbt at scale: How Roche GTM manages multi-project deployments
    Tyler Rouze (Roche & Analytics8), Dr. Yannick  Misteli (Roche)
    2023-10-18 15:30:00

The career growth software development lifecycle
    Kasey Mazza (HubSpot)
    2023-10-19 10:00:00

The more, the merrier: Managing a dynamic, expanding, self-service dbt project
    Alice Leach (Whatnot)
    2023-10-19 11:00:00

From solos to symphony: Multi-project orchestration in Surgical Robotics
    Brice Loustau (Intuitive Surgical), Chris Nourse (Intuitive)
    2023-10-19 11:00:00

How to build a high-impact data team at a “growth at NOT-all costs” company
    Bill Lynch (NeuroFlow)
    2023-10-19 11:00:00

Overhauling tech debt: A modern data stack migration journey
    Morgan Cabot (Unbounce)
    2023-10-19 11:00:00

Taming BI sprawl with dbt: From 0 to 600 models in 18 months
    Matthew Hoss (Element Biosciences)
    2023-10-19 12:30:00

Starting over: Learning from mistakes to lay the foundation for a successful project
    Katie Claiborne (Cityblock Health), Nathaniel  Burren  (Cityblock Health)
    2023-10-19 12:30:00

Scaling dbt and BigQuery to infinity and beyond
    Adam Whitaker (bluecore), Nicole Dallar-Malburg (Bluecore)
    2023-10-19 12:30:00

Using JSON schema to set the (dbt) stage for product analytics
    Greg Clunies (Surfline)
    2023-10-19 13:30:00
    
On the benefits and virtues of drilling pilot holes
    Leo Folsom (Datafold) [Manually confirmed to not be vendor content. Thanks to Leo for letting me know!]
    2023-10-18 13:30:00

Community Sessions: 33
Total Sessions: 58

session_parser.py

# san-diego.json obtained from https://coalesce.getdbt.com/_next/data/MpkyRH7Y1Bq1T2hgNb0b3/agenda/san-diego.json

import json
import pprint
from dateutil.parser import parse
import datetime
import pytz

with open('san-diego.json') as file:
    raw_file = json.load(file)


sessions = raw_file['pageProps']['sessions']

sponsers = ['dbt Labs', 'Snowflake', 'Databricks', 'Fievetran', 'Census', 'Hex', 'SELECT', 'Hex', 'Mode', 'Secoda', 'phData', 'Workstream.io', 'Data Clymer', 'Datafold', 'Sigma Computing', 'Fivetran', 'Materialize']

total_sessions  = 0
community_sessions = 0
for session in sessions:
    if 'topicTags' not in session or len(session.get('speakers', [])) == 0:
        continue


    # pprint.pprint(session)
    is_vendor = any([speaker.get('company') in sponsers for speaker in session.get('speakers', [])])

    speakers = [f"{speaker.get('firstname', '')} {speaker.get('lastname', '')} ({speaker.get('company')})" for speaker in session.get('speakers', [])]

    start_time = (parse(session['startDate']) + datetime.timedelta(minutes=session['startMinute'])).replace(tzinfo=None)

    total_sessions += 1
    if not is_vendor:
        community_sessions += 1
        print(f"{session['title']}\n    {', '.join(speakers)}\n    {start_time}\n")

print(f"Community Sessions: {community_sessions}")
print(f"Total Sessions: {total_sessions}")