Drill to Detail Ep.81 'Meltano, Singer Taps and Open-Source Data Pipelines' with Special Guest Douwe Maan

Mark Rittman is joined in this episode by GitLab.com Lead Developer Douwe Maan to discuss the history of the open-source Meltano project and its recent refocus on becoming the "glue" that creates open-source data pipelines, using plugin technologies such as Singer Taps and dbt transformations.

• Meltano homepage and quickstart demo

• Hey, data teams - We're working on a tool just for you

• Revisiting the Meltano strategy: a return to our roots

• Why we are building an open source platform for ELT pipelines

• Singer - Simple, Composable, Open Source ETL

• dbt Models - Everything is a select

• Meltano Slack Community

Drill to Detail Ep.80 'Data Architecture and Data Teams at Hubspot' with Special Guest James Densmore

Mark Rittman is joined in this episode by Hubspot's Director of Data Infrastructure James Densmore to talk about distributed and remote-friendly data teams, DevOps with dbt and Apache Airflow and career path options for data engineers.

• How should I structure my data team? A look inside HubSpot, Away, M.M. LaFleur, and more (dbt Blog)

• Software Engineers do not Need to Become Managers to Thrive (Data Liftoff Blog)

• The Misunderstood Data Engineer (Data Liftoff Blog)

• Modular ELT (Data Liftoff Blog)

• Test SQL Pipelines against Production Clones using DBT and Snowflake (Dan Gooden)

• HubSpot Data Actions, Harvest Analytical Workflows and Looker Data Platform (Rittman Analytics Blog)

Drill to Detail Ep.79 'Scaling the Modern Data Analytics Stack' with Special Guests Drew Banin and Stewart Bryson

Mark Rittman is joined by special guests Drew Banin, co-founder of Fishtown Analytics and maintainer of dbt (data build tool) and Stewart Bryson, long-time friend of the show and CEO/Co-founder of Red Pill Analytics to talk about scaling modern data stack projects from startups to the enterprise; how do you deal with data quality issues when there’s no central record of customers, how do we introduce data governance, enterprise requirements and meet the needs of enterprise architects and how do we scale concepts such as agile and analytics as engineering beyond our initial champion and data team?

• The dbt Viewpoint

• Fishtown Analytics and Drew Banin

• Multi-Channel Marketing Attribution using Segment, Google BigQuery, dbt and Looker

• Getting Started with dbt.

• Red Pill Analytics

Drill to Detail Ep.78 ‘Coronavirus, Shutdowns and the Data Analytics Industry’ with Special Guest Seth Rosen

In this special episode of Drill to Detail Mark Rittman is joined by Seth Rosen, Co-Founder and Principal at Hashpath to talk about the impact of COVID-19 and the subsequent economic shutdown on the business of analytics and product startups, the work being done in the community to help find a cure and the role that data and analytics can have in accelerating the post-shutdown recovery.

• “A COVID-19 Dashboard for Massachusetts using Looker and BigQuery” - Hashpath.com blog

• “The Virus Survival Strategy for your Startup"

• “COVID-19: Implications for business” - McKinsey

• “As COVID-19 data sets become more accessible, novel coronavirus pandemic may be most visualized ever” - ZDNet.com

• “Leave COVID-19 analysis to the experts” - Japan Times

Drill to Detail Ep.72 'Conversion Rate Optimization and Other CRAP' with Special Guest Bhav Patel

In this final Drill to Detail Episode before we take a break for the summer, Mark Rittman is joined by Bhav Patel, founder of the London Conversion Rate, Optimization and Product Analytics Meetup to talk about Conversion Rate Optimization, Experimentation and A/B Testing, Customer vs. Product Analytics, Attribution and Personalization ... and the story behind the CRAP Meetups.

• CRAP Talks: CRO, Analytics and Product London

• CRAP Talks on Slack

• Analytics, BigQuery, Looker and How I Became an Internet Meme for 48 Hours (CRAP Talks presentation)

• McDonald’s is acquiring Dynamic Yield to create a more customized drive-thru (TechCrunch)