After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
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.Prerequisites
Curriculum
Course outline
1
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.
- Data Ingestion and Semantic Models50 XP
- Bringing Data into Fabric with Pipelines100 XP
- Introduction to Fabric Data Pipelines50 XP
- Exploring Data Pipeline Activities100 XP
- Pipelines with Parameters and Variables100 XP
- Implementing Scheduled Pipeline Run100 XP
- Storage Solutions and SQL Object Creation50 XP
- Ingesting Data into Lakehouse Tables and Files100 XP
- Logging Execution Details with Stored Procedures100 XP
- Creating a View to Monitor Pipeline Logs100 XP
- Shortcuts in OneLake50 XP
- Identifying Shortcut and Target Paths100 XP
- Understanding Shortcut Permissions in OneLake50 XP
- Tracking Updates in Shortcuts100 XP
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.
Data Ingestion and Semantic Models with Microsoft Fabric
Course
Complete
