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:

Speaker

  • Håkan Forsberg

    Håkan Forsberg

    Cloud Solution Architect - Data/AI
    Microsoft

Tags

AudienceTechnical
Area of InterestAnalytics
FormatOn-Demand
LanguageSwedish
Solution AreaData & AI