Analytics Engineering with SQL and dbt
Data Science
Book Details
Book Title
Analytics Engineering with SQL and dbt: Building Meaningful Data Models at Scale
Author
Rui Machado, Helder Russa
Publisher
O'Reilly Media
Publication Date
2023
ISBN
9781098142384
Number of Pages
324
Language
English
Format
File Size
2.88MB
Subject
Computers > Databases
Table of Contents
- Contents
- Cover
- Copyright
- Table of Contents
- Preface
- Chapter 1. Analytics Engineering
- Databases and Their Impact on Analytics Engineering
- Cloud Computing and Its Impact on Analytics Engineering
- The Data Analytics Lifecycle
- The New Role of Analytics Engineer
- Responsibilities of an Analytics Engineer
- Enabling Analytics in a Data Mesh
- The Heart of Analytics Engineering
- The Legacy Processes
- The dbt Revolution
- Summary
- Chapter 2. Data Modeling for Analytics
- A Brief on Data Modeling
- Dimensional Data Modeling
- Monolith Data Modeling
- Building Modular Data Models
- Medallion Architecture Pattern
- Summary
- Chapter 3. SQL for Analytics
- The Resiliency of SQL
- Database Fundamentals
- Creating and Managing Your Data Structures with DDL
- Manipulating Data with DML
- Storing Queries as Views
- Common Table Expressions
- Window Functions
- SQL for Distributed Data Processing
- Bonus: Training Machine Learning Models with SQL
- Summary
- Chapter 4. Data Transformation with dbt
- dbt Design Philosophy
- dbt Data Flow
- dbt Cloud
- Structure of a dbt Project
- Summary
- Chapter 5. dbt Advanced Topics
- Model Materializations
- Dynamic SQL with Jinja
- Using SQL Macros
- dbt Packages
- dbt Semantic Layer
- Summary
- Chapter 6. Building an End-to-End Analytics Engineering Use Case
- Problem Definition: An Omnichannel Analytics Case
- Operational Data Modeling
- High-Level Data Architecture
- Analytical Data Modeling
- Creating Our Data Warehouse with dbt
- Tests, Documentation, and Deployment with dbt
- Data Analytics with SQL
- Conclusion
- Index
- About the Authors
- Colophon