Hands-On Data Warehousing with Azure Data Factory: ETL techniques to load and transform data from various sources, both on-premises and on cloud - Brossura

Coté, Christian; Gutzait, Michelle

Brossura

ISBN 10: 1789137624 ISBN 13: 9781789137620

Casa editrice: Packt Publishing, 2018

Riassunto

Build hybrid data solutions with the power of Microsoft Azure Data Factory v2

Key Features

• Combine the power of Azure Data Factory v2 and SQL Server Integration Services
• Enhance the performance and scalability of a modern ETL hybrid solution
• Use Power BI to interact with the data loaded in data warehouse and data lake

Book Description

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.

What you will learn

• Understand the key components of an ETL solution using Azure Data Factory and Integration Services
• Set up, use, and interact with Azure Artifacts from an SSIS 2017 perspective
• Design the architecture of a modern ETL hybrid solution
• Implement ETL solutions using Integration Services for both on-premises and Azure data
• Improve the performance and scalability of your ETL solution
• Explore the new capabilities and features added to Azure Data Factory and Integration Services

Who This Book Is For

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.

Table of Contents

1. Azure Data Factory
2. Getting Started with Our First Data Factory
3. ADF and SSIS in PaaS
4. Azure Data Lake
5. Machine Learning on the Cloud
6. Sparks with Databrick
7. Power BI reports

Su questo libro

L'autore

Christian Coté has been in IT for more than 12 years. He is an MS-certified technical specialist in business intelligence (MCTS-BI). For about 10 years, he has been a consultant in ETL/BI projects. His ETL projects have used various ETL tools and plain code with various RDBMSes (such as Oracle and SQL Server). He is currently working on his sixth SSIS implementation in 4 years.

Michelle Gutzait has been in IT for 30 years as a developer, business analyst, and database consultant. She has worked with MS SQL Server for 20 years. Her skills include infrastructure and database design, performance tuning, security, HADR solutions, consolidation, very large databases, replication, T-SQL coding and optimization, SSIS, SSRS, SSAS, admin and infrastructure tools development, cloud services, training developers, DBAs, and more. She has been an Oracle developer, business analyst, and development team lead.

Giuseppe Ciaburro holds a PhD in environmental technical physics and two master's degrees. His research is on machine learning applications in the study of urban sound environments. He works at Built Environment Control Laboratory, Università degli Studi della Campania Luigi Vanvitelli (Italy). He has over 15 years' experience in programming Python, R, and MATLAB, first in the field of combustion, and then in acoustics and noise control. He has several publications to his credit.

Dettagli dell?edizione

• Editore: Packt Publishing
• Data di pubblicazione: 2018
• ISBN 10: 1789137624
• ISBN 13: 9781789137620
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 284