Understanding Data Ingestion - Azure/Fabric Data Factory & Dataflows

Understanding Data Ingestion: An Introduction to Azure and Fabric Data Factory and Dataflows

Every BI solution depends on getting data from where it lives to where it can be used. Choosing the wrong tool for that job is an expensive mistake, and the Microsoft platform now offers several options: Azure Data Factory, Fabric Data Factory, Power BI Dataflows and Fabric Dataflows. This 1-day overview course introduces the concepts, terminology and technology behind data ingestion and transformation, and helps you decide which approach suits your project.

The day takes you through the core Azure and Fabric ELT (extract, load, transform) options, what each does well, and where each fits in a BI solution. You will leave knowing the common terminology, understanding the differences between the tools, and able to choose the right method for your own projects, with best practice and business process guidance to support successful delivery.

Develop Data Ingestion Knowledge:

• The main approaches to ELT, and the terminology used when discussing data ingestion and movement.

• The basics of Azure Data Factory and how it supports data movement in a BI solution.

• The basics of Fabric Data Factory, and how it differs from the Azure version.

• The basics of Power BI Dataflows and Fabric Dataflows, and what they offer for data preparation.

• How to choose the right ELT method for your data, your team and your project.

• Best practice and business processes for implementing data ingestion successfully.

Learn Data Ingestion Your Way, Training Tailored to Your Needs

This course is offered in a UK-based face-to-face classroom or virtual setting and can be tailored to your needs. If you are already using, or planning to use, a particular platform, let us know and we can focus the day on the options most relevant to you.

Solve Your Data Ingestion Struggles with Expert Training

Whether you are a project manager, business analyst, BI lead or someone commissioning a reporting solution, those who come to PTR for this course are usually asking:

• What are my options for getting data into a BI solution?

• What is the difference between Azure Data Factory, Fabric Data Factory and Dataflows?

• Which tool should we choose for this project?

• What terminology do I need to understand to talk to technical teams and suppliers?

• What does good practice look like, and what processes do we need around it?

If this sounds familiar, this is the course for you. We will give you a clear, practical picture of the options and how to choose between them.

No specific technical skills are required for this 1-day overview course.

An interest in, or involvement with, business reporting will help you get the most from the day. The course suits people who commission, manage, support or work alongside BI solutions, as well as those who are new to data ingestion and want a clear introduction before moving on to hands-on training.