Learn Azure Synapse Data Explorer

A learn-by-doing guide for you to work on use cases helping you to ingest, analyze and serve insightful data from IoT as well as Telemetry data sources using Azure Synapse Data Explorer.

Key Features

• Augment advanced analytics project with your IoT and application data
• Expand your existing Azure Synapse environments with unstructured data
• Build industry-level projects on integration, experimentation, and dashboarding with Azur Synapse

Book Description

Large volumes of data are generated daily from applications, websites, internet of things devices, and other free-text, semi-structured data sources. Azure Synapse Data Explorer helps you collect, store, and analyze such data, and work with other analytical engines, such as Apache Spark, to develop advanced data science projects and maximize the value you get from your data.

This book offers a comprehensive view of Azure Synapse Data Explorer that explores not only the core scenarios of Data Explorer but also how it integrates with the whole picture within Azure Synapse. From data ingestion, through data visualization and advanced analytics, you will learn an end-to-end approach to maximizing the value of unstructured data and driving powerful insights using data science capabilities. With real-world usage scenarios, you'll learn to identify key projects where Azure Synapse Data Explorer can help you achieve your business goals. You will also learn how to manage big data as part of a software as a service platform, tune, secure, and serve data to end users.

By the end of this book, you will have mastered the big data lifecycle and be able to implement advanced analytical scenarios from raw telemetry and log data.

What you will learn

• Integrate Data Explorer pools with all other Azure Synapse services
• Create Data Explorer pool with Azure Synapse Studio and Azure Portal
• Ingest, analyze, and serve data to users with Azure Synapse Pipelines
• Integrate Power BI and visualize data with Synapse Studio
• Configure the Azure Machine Learning integration in Azure Synapse
• Manage Cost and troubleshoot Data Explorer pools in Synapse analytics
• Secure Synapse workspace and grant access to Data Explorer pools

Who This Book Is For

If you are a data engineer, data analyst, or business analyst working with unstructured data and want to learn how to maximize the value of such data, this book is for you. This book is also excellent for professionals already working with Azure Synapse who want to incorporate unstructured data into their data science projects. To maximize your learning experience from this book, you should be familiar with working with data and with performing simple queries using SQL or KQL. Even though it is not a requirement, familiarity with Python will help you get more from the examples.

Table of Contents

1. Introducing Azure Synapse Data Explorer
2. Creating Your First Data Explorer Pool
3. Exploring Azure Synapse Studio
4. Real-world usage scenarios
5. Data Ingestion
6. Data analysis with Power BI, Python, and KQL
7. Advanced analytics leveraging Azure Synapse services
8. Data Export
9. System monitoring and diagnostics
10. Tuning and resource management
11. Securing your environment
12. Advanced Data Management