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)

Drill to Detail Ep.66 'ETL, Incorta and the Death of the Star Schema' with Matthew Halliday

Mark Rittman

Download

Drill to Detail Ep.65 'Bootstrapping, Growth Hacking and Supermetrics Data Pipelines for Digital Marketers' with Special Guest Mikael Thuneberg

Mark Rittman is joined by CEO and Founder of Supermetrics, Mikael Thuneberg, to tell the story of how a mention in the official Google Analytics Blog and a prize of a t-shirt led to him founding and bootstrapping what is now a €10M ARR marketing analytics business that’s probably the most important software vendor the Drill to Detail audience has never heard of, and who recently moved into the data pipelines-as-a-service market in collaboration with Google Cloud Platform and the Google BigQuery team.

• Announcing Supermetrics for BigQuery: Get a marketing data warehouse up and running in minutes (Supermetrics blog)

• Supermetrics, Google BigQuery and Data Pipelines for Digital Marketers (Rittman Analytics blog)

Drill to Detail Ep.65 'Bootstrapping, Growth Hacking and Marketing Pipelines' with Mikael Thuneberg

Mark Rittman

Download

Drill to Detail Ep.64 ‘Google BigQuery, BI Engine and the Future of Data Warehousing’ with Special Guest Jordan Tigani

Mark Rittman is joined in this episode by Jordan Tigani, Director of Product Management at Google for Google BigQuery, to talk about the history of BigQuery and its technology origins in Dremel; how BigQuery has evolved since its original release to handle a wide range of data warehouse workloads; and new features announced for BigQuery at Google Next’19 including BI Engine, Storage API, Connected Sheets and a range of new data connectors from Supermetrics and Fivetran.

• Modern Data Warehousing with BigQuery (Cloud Next '19)

• Modern data warehousing with BigQuery: a Q&A with Engineering Director Jordan Tigani

• Introduction to BigQuery BI Engine

• BigQuery Storage API Overview

• Supermetrics and Fivetran BigQuery connectors

• Drill to Detail Ep.2. 'Future of SQL on Hadoop', With Special Guest Dan McClary

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

Drill to Detail Ep.64 'BigQuery, BI Engine and the Future of Data Warehousing’ with Jordan Tigani

Mark Rittman

Download

Drill to Detail Ep.62 'Enterprise analytics, DW Modernization and the rediscovery of Data Governance' With Special Guest Mike Ferguson

Mark Rittman is joined in this episode by Mike Ferguson, long-term analyst, consultant and Managing Director of Intelligent Business Strategies to talk about data warehouse modernization, analytics and big data project success within enterprise customers and the re-emergence of interest in data governance and master data management within the industry.

• Intelligent Business Strategies homepage

• Mike Ferguson’s Blog

• Drill to Detail Ep.46 'Market Trends and Findings from the BI Survey 17' With Special Guest Dr. Carsten Bange

Drill to Detail Ep.62 'Enterprise Analytics, DW Modernization and the rediscovery of Data Governance

Mark Rittman

Drill to Detail Ep.58 'Candy Crush Saga, Analytics and Mobile Gaming' With Special Guest Jonathan Palmer

Mark Rittman is joined in this episode by Jonathan Palmer from King Games to talk about the role of analytics in the development of Candy Crush Saga and other King games, their use of Looker along with Google BigQuery and Exasol to provide analytics capabilities to their game designers and product owners and his approach to doing all of this in a fast-moving, technology-driven internet business.

• Candy Crush Saga article on Wikipedia

• King Games company website

• “How King Games is Crushing Games Data” DataIQ article

• Looker and King Games case study

• Jonathan Palmer on LinkedIn

Drill to Detail Ep.58 'Candy Crush Saga, Analytics and Mobile Gaming' With Special Guest Jon Palmer

Mark Rittman

Download