- Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows for visually creating multi-step data ingestion and transformation using Power Query Online.
In this module, you'll learn how to:
- Describe Dataflow capabilities in Microsoft Fabric
- Create Dataflow solutions to ingest and transform data
- Include a Dataflow in a pipeline
- Use Data Factory pipelines in Microsoft Fabric
In this module, you learn how to:
Describe pipeline capabilities in Microsoft Fabric.
Use the Copy Data activity in a pipeline.
Create pipelines based on predefined templates.
Run and monitor pipelines.
- Apache Spark is a core technology for large-scale data analytics. Microsoft Fabric provides support for Spark clusters, enabling you to analyze and process data at scale.
In this module, you'll learn how to:
Configure Spark in a Microsoft Fabric workspace
Identify suitable scenarios for Spark notebooks and Spark jobs
Use Spark dataframes to analyze and transform data
Use Spark SQL to query data in tables and views
Visualize data in a Spark notebook
- Microsoft Fabric provides a scalable and flexible store for real-time data.
After completing this module, you'll be able to:
- Create an Eventhouse in Microsoft Fabric.
- Write effective KQL queries.
- Understand how to use materialized views and stored functions in a KQL database.
PowerBI Data Analyst - Create visualizations and dashboards from scratch
Free courses from frontend to fullstack and AI
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Syllabus
- Ingest Data with Dataflows Gen2 in Microsoft Fabric
- Introduction
- Understand Dataflows Gen2 in Microsoft Fabric
- Explore Dataflows Gen2 in Microsoft Fabric
- Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
- Exercise - Create and use a Dataflow Gen2 in Microsoft Fabric
- Module assessment
- Summary
- Orchestrate processes and data movement with Microsoft Fabric
- Introduction
- Understand pipelines
- Use the Copy Data activity
- Use pipeline templates
- Run and monitor pipelines
- Exercise - Ingest data with a pipeline
- Module assessment
- Summary
- Use Apache Spark in Microsoft Fabric
- Introduction
- Prepare to use Apache Spark
- Run Spark code
- Work with data in a Spark dataframe
- Work with data using Spark SQL
- Visualize data in a Spark notebook
- Exercise - Analyze data with Apache Spark
- Module assessment
- Summary
- Work with real-time data in an Eventhouse in Microsoft Fabric
- Introduction
- Get started with an Eventhouse
- Use KQL effectively
- Materialized views and stored functions
- Exercise - Work with data in an Eventhouse
- Module assessment
- Summary