Advanced Data Flows in Azure Synapse Analytics

Part Of The On-Demand Courses


  • Data Flows
  • Basic Transformations
  • Joining Data
  • Multiple Branches
  • Working with JSON
  • Pivoting Data
  • Flowlets
This course includes:

Course Description

ETL can be easy with Synapse. Mapping data flows are visually designed data transformations in Azure Synapse Analytics. Data flows provide an entirely visual experience with no coding required. This course goes through the principles of a data flow and then covers the different transformations that are available for users to move and transform their data. Whether you are working with JSON or building out advanced data flows with Window transformations this course is here to assist you.



Module 00 | Course Introduction
0h 08m total


Module 01 | Data Flows
1h 31m total


Module 01A | Data Flows – Introduction
0h 11m


Module 01B | Data Flows – Cost & Compute
0h 16m


Module 01C | Data Flows – Creating & Running
0h 35m


Module 01D | Data Flows – Scheduling & Monitoring
0h 11m


Module 01E | Data Flows – Parameterizing Data Flows
0h 18m


Module 02 | Basic Transformations
1h 04m total


Module 02A | Basic Transformations – Select, Filter & Sort
0h 23m


Module 02B | Basic Transformations – Aggregate vs. Window
0h 22m


Module 02C | Basic Transformations – Derived Column
0h 08m


Module 02D | Basic Transformations – Cast
0h 11m


Module 03 | Joining Data
0h 40m total


Module 03A | Joining Data – Lookup
0h 12m


Module 03B | Joining Data – Joins
0h 12m


Module 03C | Joining Data – Union
0h 16m


Module 04 | Multiple Branches
0h 25m total


Module 04A | Multiple Branches – New Branch
0h 12m


Module 04B | Multiple Branches – Conditional Split
0h 13m


Module 05 | Working with JSON
0h 38m total


Module 05A | Working with JSON – Flatten
0h 18m


Module 05B | Working with JSON – Stringify
0h 10m


Module 05C | Working with JSON – Parse
0h 10m


Module 06 | Pivoting Data
0h 25m total


Module 06A | Pivoting Data – Pivot
0h 16m


Module 06B | Pivoting Data – Unpivot
0h 09m


Module 07 | Flowlets
0h 07m total


Module 07A | Flowlets
0h 07m


Austin Libal

Azure Solutions Architect
Austin is a Jacksonville native who graduated from The Baptist College of Florida in 2012. He previously worked as a manager in the retail service industry. He enjoys spending time with his wife and two kids. His primary focus at Pragmatic Works is on Azure Synapse Analytics and teaching the best practices for data integration, enterprise data warehousing, and big data analytics. He also enjoys helping customers learn the ins and outs of Power BI and showing people new ways to grow their business with the Power Platform.

System Requirements

  • Microsoft Azure Account (Paid or Trial)

What to Know Before Class

  • This course assumes you have completed the Introduction to Azure Synapse Analytic course.

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!