DrupalCon Seattle 2019: Drupal as a Data Warehouse: Everybody Into the Data Lake!

This talk explores the complexities of building reports in Drupal, addressing both the strengths and limitations of using Views for report generation. The speaker discusses the challenges faced when dealing with custom report requests and MySQL load issues, presenting a data warehouse as a more efficient solution for generating reports. Attendees will learn about the process of denormalizing Drupal data, the necessary tools for extracting, transforming, and loading (ETL), and various options for data warehousing. Additionally, the session covers how customers can access data from the warehouse and the process for selecting and integrating business intelligence software into Drupal, highlighting the potential for improved customer satisfaction and value creation.