From the course: Introduction to Microsoft Fabric by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Load and transform data through pipelines and dataflows

Load and transform data through pipelines and dataflows - Microsoft Fabric Tutorial

From the course: Introduction to Microsoft Fabric by Microsoft Press

Start my 1-month free trial Buy for my team

Load and transform data through pipelines and dataflows

“

- As we have discussed before, preparing data for analytics solution requires loading the data into the platform used. It also requires changing the structure of the data as most data coming from transactional systems is structured in a specific way that is not fitted for analytics. There is a set of tools and techniques to do just this, loading and transforming data. It's simply called ETL for extract, transform, load. Extract data from different sources, transform the structure of the data, and load the data into the storage you will use for your solution. Will probably not surprise you at this point that Fabric offers its own ETL capabilities. As a matter of fact, you have multiple options to choose from, and we will cover two of these in this sub-lesson. But first, note that the ETL acronym not only stands for what these tools do, it also suggests an order in which these tasks are performed. First, you extract data, then you apply transformations, and then you load the transformed…

Contents