Machado, Rui
Analytics Engineering with SQL and Dbt: Building Meaningful Data Models at Scale
- ISBN 13:
- 9781098142384
- author:
- Machado, Rui
- format:
- Paperback
- publisher:
- O'Reilly Media
- language:
- English
- Publication Year:
- 2023
- Pages:
- 321
- Dimensions:
- 23.3 x 17.8 x 1.7 centimetres (0
- Genre:
- Computers, Server & Database, General Database,
- Condition:
- New
- Availability:
- Item usually sent within 10 working days
Description
Building meaningful data models at scale requires a different approach to traditional data warehousing. With the shift to data lakes, raw data lands in repositories before it's been transformed, enabling engineers to model clean, well-defined datasets.
This practical guide shows data analysts, data engineers, BI developers, and data scientists how to create a self-service transformation platform using dynamic SQL. By focusing on value delivery rather than architectural and engineering aspects, you'll learn how to design and deliver data models without technical influence.
With this book, you'll discover how dbt fits into the data engineering and analytics worlds, collaborate on building data models, and build tests for data transformations. You'll also learn about main tools and architectures for building useful, functional data models and how to integrate dbt with data warehousing and laking architecture.