Data Engineering With Databricks Cookbook
DOWNLOAD
Download Data Engineering With Databricks Cookbook PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get Data Engineering With Databricks Cookbook book now. This website allows unlimited access to, at the time of writing, more than 1.5 million titles, including hundreds of thousands of titles in various foreign languages. If the content not found or just blank you must refresh this page
Data Engineering With Databricks Cookbook
DOWNLOAD
Author : Pulkit Chadha
language : en
Publisher: Packt Publishing Ltd
Release Date : 2024-05-31
Data Engineering With Databricks Cookbook written by Pulkit Chadha and has been published by Packt Publishing Ltd this book supported file pdf, txt, epub, kindle and other format this book has been release on 2024-05-31 with Computers categories.
Work through 70 recipes for implementing reliable data pipelines with Apache Spark, optimally store and process structured and unstructured data in Delta Lake, and use Databricks to orchestrate and govern your data Key Features Learn data ingestion, data transformation, and data management techniques using Apache Spark and Delta Lake Gain practical guidance on using Delta Lake tables and orchestrating data pipelines Implement reliable DataOps and DevOps practices, and enforce data governance policies on Databricks Purchase of the print or Kindle book includes a free PDF eBook Book DescriptionData Engineering with Databricks Cookbook will guide you through recipes to effectively use Apache Spark, Delta Lake, and Databricks for data engineering, beginning with an introduction to data ingestion and loading with Apache Spark. As you progress, you’ll be introduced to various data manipulation and data transformation solutions that can be applied to data. You'll find out how to manage and optimize Delta tables, as well as how to ingest and process streaming data. The book will also show you how to improve the performance problems of Apache Spark apps and Delta Lake. Later chapters will show you how to use Databricks to implement DataOps and DevOps practices and teach you how to orchestrate and schedule data pipelines using Databricks Workflows. Finally, you’ll understand how to set up and configure Unity Catalog for data governance. By the end of this book, you’ll be well-versed in building reliable and scalable data pipelines using modern data engineering technologies.What you will learn Perform data loading, ingestion, and processing with Apache Spark Discover data transformation techniques and custom user-defined functions (UDFs) in Apache Spark Manage and optimize Delta tables with Apache Spark and Delta Lake APIs Use Spark Structured Streaming for real-time data processing Optimize Apache Spark application and Delta table query performance Implement DataOps and DevOps practices on Databricks Orchestrate data pipelines with Delta Live Tables and Databricks Workflows Implement data governance policies with Unity Catalog Who this book is for This book is for data engineers, data scientists, and data practitioners who want to learn how to build efficient and scalable data pipelines using Apache Spark, Delta Lake, and Databricks. To get the most out of this book, you should have basic knowledge of data architecture, SQL, and Python programming.
Azure Databricks Cookbook
DOWNLOAD
Author : Phani Raj
language : en
Publisher: Packt Publishing Ltd
Release Date : 2021-09-17
Azure Databricks Cookbook written by Phani Raj and has been published by Packt Publishing Ltd this book supported file pdf, txt, epub, kindle and other format this book has been release on 2021-09-17 with Computers categories.
Get to grips with building and productionizing end-to-end big data solutions in Azure and learn best practices for working with large datasets Key FeaturesIntegrate with Azure Synapse Analytics, Cosmos DB, and Azure HDInsight Kafka Cluster to scale and analyze your projects and build pipelinesUse Databricks SQL to run ad hoc queries on your data lake and create dashboardsProductionize a solution using CI/CD for deploying notebooks and Azure Databricks Service to various environmentsBook Description Azure Databricks is a unified collaborative platform for performing scalable analytics in an interactive environment. The Azure Databricks Cookbook provides recipes to get hands-on with the analytics process, including ingesting data from various batch and streaming sources and building a modern data warehouse. The book starts by teaching you how to create an Azure Databricks instance within the Azure portal, Azure CLI, and ARM templates. You'll work through clusters in Databricks and explore recipes for ingesting data from sources, including files, databases, and streaming sources such as Apache Kafka and EventHub. The book will help you explore all the features supported by Azure Databricks for building powerful end-to-end data pipelines. You'll also find out how to build a modern data warehouse by using Delta tables and Azure Synapse Analytics. Later, you'll learn how to write ad hoc queries and extract meaningful insights from the data lake by creating visualizations and dashboards with Databricks SQL. Finally, you'll deploy and productionize a data pipeline as well as deploy notebooks and Azure Databricks service using continuous integration and continuous delivery (CI/CD). By the end of this Azure book, you'll be able to use Azure Databricks to streamline different processes involved in building data-driven apps. What you will learnRead and write data from and to various Azure resources and file formatsBuild a modern data warehouse with Delta Tables and Azure Synapse AnalyticsExplore jobs, stages, and tasks and see how Spark lazy evaluation worksHandle concurrent transactions and learn performance optimization in Delta tablesLearn Databricks SQL and create real-time dashboards in Databricks SQLIntegrate Azure DevOps for version control, deploying, and productionizing solutions with CI/CD pipelinesDiscover how to use RBAC and ACLs to restrict data accessBuild end-to-end data processing pipeline for near real-time data analyticsWho this book is for This recipe-based book is for data scientists, data engineers, big data professionals, and machine learning engineers who want to perform data analytics on their applications. Prior experience of working with Apache Spark and Azure is necessary to get the most out of this book.
Azure Data Engineering Cookbook
DOWNLOAD
Author : Nagaraj Venkatesan
language : en
Publisher: Packt Publishing Ltd
Release Date : 2022-09-26
Azure Data Engineering Cookbook written by Nagaraj Venkatesan and has been published by Packt Publishing Ltd this book supported file pdf, txt, epub, kindle and other format this book has been release on 2022-09-26 with Computers categories.
Nearly 80 recipes to help you collect and transform data from multiple sources into a single data source, making it way easier to perform analytics on the data Key FeaturesBuild data pipelines from scratch and find solutions to common data engineering problemsLearn how to work with Azure Data Factory, Data Lake, Databricks, and Synapse AnalyticsMonitor and maintain your data engineering pipelines using Log Analytics, Azure Monitor, and Azure PurviewBook Description The famous quote 'Data is the new oil' seems more true every day as the key to most organizations' long-term success lies in extracting insights from raw data. One of the major challenges organizations face in leveraging value out of data is building performant data engineering pipelines for data visualization, ingestion, storage, and processing. This second edition of the immensely successful book by Ahmad Osama brings to you several recent enhancements in Azure data engineering and shares approximately 80 useful recipes covering common scenarios in building data engineering pipelines in Microsoft Azure. You'll explore recipes from Azure Synapse Analytics workspaces Gen 2 and get to grips with Synapse Spark pools, SQL Serverless pools, Synapse integration pipelines, and Synapse data flows. You'll also understand Synapse SQL Pool optimization techniques in this second edition. Besides Synapse enhancements, you'll discover helpful tips on managing Azure SQL Database and learn about security, high availability, and performance monitoring. Finally, the book takes you through overall data engineering pipeline management, focusing on monitoring using Log Analytics and tracking data lineage using Azure Purview. By the end of this book, you'll be able to build superior data engineering pipelines along with having an invaluable go-to guide. What you will learnProcess data using Azure Databricks and Azure Synapse AnalyticsPerform data transformation using Azure Synapse data flowsPerform common administrative tasks in Azure SQL DatabaseBuild effective Synapse SQL pools which can be consumed by Power BIMonitor Synapse SQL and Spark pools using Log AnalyticsTrack data lineage using Microsoft Purview integration with pipelinesWho this book is for This book is for data engineers, data architects, database administrators, and data professionals who want to get well versed with the Azure data services for building data pipelines. Basic understanding of cloud and data engineering concepts will help in getting the most out of this book.
Azure Data Engineering Cookbook
DOWNLOAD
Author : Ahmad Osama
language : en
Publisher: Packt Publishing Ltd
Release Date : 2021-04-05
Azure Data Engineering Cookbook written by Ahmad Osama and has been published by Packt Publishing Ltd this book supported file pdf, txt, epub, kindle and other format this book has been release on 2021-04-05 with Computers categories.
Over 90 recipes to help you orchestrate modern ETL/ELT workflows and perform analytics using Azure services more easily Key FeaturesBuild highly efficient ETL pipelines using the Microsoft Azure Data servicesCreate and execute real-time processing solutions using Azure Databricks, Azure Stream Analytics, and Azure Data ExplorerDesign and execute batch processing solutions using Azure Data FactoryBook Description Data engineering is one of the faster growing job areas as Data Engineers are the ones who ensure that the data is extracted, provisioned and the data is of the highest quality for data analysis. This book uses various Azure services to implement and maintain infrastructure to extract data from multiple sources, and then transform and load it for data analysis. It takes you through different techniques for performing big data engineering using Microsoft Azure Data services. It begins by showing you how Azure Blob storage can be used for storing large amounts of unstructured data and how to use it for orchestrating a data workflow. You'll then work with different Cosmos DB APIs and Azure SQL Database. Moving on, you'll discover how to provision an Azure Synapse database and find out how to ingest and analyze data in Azure Synapse. As you advance, you'll cover the design and implementation of batch processing solutions using Azure Data Factory, and understand how to manage, maintain, and secure Azure Data Factory pipelines. You'll also design and implement batch processing solutions using Azure Databricks and then manage and secure Azure Databricks clusters and jobs. In the concluding chapters, you'll learn how to process streaming data using Azure Stream Analytics and Data Explorer. By the end of this Azure book, you'll have gained the knowledge you need to be able to orchestrate batch and real-time ETL workflows in Microsoft Azure. What you will learnUse Azure Blob storage for storing large amounts of unstructured dataPerform CRUD operations on the Cosmos Table APIImplement elastic pools and business continuity with Azure SQL DatabaseIngest and analyze data using Azure Synapse AnalyticsDevelop Data Factory data flows to extract data from multiple sourcesManage, maintain, and secure Azure Data Factory pipelinesProcess streaming data using Azure Stream Analytics and Data ExplorerWho this book is for This book is for Data Engineers, Database administrators, Database developers, and extract, load, transform (ETL) developers looking to build expertise in Azure Data engineering using a recipe-based approach. Technical architects and database architects with experience in designing data or ETL applications either on-premise or on any other cloud vendor who wants to learn Azure Data engineering concepts will also find this book useful. Prior knowledge of Azure fundamentals and data engineering concepts is needed.
Databricks Lakehouse Platform Cookbook
DOWNLOAD
Author : Dr. Alan L. Dennis
language : en
Publisher: BPB Publications
Release Date : 2023-12-18
Databricks Lakehouse Platform Cookbook written by Dr. Alan L. Dennis and has been published by BPB Publications this book supported file pdf, txt, epub, kindle and other format this book has been release on 2023-12-18 with Computers categories.
Analyze, Architect, and Innovate with Databricks Lakehouse KEY FEATURES ● Create a Lakehouse using Databricks, including ingestion from source to Bronze. ● Refinement of Bronze items to business-ready Silver items using incremental methods. ● Construct Gold items to service the needs of various business requirements. DESCRIPTION The Databricks Lakehouse is groundbreaking technology that simplifies data storage, processing, and analysis. This cookbook offers a clear and practical guide to building and optimizing your Lakehouse to make data-driven decisions and drive impactful results. This definitive guide walks you through the entire Lakehouse journey, from setting up your environment, and connecting to storage, to creating Delta tables, building data models, and ingesting and transforming data. We start off by discussing how to ingest data to Bronze, then refine it to produce Silver. Next, we discuss how to create Gold tables and various data modeling techniques often performed in the Gold layer. You will learn how to leverage Spark SQL and PySpark for efficient data manipulation, apply Delta Live Tables for real-time data processing, and implement Machine Learning and Data Science workflows with MLflow, Feature Store, and AutoML. The book also delves into advanced topics like graph analysis, data governance, and visualization, equipping you with the necessary knowledge to solve complex data challenges. By the end of this cookbook, you will be a confident Lakehouse expert, capable of designing, building, and managing robust data-driven solutions. WHAT YOU WILL LEARN ● Design and build a robust Databricks Lakehouse environment. ● Create and manage Delta tables with advanced transformations. ● Analyze and transform data using SQL and Python. ● Build and deploy machine learning models for actionable insights. ● Implement best practices for data governance and security. WHO THIS BOOK IS FOR This book is meant for Data Engineers, Data Analysts, Data Scientists, Business intelligence professionals, and Architects who want to go to the next level of Data Engineering using the Databricks platform to construct Lakehouses. TABLE OF CONTENTS 1. Introduction to Databricks Lakehouse 2. Setting Up a Databricks Workspace 3. Connecting to Storage 4. Creating Delta Tables 5. Data Profiling and Modeling in the Lakehouse 6. Extracting from Source and Loading to Bronze 7. Transforming to Create Silver 8. Transforming to Create Gold for Business Purposes 9. Machine Learning and Data Science 10. SQL Analysis 11. Graph Analysis 12. Visualizations 13. Governance 14. Operations 15. Tips, Tricks, Troubleshooting, and Best Practices
Data Engineering With Apache Spark Delta Lake And Lakehouse
DOWNLOAD
Author : Manoj Kukreja
language : en
Publisher: Packt Publishing Ltd
Release Date : 2021-10-22
Data Engineering With Apache Spark Delta Lake And Lakehouse written by Manoj Kukreja and has been published by Packt Publishing Ltd this book supported file pdf, txt, epub, kindle and other format this book has been release on 2021-10-22 with Computers categories.
Understand the complexities of modern-day data engineering platforms and explore strategies to deal with them with the help of use case scenarios led by an industry expert in big data Key FeaturesBecome well-versed with the core concepts of Apache Spark and Delta Lake for building data platformsLearn how to ingest, process, and analyze data that can be later used for training machine learning modelsUnderstand how to operationalize data models in production using curated dataBook Description In the world of ever-changing data and schemas, it is important to build data pipelines that can auto-adjust to changes. This book will help you build scalable data platforms that managers, data scientists, and data analysts can rely on. Starting with an introduction to data engineering, along with its key concepts and architectures, this book will show you how to use Microsoft Azure Cloud services effectively for data engineering. You'll cover data lake design patterns and the different stages through which the data needs to flow in a typical data lake. Once you've explored the main features of Delta Lake to build data lakes with fast performance and governance in mind, you'll advance to implementing the lambda architecture using Delta Lake. Packed with practical examples and code snippets, this book takes you through real-world examples based on production scenarios faced by the author in his 10 years of experience working with big data. Finally, you'll cover data lake deployment strategies that play an important role in provisioning the cloud resources and deploying the data pipelines in a repeatable and continuous way. By the end of this data engineering book, you'll know how to effectively deal with ever-changing data and create scalable data pipelines to streamline data science, ML, and artificial intelligence (AI) tasks. What you will learnDiscover the challenges you may face in the data engineering worldAdd ACID transactions to Apache Spark using Delta LakeUnderstand effective design strategies to build enterprise-grade data lakesExplore architectural and design patterns for building efficient data ingestion pipelinesOrchestrate a data pipeline for preprocessing data using Apache Spark and Delta Lake APIsAutomate deployment and monitoring of data pipelines in productionGet to grips with securing, monitoring, and managing data pipelines models efficientlyWho this book is for This book is for aspiring data engineers and data analysts who are new to the world of data engineering and are looking for a practical guide to building scalable data platforms. If you already work with PySpark and want to use Delta Lake for data engineering, you'll find this book useful. Basic knowledge of Python, Spark, and SQL is expected.
Ultimate Data Engineering With Databricks
DOWNLOAD
Author : Mayank Malhotra
language : en
Publisher: Orange Education Pvt Ltd
Release Date : 2024-02-14
Ultimate Data Engineering With Databricks written by Mayank Malhotra and has been published by Orange Education Pvt Ltd this book supported file pdf, txt, epub, kindle and other format this book has been release on 2024-02-14 with Computers categories.
Navigating Databricks with Ease for Unparalleled Data Engineering Insights. KEY FEATURES ● Navigate Databricks with a seamless progression from fundamental principles to advanced engineering techniques. ● Gain hands-on experience with real-world examples, ensuring immediate relevance and practicality. ● Discover expert insights and best practices for refining your data engineering skills and achieving superior results with Databricks. DESCRIPTION Ultimate Data Engineering with Databricks is a comprehensive handbook meticulously designed for professionals aiming to enhance their data engineering skills through Databricks. Bridging the gap between foundational and advanced knowledge, this book employs a step-by-step approach with detailed explanations suitable for beginners and experienced practitioners alike. Focused on practical applications, the book employs real-world examples and scenarios to teach how to construct, optimize, and maintain robust data pipelines. Emphasizing immediate applicability, it equips readers to address real data challenges using Databricks effectively. The goal is not just understanding Databricks but mastering it to offer tangible solutions. Beyond technical skills, the book imparts best practices and expert tips derived from industry experience, aiding readers in avoiding common pitfalls and adopting strategies for optimal data engineering solutions. This book will help you develop the skills needed to make impactful contributions to organizations, enhancing your value as data engineering professionals in today's competitive job market. WHAT WILL YOU LEARN ● Acquire proficiency in Databricks fundamentals, enabling the construction of efficient data pipelines. ● Design and implement high-performance data solutions for scalability. ● Apply essential best practices for ensuring data integrity in pipelines. ● Explore advanced Databricks features for tackling complex data tasks. ● Learn to optimize data pipelines for streamlined workflows. WHO IS THIS BOOK FOR? This book caters to a diverse audience, including data engineers, data architects, BI analysts, data scientists and technology enthusiasts. Suitable for both professionals and students, the book appeals to those eager to master Databricks and stay at the forefront of data engineering trends. A basic understanding of data engineering concepts and familiarity with cloud computing will enhance the learning experience. TABLE OF CONTENTS 1. Fundamentals of Data Engineering 2. Mastering Delta Tables in Databricks 3. Data Ingestion and Extraction 4. Data Transformation and ETL Processes 5. Data Quality and Validation 6. Data Modeling and Storage 7. Data Orchestration and Workflow Management 8. Performance Tuning and Optimization 9. Scalability and Deployment Considerations 10. Data Security and Governance Last Words Index
Azure Data Factory Cookbook
DOWNLOAD
Author : Dmitry Anoshin
language : en
Publisher: Packt Publishing Ltd
Release Date : 2020-12-24
Azure Data Factory Cookbook written by Dmitry Anoshin and has been published by Packt Publishing Ltd this book supported file pdf, txt, epub, kindle and other format this book has been release on 2020-12-24 with Computers categories.
Solve real-world data problems and create data-driven workflows for easy data movement and processing at scale with Azure Data Factory Key FeaturesLearn how to load and transform data from various sources, both on-premises and on cloudUse Azure Data Factory’s visual environment to build and manage hybrid ETL pipelinesDiscover how to prepare, transform, process, and enrich data to generate key insightsBook Description Azure Data Factory (ADF) is a modern data integration tool available on Microsoft Azure. This Azure Data Factory Cookbook helps you get up and running by showing you how to create and execute your first job in ADF. You’ll learn how to branch and chain activities, create custom activities, and schedule pipelines. This book will help you to discover the benefits of cloud data warehousing, Azure Synapse Analytics, and Azure Data Lake Gen2 Storage, which are frequently used for big data analytics. With practical recipes, you’ll learn how to actively engage with analytical tools from Azure Data Services and leverage your on-premise infrastructure with cloud-native tools to get relevant business insights. As you advance, you’ll be able to integrate the most commonly used Azure Services into ADF and understand how Azure services can be useful in designing ETL pipelines. The book will take you through the common errors that you may encounter while working with ADF and show you how to use the Azure portal to monitor pipelines. You’ll also understand error messages and resolve problems in connectors and data flows with the debugging capabilities of ADF. By the end of this book, you’ll be able to use ADF as the main ETL and orchestration tool for your data warehouse or data platform projects. What you will learnCreate an orchestration and transformation job in ADFDevelop, execute, and monitor data flows using Azure SynapseCreate big data pipelines using Azure Data Lake and ADFBuild a machine learning app with Apache Spark and ADFMigrate on-premises SSIS jobs to ADFIntegrate ADF with commonly used Azure services such as Azure ML, Azure Logic Apps, and Azure FunctionsRun big data compute jobs within HDInsight and Azure DatabricksCopy data from AWS S3 and Google Cloud Storage to Azure Storage using ADF's built-in connectorsWho this book is for This book is for ETL developers, data warehouse and ETL architects, software professionals, and anyone who wants to learn about the common and not-so-common challenges faced while developing traditional and hybrid ETL solutions using Microsoft's Azure Data Factory. You’ll also find this book useful if you are looking for recipes to improve or enhance your existing ETL pipelines. Basic knowledge of data warehousing is expected.
Pyspark Cookbook
DOWNLOAD
Author : Tomasz Drabas
language : en
Publisher: Packt Publishing
Release Date : 2018-06-29
Pyspark Cookbook written by Tomasz Drabas and has been published by Packt Publishing this book supported file pdf, txt, epub, kindle and other format this book has been release on 2018-06-29 with Computers categories.
Combine the power of Apache Spark and Python to build effective big data applications Key Features Perform effective data processing, machine learning, and analytics using PySpark Overcome challenges in developing and deploying Spark solutions using Python Explore recipes for efficiently combining Python and Apache Spark to process data Book Description Apache Spark is an open source framework for efficient cluster computing with a strong interface for data parallelism and fault tolerance. The PySpark Cookbook presents effective and time-saving recipes for leveraging the power of Python and putting it to use in the Spark ecosystem. You'll start by learning the Apache Spark architecture and how to set up a Python environment for Spark. You'll then get familiar with the modules available in PySpark and start using them effortlessly. In addition to this, you'll discover how to abstract data with RDDs and DataFrames, and understand the streaming capabilities of PySpark. You'll then move on to using ML and MLlib in order to solve any problems related to the machine learning capabilities of PySpark and use GraphFrames to solve graph-processing problems. Finally, you will explore how to deploy your applications to the cloud using the spark-submit command. By the end of this book, you will be able to use the Python API for Apache Spark to solve any problems associated with building data-intensive applications. What you will learn Configure a local instance of PySpark in a virtual environment Install and configure Jupyter in local and multi-node environments Create DataFrames from JSON and a dictionary using pyspark.sql Explore regression and clustering models available in the ML module Use DataFrames to transform data used for modeling Connect to PubNub and perform aggregations on streams Who this book is for The PySpark Cookbook is for you if you are a Python developer looking for hands-on recipes for using the Apache Spark 2.x ecosystem in the best possible way. A thorough understanding of Python (and some familiarity with Spark) will help you get the best out of the book.
Azure Data Factory Cookbook
DOWNLOAD
Author : Dmitry Foshin
language : en
Publisher: Packt Publishing Ltd
Release Date : 2024-02-28
Azure Data Factory Cookbook written by Dmitry Foshin and has been published by Packt Publishing Ltd this book supported file pdf, txt, epub, kindle and other format this book has been release on 2024-02-28 with Computers categories.
Data Engineers guide to solve real-world problems encountered while building and transforming data pipelines using Azure's data integration tool Key Features Solve real-world data problems and create data-driven workflows with ease using Azure Data Factory Build an ADF pipeline that operates on pre-built ML model and Azure AI Get up and running with Fabric Data Explorer and extend ADF with Logic Apps and Azure functions Book DescriptionThis new edition of the Azure Data Factory book, fully updated to reflect ADS V2, will help you get up and running by showing you how to create and execute your first job in ADF. There are updated and new recipes throughout the book based on developments happening in Azure Synapse, Deployment with Azure DevOps, and Azure Purview. The current edition also runs you through Fabric Data Factory, Data Explorer, and some industry-grade best practices with specific chapters on each. You’ll learn how to branch and chain activities, create custom activities, and schedule pipelines, as well as discover the benefits of cloud data warehousing, Azure Synapse Analytics, and Azure Data Lake Gen2 Storage. With practical recipes, you’ll learn how to actively engage with analytical tools from Azure Data Services and leverage your on-premises infrastructure with cloud-native tools to get relevant business insights. You'll familiarize yourself with the common errors that you may encounter while working with ADF and find out the solutions to them. You’ll also understand error messages and resolve problems in connectors and data flows with the debugging capabilities of ADF. By the end of this book, you’ll be able to use ADF with its latest advancements as the main ETL and orchestration tool for your data warehouse projects.What you will learn Build and Manage data pipelines with ease using the latest version of ADF Configure, load data, and operate data flows with Azure Synapse Get up and running with Fabric Data Factory Working with Azure Data Factory and Azure Purview Create big data pipelines using Databricks and Delta tables Integrate ADF with commonly used Azure services such as Azure ML, Azure Logic Apps, and Azure Functions Learn industry-grade best practices for using Azure Data Factory Who this book is for This book is for ETL developers, data warehouse and ETL architects, software professionals, and anyone else who wants to learn about the common and not-so-common challenges faced while developing traditional and hybrid ETL solutions using Microsoft's Azure Data Factory. You’ll also find this book useful if you are looking for recipes to improve or enhance your existing ETL pipelines. Basic knowledge of data warehousing is a prerequisite.