Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
Data Integrator

Beginner's Guide to Data Integration using Azure Data Factory or Azure Synapse Analytics


What 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 collect, store, transform, integrate, and prepare your data.

That's where you and I fit in! 🤓

In this full-day workshop, you will learn the skills you need to build and maintain data integration solutions in Azure Data Factory or Azure Synapse Analytics.

We will start completely from scratch with a conceptual overview, discuss when and why you would choose Azure Data Factory or Azure Synapse Analytics, and build a solution for ingesting data. Then, we will look at options for transforming and preparing data for further analysis, cover how to work with both on-premises and cloud data stores, and build dynamic pipelines as part of a metadata-driven solution. As we move from individual development to team development, we will cover source control, security, and review options for continuous integration and continuous deployment (CI/CD). Throughout the day, we will cover best practices for development and evaluate how to optimize our solutions for both performance and pricing.

Get ready for a day full of learning, networking, and new ideas! 💡

Feedback link

Learning Objectives

Previous Experience

Tech Covered

Azure, Synapse Analytics, Data transformation and integration, Data Integrator, Developing