fbpx

NEED HELP? TALK TO AN EXPERT (904) 638-5743

Sign In
Start Learning

Advanced Data Flows in Azure Synapse Analytics

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • Data Flows
  • Basic Transformations
  • Joining Data
  • Multiple Branches
  • Working with JSON
  • Pivoting Data
  • Flowlets
Sign-up for Free Trial
This course includes:
  • 5.16 hours of training
  • Access on mobile and browser
  • Certificate of Completion

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.

Outline

 

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

Instructor

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.
REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Related products

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.

 

Bonus:

• 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!

Sign-up for Free Trial