Session Information
Duration
1 - day, Remote.
Difficulty
300 – Advanced
Instructors language
Swedish
Audience
The following stakeholders will benefit from this hands-on workshop.
- Business Analysts
- Data Analysts
- Data Engineers
Overview
The Analytics in a Day workshop teaches attendees how to take advantage of analytics in the cloud, from data ingestion to business intelligence. We will go through the concept of Azure Synapse Analytics and learn how to automate data movement with Azure Synapse Pipelines. We will practice how to explore data in files that reside in a data lake using SQL on-demand and Spark pools.
Objectives
After completing this workshop, attendees will be equipped to:
- Explore data in data lake with SQL on-demand and Spark
- Understand Azure Synapse terminology
- Manage data movement with Azure Synapse Pipelines
- Key concept around Lake databases and templates
- Understanding how to save and search log telemetry data using Data Explorer
Agenda
- Explore the data lake with Azure Synapse Serverless SQL Pool and Azure Synapse Spark
- Working with Azure Synapse Pipelines
- High Performance Analysis with Azure Synapse Dedicated SQL Pools
- Lake Databases and Database templates
- Log and telemetry analytics (ADX)
- Data governance with Azure Purview
- Power BI integration
- Data Science with Spark (optional)
Pre-requisites
Before attending this course, it is recommended that you meet the following criteria:
- You understand data structures and working with SQL Server and computer networks
- Basic knowledge of the Microsoft Azure platform
- Be familiar with manoeuvring around Azure portal
If you are new to these, here are a few references you can complete prior to class:
