September meet online: Creating a Logical DWH using Azure Synapse Serverless

About the meet
We'll open at 18:15 to allow people to join. The talk will commence at 18:30 sharp and will likely to last 45-60 minutes. The meeting will be left open for a more informal chat afterwards if anyone wishes to do so!

About the talk
Creating a Logical Data Warehouse using Azure Synapse Serverless SQL Pools with Andy Cutler.

The Serverless SQL Pools service within Azure Synapse Analytics allows querying CSV, JSON and Parquet data in Azure Storage, Data Lake Gen1/2 and Cosmos DB. With this functionality we are able to create a Logical Data Warehouse over data stored in these systems without moving and loading the data. However, the source data may not be in the best possible format for analytical workloads...

In this session we'll be looking at using Azure Synapse Analytics SQL Serverless Pools to create a Data Warehouse using the Dimensional Modelling technique to create a set of Dimensions and Facts and store this data in a more appropriate structure and file format.

All data will be stored in an Azure Data Lake Gen2 account with processing and serving performed by the SQL Serverless Pools engine.

About the speaker
Independent Business Intelligence Consultant at Datahai. I am an Azure Data Platform professional working predominantly with Azure Synapse Analytics (SQL Pools), Data Factory, SQL Server and Power BI. I hold an MSc in Business Intelligence and Data Mining.