Drill to Detail Ep.82 'Looker Development, Automated Testing and Spectacles' with Special Guest Josh Temple

Mark Rittman is joined in this episode by Josh Temple, Analytics Engineer at Spotify to talk about analytics development, automated testing and Spectacles, an open-source tool and SaaS service that automatically tests your LookML to ensure Looker always runs smoothly for your users.

• Spectacles product homepage and early access program

• Data Tests in Looker

• Automated testing in the modern data warehouse

• #JOIN19 - Using Customized Open-Source Tools With LookML

• Continuous Integration and Automated Build Testing with dbtCloud

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