Fundamentals of Analytics Engineering. An introduction to building end-to-end analytics solutions Tychy

Navigate the world of data analytics with Fundamentals of Analytics Engineering—guiding you from foundational concepts to advanced techniques of data ingestion and warehousing, data lakehouse, and data modeling. Written by a team of 7 industry experts, this book helps you to transform raw data into structured insights.In this book, you’ll discover how to clean, filter, aggregate, and reformat data, and seamlessly serve it across diverse platforms. With practical guidance, you’ll also learn how to build a simple data platform using Airbyte for ingestion, DuckDB for warehousing, dbt for transformations, and Tableau for visualization. From data quality and observability to fostering collaboration on codebases, you’ll discover effective strategies for ensuring data integrity and driving collaborative success. As you advance, you'll become well-versed with the CI/CD principles for automated code building, testing, and deployment—laying the foundation for consistent and reliable pipelines. And with invaluable insights into gathering business requirements, documenting complex business logic, and the importance of data governance, you’ll develop a holistic understanding of the analytics lifecycle.By the end of this book, you’ll be armed with the essential techniques and best practices for developing scalable analytics solutions from end to end. Spis treści: 1. What is Analytics Engineering?2. The Modern Data Stack3. Data Ingestion4. Data Warehouses5. Data Modeling6. Data Transformation 7. Serving Data8. Hands-on: Building a Data Platform9. Data Quality & Observability 10. Writing Code in a Team11. Writing Robust Pipelines 12. Gathering Business Requirements13. Documenting Business Logic14. Data Governance