Analytics Engineering with SQL and Dbt: Building Meaningful Data Models at Scale

Machado, Rui, Russa, Helder

  • 出版商: O'Reilly
  • 出版日期: 2024-01-16
  • 定價: $2,310
  • 售價: 9.5$2,195
  • 貴賓價: 8.8$2,033
  • 語言: 英文
  • 頁數: 321
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1098142381
  • ISBN-13: 9781098142384
  • 相關分類: SQL
  • 立即出貨 (庫存=1)


With the shift from data warehouses to data lakes, data now lands in repositories before it's been transformed, enabling engineers to model raw data into clean, well-defined datasets. DBT (data build tool) helps you take data further. This practical book shows data analysts, data engineers, BI developers, and data scientists how to create a true self-service transformation platform through the use of dynamic SQL.

Authors Rui Machado from Monstarlab and Helder Russa from Jumia show you how to quickly deliver new data products by focusing more on value delivery and less on architectural and engineering aspects. If you know your business well and have the technical skills to model raw data into clean, well-defined datasets, you'll learn how to design and deliver data models without any technical influence.

With this book, you'll learn:

  • What DBT is and how a DBT project is structured
  • How DBT fits into the data engineering and analytics worlds
  • How to collaborate on building data models
  • The main tools and architectures for building useful, functional data models
  • How to fit DBT into data warehousing and laking architecture
  • How to build tests for data transformations



作者Rui Machado來自Monstarlab,Helder Russa來自Jumia,他們向您展示如何通過更多關注價值交付而少關注架構和工程方面,快速交付新的數據產品。如果您對業務非常了解並具備將原始資料建模為乾淨、明確的資料集的技術能力,您將學習如何在沒有任何技術影響的情況下設計和交付數據模型。

- DBT是什麼以及DBT項目的結構
- DBT如何適用於數據工程和分析領域
- 如何協作建立數據模型
- 建立有用、功能性數據模型的主要工具和架構
- 如何將DBT融入資料倉儲和資料湖架構
- 如何為數據轉換建立測試