Microsoft Fabric: Data Transformations Using Dataflow Gen2

Microsoft Fabric 2024    |    Expert
  • 18 videos | 1h 54m 16s
  • Includes Assessment
  • Earns a Badge
Microsoft Fabric Data Factory is a powerful tool for integrating and orchestrating data workflows, enabling organizations to manage data efficiently. Dataflow Gen2 is an important component in Fabric Data Factory that focuses on transforming and managing data within those workflows, providing advanced capabilities for data cleaning and transformation. In this course, learn about Data Factory and Dataflow Gen2, beginning with building data flows using Power Query, cleaning data, replacing values, and applying essential mathematical transformations. Next, examine the fast copy Dataflow Gen2 feature, including when and why you would want to use fast copy. Finally, explore connectors for Dataflows Gen2 and incremental refresh techniques. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Describe the features and use cases of microsoft fabric data factory
    List the features of dataflow gen2 and compare them with gen1
    Recognize how to use power query in dataflow gen2
    Create a new data flow and connect it to a data lakehouse source to load data for transformation
    Apply transforms to remove duplicates and replace values
    Perform mathematical transformations, filter rows, and remove columns
    Merge queries in a data flow and publish the data flow
    Export data flow templates and import templates to set up new data flows
  • Recognize the pros and cons of using fast copy in dataflow gen2
    Identify when to use staging in dataflow gen2
    Copy data by requiring fast copy
    Copy data with automatically-enabled fast copy when row thresholds are met
    Explore supported and unsupported transformations when using fast copy
    Enable staging to perform fast copy to a different destination
    Outline special connectors in dataflow gen2
    Describe incremental refresh in dataflow gen2
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 54s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 9m 15s
    Upon completion of this video, you will be able to describe the features and use cases of Microsoft Fabric Data Factory. FREE ACCESS
  • Locked
    3.  Dataflow Gen2
    8m 52s
    After completing this video, you will be able to list the features of Dataflow Gen2 and compare them with Gen1. FREE ACCESS
  • Locked
    4.  Power Query in Dataflow Gen2
    5m 10s
    Through this video, you will be able to recognize how to use Power Query in Dataflow Gen2. FREE ACCESS
  • Locked
    5.  Creating a Data Flow and Connecting to Data Sources
    8m 32s
    Learn how to create a new data flow and connect it to a data lakehouse source to load data for transformation. FREE ACCESS
  • Locked
    6.  Removing Duplicates and Replacing Values
    9m 36s
    During this video, discover how to apply transforms to remove duplicates and replace values. FREE ACCESS
  • Locked
    7.  Performing Mathematical Transformations, Filtering Rows, and Removing Columns
    6m 23s
    Find out how to perform mathematical transformations, filter rows, and remove columns. FREE ACCESS
  • Locked
    8.  Merging Data and Publishing the Data Flow
    11m 23s
    In this video, you will learn how to merge queries in a data flow and publish the data flow. FREE ACCESS
  • Locked
    9.  Exporting and Importing Data Flow Templates
    2m 49s
    Discover how to export data flow templates and import templates to set up new data flows. FREE ACCESS
  • Locked
    10.  Dataflow Gen2 Fast Copy
    7m 20s
    Through this video, you will be able to recognize the pros and cons of using fast copy in Dataflow Gen2. FREE ACCESS
  • Locked
    11.  Dataflow Gen2 Staging
    4m 2s
    In this video, we will identify when to use staging in Dataflow Gen2. FREE ACCESS
  • Locked
    12.  Requiring Fast Copy for Data Transfers
    8m 43s
    In this video, find out how to copy data by requiring fast copy. FREE ACCESS
  • Locked
    13.  Utilizing Automatic Fast Copy When Thresholds Are Met
    7m 5s
    During this video, you will learn how to copy data with automatically-enabled fast copy when row thresholds are met. FREE ACCESS
  • Locked
    14.  Exploring Supported Transformations in Fast Copy
    5m 2s
    In this video, discover how to explore supported and unsupported transformations when using fast copy. FREE ACCESS
  • Locked
    15.  Enabling Staging for Fast Copy
    6m 19s
    Learn how to enable staging to perform fast copy to a different destination. FREE ACCESS
  • Locked
    16.  Connectors for Dataflow Gen2
    3m 47s
    Upon completion of this video, you will be able to outline special connectors in Dataflow Gen2. FREE ACCESS
  • Locked
    17.  Incremental Refresh in Dataflow Gen2
    5m 54s
    After completing this video, you will be able to describe incremental refresh in Dataflow Gen2. FREE ACCESS
  • Locked
    18.  Course Summary
    2m 10s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Course GCP Data Engineer Pro: Using Google Datastream
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Data Fabric and Data Mesh Approaches with AI: A Guide to AI-based Data Cataloging, Governance, Integration, Orchestration, and Consumption