Courses
Data Ingestion and Semantic Models with Microsoft Fabric
基本的技能水平
更新 2025年12月AzureOther4小时15 videos55 Exercises4,050 XP3,196成就声明
深受数千家公司学员的喜爱
培训2人或以上？
试试DataCamp for Business课程描述
Data Ingestion and Semantic Models
In this course, you’ll learn several different methods to bring data into Microsoft Fabric. After ingesting your data, you’ll then learn how to structure this data using Semantic Models to improve your visualizations and reports.Master Pipelines and Dataflows for Data Ingestion
Begin by exploring Pipelines and Dataflows in Fabric. You’ll learn to configure pipeline activities, use parameters and variables, and schedule your pipeline runs. Then, you’ll learn to use Dataflows to discover various transformation options and optimize performance with partitioning, staging, and fast copy.Leverage Shortcuts for Efficient Data Access
Learn to use different types of Shortcuts to manage deletion scenarios and enhance data accessibility through security features.Build and Optimize Semantic Models
In the second half of the course, you’ll create robust Semantic Models in Fabric. You will learn about key storage modes—Import, DirectQuery, Direct Lake, and Composite models. You’ll build effective relationships, master star and snowflake schemas, and work with large datasets to ensure optimal performance in complex scenarios.Master Advanced Concepts in Semantic Models and Power BI
Finally, you’ll learn advanced concepts for managing and optimizing semantic models. You’ll implement Row-Level Security (RLS) and Object-Level Security (OLS), refresh models, and develop comprehensive Power BI reports. Then, within Power BI, you’ll explore Copilot, optimize performance with DAX Studio, and leverage tools like Tabular Editor’s Best Practice Analyzer (BPA) and Performance Analyzer to create efficient, secure models and reports.先决条件
Introduction to Microsoft Fabric1
Understanding Data Factory Pipelines and Shortcuts
In this chapter, you’ll explore data pipelines, storage solutions, and shortcuts in Microsoft Fabric, learning how to configure, automate, and manage data ingestion seamlessly.
2
Dataflows Gen2 - Implementation and Optimization
This chapter provides a comprehensive introduction to Dataflows Gen 2, covering key concepts like data transformation, ingestion, scheduling, performance optimization, and choosing the right storage solutions for effective data management and processing.
3
Building Semantic Models in Power BI
In Chapter 3, we’ll dive into building and optimizing semantic models, including complex relationships like many-to-many and circular connections. You’ll learn report creation essentials, foundational DAX, and how to use measures and calculated columns, along with advanced techniques to enhance data performance and analysis in Power BI.
4
Advanced Concepts for Semantic Models
This chapter covers advanced Semantic Model topics like Row-Level and Object-Level Security. You'll also learn about a variety of tools that can help you use Semantic Models in Power BI more efficiently.