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.34 'Qlik, MSAS and the Strategy of Data Analytics' with Special Guest Donald Farmer

Mark Rittman is joined by Donald Farmer to talk about his work at Microsoft on SQL Server Analysis Services and Integration Services, why he moved to Qlik and the challenges of evolving a BI product strategy from focusing on desktops to focusing on the enterprise, and some advice for customers, software vendors and partners working with data and analytics tools.

Drill to Detail Ep.31 'Dremel, Druid and Data Modeling on Google BigQuery' With Special Guest Dan McClary

Mark is joined by returning special guest Dan McClary to talk about data modeling and database design on distributed query engines such as Google BigQuery, the underlying Dremel technology and columnar storage format that enables this cloud distributed data warehouse-as-a-service platform to scale to petabyte-size tables spanning tens of thousands of servers, and techniques to optimize BigQuery table joins using nested fields, table partitioning and denormalization.

• Dremel: Interactive Analysis of Web-Scale Datasets
• BigQuery under the hood
• Inside Capacitor, BigQuery’s next-generation columnar storage format
• Drill To Detail Ep.2. 'Future Of SQL On Hadoop', With Special Guest Dan McClary
• Google BigQuery, Large Table Joins and How Nested, Repeated Values and the Capacitor Storage Format (and Looker) Saves the Day

Drill to Detail Ep.30 "AI, ML & Oracle's Adaptive Intelligence Applications" with Special Guest Jack Berkowitz

Oracle's Jack Berkowitz joins Mark Rittman to talk about a new category of continuously adapting, self-learning applications being built-out by Oracle that use machine learning together with enterprise and third-party data to create a new generation of intelligent HR, CX, SCM and ERP SaaS apps.

• "Adaptive Intelligence: What You Need to Know"
• Oracle's Adaptive Intelligence Apps product homepage

Drill to Detail Ep.29 'New-World BI Development using BigQuery, Looker, Kakfa and Streamsets' With Special Guest Stewart Bryson

Stewart Bryson returns to the show to join Mark Rittman to discuss new-world BI and data warehousing development using Google BigQuery and Amazon Athena, Apache Kafka and StreamSets, and talks about his experiences with Looker, the cloud-native BI tool that brings semantic modeling and modern development practices to the world of business intelligence.