Course
Data Ingestion and Semantic Models with Microsoft Fabric
BasicSkill Level
Updated 12/2025AzureOther4 hr15 videos55 Exercises4,050 XP3,489Statement of Accomplishment
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Loved by learners at thousands of companies
Training 2 or more people?
Try DataCamp for BusinessCourse 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
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.
Data Ingestion and Semantic Models with Microsoft Fabric
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
FAQs
What prior knowledge do I need before taking this course?
We recommend a basic understanding of Microsoft Fabric and its use cases. If you've never worked with Fabric before, we recommend taking our Introduction to Microsoft Fabric course!
How will this course help me in my career?
This course will equip you with the essential knowledge to work with Microsoft Fabric, a relevant tool for various roles, including Data Engineer, Data Scientist, and BI Analyst. This course will provide the foundational knowledge to start bringing data into Fabric and creating Power BI reports.
Will this course cover Microsoft Certifications?
This course was built to align with some of the topics covered in Microsoft’s Fabric Analytics Engineer Associate certification (DP-600). This course, along with our other Fabric courses, will help you prepare for that certification. You will also receive a DataCamp certification after completing the course.
What is the duration of the course, and is it self-paced?
The course is designed to be flexible and self-paced. While the total content is structured to be completed in approximately 4 hours, learners can progress through the material at a pace that suits their schedule and learning style
Is the course interactive?
This course is fully interactive, allowing learners to get hands-on experience with the Fabric platform. Throughout the course, learners will be given a Fabric account and will follow instructions to complete exercises using that account.
Join over 19 million learners and start Data Ingestion and Semantic Models with Microsoft Fabric today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.