Book Image

Limitless Analytics with Azure Synapse

By : Prashant Kumar Mishra
Book Image

Limitless Analytics with Azure Synapse

By: Prashant Kumar Mishra

Overview of this book

Azure Synapse Analytics, which Microsoft describes as the next evolution of Azure SQL Data Warehouse, is a limitless analytics service that brings enterprise data warehousing and big data analytics together. With this book, you'll learn how to discover insights from your data effectively using this platform. The book starts with an overview of Azure Synapse Analytics, its architecture, and how it can be used to improve business intelligence and machine learning capabilities. Next, you'll go on to choose and set up the correct environment for your business problem. You'll also learn a variety of ways to ingest data from various sources and orchestrate the data using transformation techniques offered by Azure Synapse. Later, you'll explore how to handle both relational and non-relational data using the SQL language. As you progress, you'll perform real-time streaming and execute data analysis operations on your data using various languages, before going on to apply ML techniques to derive accurate and granular insights from data. Finally, you'll discover how to protect sensitive data in real time by using security and privacy features. By the end of this Azure book, you'll be able to build end-to-end analytics solutions while focusing on data prep, data management, data warehousing, and AI tasks.
Table of Contents (20 chapters)
Section 1: The Basics and Key Concepts
Section 2: Data Ingestion and Orchestration
Section 3: Azure Synapse for Data Scientists and Business Analysts
Section 4: Best Practices


In this chapter, we learned how to integrate Power BI with Azure Synapse. Azure Synapse has made it really convenient to keep data, analysis, and visualizations together. Now, we do not need to go to the Power BI tool to generate a report using Synapse data.

Aside from a dedicated SQL pool, Synapse also enables us to create reports by using serverless SQL pool data as well. Thus, by using Azure Synapse, we can read the data directly from Azure Data Lake Gen2, create a view on top of that data, and create visualizations in Power BI, in just a couple of minutes. In this chapter, not only did we learn about integrating the Power BI workspace with your Synapse workspace, but also how to create or modify reports directly in Synapse Studio. This chapter also outlined how to create visualizations for the data stored in Synapse SQL pools.

In the next chapter, we are going to learn how to use Azure Synapse to perform real-time analytics on streaming data.