Hands-On Data Warehousing with Azure Data Factory

Build hybrid data solutions with the power of Microsoft Azure Data Factory v2 ETL (Extract, Transform, and Load) is an essential technique for data processing. Given that data is everywhere and ever increasing, ETL will always be a vital process for handling data from different sources. Hands-On Data Warehousing with Azure Data Factory starts by covering the basic concepts of data warehousing and the ETL process. You'll learn how Azure Data Factory (ADF) and SQL Server Integration Services (SSIS) can be used to understand the key components of an ETL solution. The book will then take you through different Azure services that can be used by ADF and SSIS, such as Azure Data Lake Analytics, machine learning, and Databrick's Spark with the help of practical examples. Furthermore, you'll explore how to design and implement ETL hybrid solutions using a variety of Integration Services. Finally, you'll use Power BI to interact with data coming from multiple sources to reveal valuable insights. By the end of this book, you'll have learned how to build your own ETL solutions and address the key challenges in the process. This book is for you if you are a software professional who develops and implements ETL solutions using Microsoft SQL Server or Azure cloud. You'll also find this book helpful if you're a software engineer, DW/ETL architect, or ETL developer who wants to create a new ETL implementation or enhance an existing one with ADF or SSIS.