Introduction to Data Integration in Azure Synapse Analytics - Cathrine Wilhelmsen

Session info

Do you regularly need to get data for your projects?

Yep! 🙋‍♀️

Data is at the core of every Business Intelligence, Data Science, and Machine Learning project. You need data to understand what has happened in the past, to predict what may happen in the future, to discover patterns and anomalies, and to gain the insight necessary for making faster and better decisions.

But before you can do any of those things, you need to ingest, store, transform, integrate, and prepare your data. Guess what? You can do all of those things in Azure Synapse Analytics - without having to write any code!

In this session, we will cover the fundamentals of data integration in Azure Synapse Analytics. First, we will discuss when Azure Synapse Analytics is the right tool of choice. Then, we will go through what Pipelines and Data Flows are, and when to use them. Finally, we will see how easy it is to ingest and transform data both on-premises and in the cloud.

About the speaker

Cathrine loves data and coding, as well as teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Integration and Data Warehousing. Her core skills are Azure Data Factory, Azure Synapse, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the Azure and Microsoft Data communities as a Microsoft Data Platform MVP, international speaker, blogger, organizer, and chronic volunteer.