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.

Drill to Detail Ep.26 'Airflow, Superset & The Rise of the Data Engineer' with Special Guest Maxime Beauchemin

Mark Rittman is joined by Maxime Beauchemin to talk about analytics and data integration at Airbnb, the Apache Airflow and Superset open-source projects he helped launch and now works with day-to-day at Airbnb , and his recent Medium article on "The Rise of the Data Engineer".

• "The Rise of the Data Engineer" blog by Maxime Beauchemin
• Apache Airflow
• Airbnb Superset
• "Engineers Shouldn’t Write ETL: A Guide to Building a High Functioning Data Science Department" blog by Jeff Magnusson

Drill to Detail Ep.23 ‘Looker, BigQuery and Analytics on Big Data’ With Special Guest Daniel Mintz

Mark Rittman is joined by Daniel Mintz from Looker to talk about BI and analytics on Google BigQuery, data modelling on the new generation of cloud-based distributed-data warehousing platforms, and Looker's re-introduction of semantic models to big data analytics developers.

Drill to Detail Ep.20 'MapR Platform Differentation, Scaling Hadoop and Microservices' With Special Guest Tugdall Grall

Mark Rittman is joined in this episode by MapR's Tugdall Grall to talk about MapR's platform differentation and relationship with open-source Hadoop, scaling and streaming, microservices, and MapR's platform strategy around big data workloads in the cloud.

Drill to Detail Ep.19 'Elasticsearch, Elastic Stack & Elastic Cloud' With Special Guest Mark Walkom

Mark Rittman is joined by Elastic's Mark Walkom to talk about Elasticsearch, Kibana, Logstash and the Elastic Stack; business models built-around an open-source software core; and their move into cloud services with Elastic Cloud

Drill to Detail Ep.17 ‘Mode 1 Analytics and the Future of Cloud DWs’ With Special Guest Rick Greenwald

Mark Rittman is joined by Gartner analyst and ex-Oracle Database Cloud Service PM Rick Greenwald to talk about IT’s continuing (and essential!) role in corporate BI&DW deployments and the debate around Mode1 vs. Mode2 Analytics, how we got here, and the future of data warehousing database platforms as we move into the cloud.

Drill to Detail Ep.16 'Qubit, Visitor Cloud & Google BigQuery' With Special Guest Alex Olivier

Mark Rittman is joined by Alex Olivier from Qubit to talk about their platform journey from on-premise Hadoop to petabytes of data running in Google Cloud Platform, using Google Cloud Dataflow (aka Apache Beam), Google PubSub and Google BigQuery along with machine learning and analytics to deliver personalisation at-scale for digital retailers around the world.

• Qubit Visitor Cloud and Qubit's Infrastructure
• "A new age of Machine Learning is here" - Qubit Blog
• How Qubit's Data Supply Chain Shows the Power of HBASE
• Big Data Analytics at Google Scale
• BigQuery for Data Warehouse Practitioners
• Alex Olivier on Qubit's Infrastructure at Google NEXT London 2016

Drill to Detail Ep.14 ‘Cloudy Big Data Paradigm-Shifting Christmas & New Year Special’ With Special Guest Robin Moffatt

Mark Rittman is joined in this Christmas & New Year special episode by none-other than Robin Moffatt, head of R&D at Rittman Mead and an old colleague from my consulting days, to talk about his experiences with Amazon Elastic MapReduce (EMR) for BI + Analytics and how "the devil's in the detail", and to hear his take on what happened in the BI and analytics world in 2016 and what to look out for in 2017.

ETL & Analytics Offload from Oracle to Amazon Web Services using Apache Spark, Redshift, and Presto

• Blog: https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-5/
• Other four articles in series : https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-1 / https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-2-code-development-with-notebooks-and-docker// https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-3-running-pyspark-on-emr / https://www.rittmanmead.com/blog/2016/12/etl-offload-with-spark-and-amazon-emr-part-4-analysing-the-data)

Source Control and Automated Code Deployment Options for OBIEE

• Blog: https://www.rittmanmead.com/blog/2016/12/source-control-and-automated-code-deployment-options-for-obiee/
• Slides: https://speakerdeck.com/rmoff/source-control-code-deployment-and-concurrent-development-for-obiee-12c

All You Ever Wanted to Know About OBIEE Performance…but were too afraid to ask

• Blog: https://www.rittmanmead.com/blog/2016/10/all-you-ever-wanted-to-know-about-obiee-performance-but-were-too-afraid-to-ask/
• Slides: https://speakerdeck.com/rmoff/still-no-silver-bullets-obiee-12c-performance-in-the-real-world

Apache Kafka's Role in Implementing Oracle's Big Data Reference Architecture on the Big Data Appliance

• Slides: https://speakerdeck.com/rmoff/kafkas-role-in-implementing-oracles-big-data-reference-architecture-on-the-big-data-appliance

Analysing the Panama Papers with Oracle Big Data Spatial and Graph

• Article : https://community.oracle.com/docs/DOC-1006400