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.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.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.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)