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.

[@bookaltd]

Thanks Cathrine and Torstein. Makes it look so easy to use.

[@msk2982]

Thank you Cathrine. Great video. Was debating ADF or Synapse but will give Synapse a go.

[@culpritdesign]

Great content

[@madhur6504]

thanks Cathrine.Could you please advise if gateway is required to refresh the data when data is loaded to power bi from azure synapse (in cloud)

[@michaels1813]

How does Synapse compare to Data Bricks?

[@timothyjaco7357]

Wrong title and wrong terminology: the term "integration" applies to the domain of APIs. You are talking about ETL for data warehousing for BI and analytics - not integrations.

[@krneki6954]

nope. she knows whats shes talking about. even microsoft has named the pipeline feature "Integrate"

[@lambuth]

No field of tech has the monopoly on a word.