Drill to Detail Ep.44 'Pandas, Apache Arrow and In-Memory Analytics' With Special Guest Wes McKinney

Mark is joined in this episode of Drill to Detail by Wes McKinney, to talk about the origins of the Python Pandas open-source package for data analysis and his subsequent work as a contributor to the Kudu (incubating) and Parquet projects within the Apache Software Foundation and Arrow, an in-memory data structure specification for use by engineers building data systems and the de-facto standard for columnar in-memory processing and interchange.

• Python Data Analysis Library

• "Ibis on Impala: Python at Scale for Data Science"

• Drill To Detail Ep.3 'Apache Kudu And Cloudera's Analytic Platform' With Special Guest Mike Percy

• Apache Arrow homepage

• "Apache Arrow and the "10 Things I Hate About pandas"

• "Apache Arrow vs. Parquet and ORC: Do we really need a third Apache project for columnar data representation?"

• "Some comments to Daniel Abadi's blog about Apache Arrow"

• Wes McKinney homepage

Drill to Detail Ep.43 'Oracle Analytics, Data Visualization Desktop 4.0 and The Art of Product Management' with Special Guest Mike Durran

Mark is joined by Mike Durran from the Oracle Analytics Product Management team in this UKOUG Tech’17 special to talk about his route into product management via the Oracle Discoverer BI tool, Oracle’s latest product in this space Oracle Data Visualization Desktop 4 and its new features, and Mike’s upcoming sessions at the UK Oracle User Group’s Tech’17 event next week in Birmingham, UK.

• Oracle Data Visualization Desktop - Get Started

• UKOUG Tech'17 Conference Site

Drill to Detail Ep.42 'Evaluex, ML and Optimizing BigQuery & Athena' With Special Guest Avi Zloof

Mark is joined in this episode by Avi Zloof from Evaluex to talk about the new world of elastically-provisioned cloud-hosted analytic databases such as Google BigQuery and Amazon Athena, how their pricing model and vendor strategy differs from the traditional database vendors, and how machine learning can be used to automate performance tuning and optimize workloads in this new world of large-scale distributed query and storage. 

• SuperQuery - Free visualization tool for Google BigQuery

• SuperQuery Chrome Plugin

• Drill to Detail Ep.12 'Gluent and the New World of Hybrid Data' with Special Guest Tanel Poder

• BQQuery Mate Chrome Plugin

Drill to Detail Ep.41 'Developing with Google BigQuery and Google Cloud Platform' With Special Guest Felipe Hoffa

Mark is joined in this episode by Google Cloud Platform Developer Advocate Felipe Hoffa, talking about getting started as a developer using Google BigQuery along with Google Cloud Dataflow, Google Cloud Dataprep and Google Cloud Platform's machine learning APIs.

• Reddit BigQuery Forum

• Felipe Hoffa on Stack Overflow

• Felipe Hoffa on Medium

• Google Cloud Dataprep

• "How to aggregate data for BigQuery using Apache Airflow"

• Google Cloud Platform Github Repo

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"