Error loading page.
Try refreshing the page. If that doesn't work, there may be a network issue, and you can use our self test page to see what's preventing the page from loading.
Learn more about possible network issues or contact support for more help.

Analytics Engineering with SQL and dbt

ebook

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 Hélder 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

  • Expand title description text
    Publisher: O'Reilly Media

    Kindle Book

    • Release date: December 8, 2023

    OverDrive Read

    • ISBN: 9781098142346
    • Release date: December 8, 2023

    EPUB ebook

    • ISBN: 9781098142346
    • File size: 9259 KB
    • Release date: December 8, 2023

    Formats

    Kindle Book
    OverDrive Read
    EPUB ebook

    Languages

    English

    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 Hélder 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

  • Expand title description text