DataCamp Flash Sale:
50% Off - Build Data and AI Skills!
Grab it
Learn to bring data into Microsoft Fabric, covering Pipelines, Dataflows, Shortcuts, Semantic Models, security, and model refresh.
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.
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.
Learn to use different types of Shortcuts to manage deletion scenarios and enhance data accessibility through security features.
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.
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.
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.
