فهرست مطالب

• 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