Book Image

Cloud Analytics with Microsoft Azure - Second Edition

By : Has Altaiar, Jack Lee, Michael Peña
Book Image

Cloud Analytics with Microsoft Azure - Second Edition

By: Has Altaiar, Jack Lee, Michael Peña

Overview of this book

Cloud Analytics with Microsoft Azure serves as a comprehensive guide for big data analysis and processing using a range of Microsoft Azure features. This book covers everything you need to build your own data warehouse and learn numerous techniques to gain useful insights by analyzing big data. The book begins by introducing you to the power of data with big data analytics, the Internet of Things (IoT), machine learning, artificial intelligence, and DataOps. You will learn about cloud-scale analytics and the services Microsoft Azure offers to empower businesses to discover insights. You will also be introduced to the new features and functionalities added to the modern data warehouse. Finally, you will look at two real-world business use cases to demonstrate high-level solutions using Microsoft Azure. The aim of these use cases will be to illustrate how real-time data can be analyzed in Azure to derive meaningful insights and make business decisions. You will learn to build an end-to-end analytics pipeline on the cloud with machine learning and deep learning concepts. By the end of this book, you will be proficient in analyzing large amounts of data with Azure and using it effectively to benefit your organization.
Table of Contents (7 chapters)

2. Introducing the Azure Synapse Analytics workspace and Synapse Studio

In the previous chapter, we introduced you to Azure and the types of platforms, tools, and resources that Azure provides to facilitate the creation of data warehouse solutions.

In this chapter, we will focus on the new unified experience in the Azure Synapse Analytics workspace and Synapse Studio. We will cover the following topics:

  • Azure Synapse Analytics and why we need it
  • Deep dive into Azure Synapse Analytics
  • Introduction to the Azure Synapse Analytics workspace and a step-by-step quick start guide
  • Introduction to Synapse Studio
  • Two ways of launching Synapse Studio
  • Provisioning an SQL pool, ingesting data, and analyzing the data in the SQL pool
  • Creating an Apache Spark pool, ingesting data, and exploring data using Spark
  • Copying data to/from SQL pools and Spark pools
  • Linked data sources
  • Analyzing data using serverless SQL pools
  • Integrating with pipelines...