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)

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

Mark Rittman

Download

Drill to Detail Ep.71 'The Rise of Snowflake Data Warehouse' With Special Guest Kent Graziano

Mark Rittman is joined in this episode of Drill to Detail by returning guest Kent Graziano, Chief Technical Evangelist for Snowflake, to talk about Snowflake Data Warehouse's cloud-first architecture and recent product announcements at Snowflake Summit 2019.

• Try Snowflake Data Warehouse for free

• Watch Summit 2019 Keynotes

• Snowflake Materialized Views: A Fast, Zero-Maintenance, Accurate Solution

• Modern Data Sharing: The Opportunities Are Endless

• Drill to Detail Ep. 5 'SnowflakeDB, and is Data Modeling Dead?' with Special Guest Kent Graziano

Drill to Detail Ep.71 'The Rise of Snowflake Data Warehouse' With Special Guest Kent Graziano

Mark Rittman

Download

Drill to Detail Ep.67 'Thinking Probabilistically and Scaling-Out the Modern BI Stack' with Special Guest Dylan Baker

Mark Rittman is joined by Dylan Baker, freelance analytics consultant, to talk about thinking probabalistically, analytics within venture-funded startups, devops and its role in scaling-out the modern BI stack.

• dbanalytics.co

• lookeraccess utility

• Annie Duke – Wanna Bet? – [Invest Like the Best, EP.125]

• London dbt Meetup #2

Drill to Detail Ep.67 'Thinking Probabilistically and Scaling the Modern BI Stack' with Dylan Baker

Mark Rittman

Download

Drill to Detail Ep.66 'ETL, Incorta and the Death of the Star Schema' with Special Guest Matthew Halliday

Mark Rittman is joined by Matthew Halliday to talk about the challenge of ETL and analytics on complex relational OLTP data models, previous attempts to solve these problems with products such as Oracle Essbase and Oracle E-Business Suite Extensions for Oracle Endeca and how those experiences, and others, led to his current role as co-founder and VP of Products at Incorta.

• The Death of the Star Schema: 3 Key Innovations Driving the Rapid Demise

• Accelerating Analytics with Direct Data Mapping

• Accelerating Operational Reporting & Analytics for Oracle E-Business Suite (EBS)

• The Good, the Bad, and the Ugly of Extract Transform Load (ETL)

• E-Business Suite Extensions for Endeca: Technical Considerations

• The Pain of Operational Reporting Solutions for Oracle E-Business Suite (EBS)

Drill to Detail Ep.66 'ETL, Incorta and the Death of the Star Schema' with Matthew Halliday

Mark Rittman

Download

Drill to Detail Ep.63 'Stitch, Talend and the Evolution of Data Pipelines' with Special Guest Jake Stein

Mark Rittman is joined by returning Special Guest Jake Stein, former co-founder and CEO of Stitch and now SVP of Stitch at Talend to talk about the evolution of the data pipeline-as-a-service, data catalogs and data governance and the vision behind Talend’s acquisition of Stitch. 

• ”The Vision behind Talend's acquisition of Stitch”

• “Stitch is joining Talend”

• “dbt: Analytics Engineering that Works”

• Talend homepage 

Drill to Detail Ep.63 'Stitch, Talend and the Evolution of Data Pipelines' with Jake Stein

Mark Rittman

Download

Drill to Detail Ep.52 'Lyft, Ride-Share Analytics and ETL Developer Productivity ' With Special Guest Mark Grover

Mark Rittman is joined by returning Special Guest Mark Grover to talk about his move from Cloudera and product engineering to a product manager role at Lyft; analytics use-cases in the ride-sharing industry; and the move from conversations about ETL tools, technology and engines to templates, paradigms and developer productivity.

• Mark Grover LinkedIn Profile and Github Profile
• "Hadoop Application Architectures" 
• "Drill to Detail Ep. 7 'Apache Spark and Hadoop Application Architectures'
• Lyft Engineering Blog
• "Software Engineer to Product Manager" blog by Gwen Shapira
• "Introduction to the Oracle Data Integrator Topology" from the Oracle Data Integrator docs site
• Apache Airflow and Amazon Kinesis homepages 
• "Experimentation in a Ridesharing Marketplace" by Nicholas Chamandy, Head of Data Science at Lyft
• "How Uber Eats Works with Restaurants"
• "Deliveroo has built a bunch of tiny kitchens to feed more hungry Londoners" - Wired.co.uk

Drill to Detail Ep.52 'Lyft, Analytics + ETL Developer Productivity' With Special Guest Mark Grover

Mark Rittman

Download

Drill to Detail Ep.49 'Trifacta, Google Cloud Dataprep and Data Wranging for Data Engineers' With Special Guest Will Davis

Mark Rittman is joined by Will Davis from Trifacta to talk about the public beta of Google Cloud Dataprep, Trifacta's data wrangling platform and topics including metadata management, data quality and data management for big data and cloud data sources.

• Google Cloud Dataprep on Google Cloud Platform
• "Google Cloud Dataprep: Spreadsheet-Style Data Wrangling Powered by Google Cloud Dataflow"
• "A New Cloud-Based Data Prep Solution from Google & Trifacta"
• Trifacta website
• "A Breakthrough Approach to Exploring and Preparing Data"
• Trifacta platform architecture
• "Garbage In, Garbage Out: Why Data Quality Matters"
• "How to Put an Effective Metadata Strategy in Place"

Drill to Detail Ep.49 'Trifacta, Google Dataprep and Data Wranging' With Special Guest Will Davis

Mark Rittman

Download

Drill to Detail Ep.40 'Fivetran's Middleware for SaaS Data' With Special Guest Taylor Brown

Mark Rittman is joined in this episode by Taylor Brown from Fivetran to talk about middleware for SaaS data, their focus on integrations with SaaS vendors and how this differentiates their offering, his thoughts on packaged analytic applications announced at the recent Looker Join conference ... and where the name "Fivetran" came from.

• Fivetran website
• Fivetran Source and Target Integrations
• Looker 5 Release with new Analytic and Data Blocks
• "Comparison of Two Great ETL Tools: Fivetran vs. Stitch Data"

Drill to Detail Ep.40 'FiveTran's Middleware for SaaS Data' With Special Guest Taylor Brown

Mark Rittman

Download

Drill to Detail Ep.35 'Stitch Data, Singer and ETL for Data Engineers' With Special Guest Jake Stein

In this episode Mark is joined by Jake Stein to talk about Stitch Data and their ETL tool for data engineers, the new open-source project Singer and his experiences building a software startup that both partners and competes with the big cloud platform vendors.

• Stitch Data
• Singer: Simple, Composable Open-Source ETL
• Setting the Data Strategy for Your Growing Organization
• The State of Data Engineering
• The State of Data Science
• Why our ETL Tool Doesn't Do Transformations
• Airflow: a workflow management platform
• Goodbye RJMetrics, Hello Fishtown Analytics
• Engineers Shouldn’t Write ETL: A Guide to Building a High Functioning Data Science Department

Drill to Detail Ep.35 'Stitch Data, Singer and ETL for Data Engineers' With Special Guest Jake Stein

Mark Rittman

Download

Drill to Detail Ep.33 'Building Out Analytics Functions in Startups' With Special Guest Tristan Handy

In this episode Mark is joined by Tristan Handy from Fishtown Analytics to talk about building-out analytics functions in high-growth startups, and three related blog posts he wrote on this topic.

• Fishtown Analytics
• dbt (data build tool) and Fishtown Analytics Github repos
• “The Startup Founder’s Guide to Analytics”
• “What are the steps / tools in setting up a modern, SaaS-based BI infrastructure?”
• “Building a Mature Analytics Workflow: The Analyst Collective Viewpoint”

Drill to Detail Ep.33 'Building Analytics Functions in Startups' With Special Guest Tristan Handy

Mark Rittman

Download