Introduction to Microsoft Fabric
Learn Microsoft Fabric’s seven experiences, load and query lakehouse data with SQL, and build Power BI semantic models in self-paced, interactive exercises.
Microsoft Fabric brings data engineering, data science and business intelligence together in one platform, and each of its seven experiences handles a different part of that work. You meet those experiences, see how tables are kept in the Delta-Parquet format, load and query lakehouse data with SQL, and connect that data to reports through semantic models, working inside the platform itself.
What You Will Achieve
- Tell apart Fabric’s seven experiences, such as Data Factory, Data Warehouse, and Real-Time Intelligence, and match each one to a use case
- Bring raw files and shortcut data into a lakehouse and turn them into usable tables
- Query and change lakehouse tables through the SQL analytics endpoint, the visual query editor, and notebook code
- Build a semantic model for Power BI reports and weigh the pros and cons of its storage modes
Program Overview
Fabric Experiences and Core Concepts
A first tour of what Fabric is, the roles that use it, and its seven experiences, with short hands-on looks at several of them.
- Data engineer and machine learning specialist personas
- The Delta-Parquet format
- Warehouses, lakehouses, and adding data with a dataflow
- Notebooks, ML models, and detecting changes in data
Ingesting and Querying Lakehouse Data
Data is added to a lakehouse, then read and edited with SQL, the visual editor, and notebook code.
- Ingesting data, creating tables from raw files, and shortcuts
- The SQL analytics endpoint and writing SQL queries
- Visual query editor features
- Editing tables, endpoint errors, and DML statements
Power BI and Semantic Models
Lakehouse data is brought into Power BI through semantic models, with a look at licensing and the trade-offs between storage modes.
- Creating a semantic model and the default semantic model
- Getting a Power BI license
- Fast analysis with Direct Lake
- Storage modes: pros and cons
Certificate Awarded (Paid)
Complete the course to earn it.
Job Outlook
These skills apply in organizations that keep, prepare, and report on their data in Fabric, in the daily work of data engineers, machine learning specialists, and business intelligence teams.
Good for: Data and reporting staff whose organization is adopting Microsoft Fabric and who want a guided first look at lakehouses, SQL querying, and Power BI semantic models.
Keep in mind: It is a first step toward Microsoft’s Fabric Analytics Engineer Associate exam (DP-600), which is taken separately; the course itself awards a certificate of completion.
Bottom line: A practical tour of Fabric built around one lakehouse workflow: load the data, query it with SQL, and model it for Power BI.
Frequently Asked Questions
Do I need my own Fabric account for the exercises?
Learners are given a Fabric account during the course and complete the exercises in it by following step-by-step instructions. One lesson in the Power BI chapter also covers getting your Power BI license.
Will this course prepare me for the DP-600 exam?
It is a starting point for Microsoft's Fabric Analytics Engineer Associate certification (DP-600), and its closing lesson discusses that certification. The exam is taken separately, so plan on further study before sitting it.
Which Fabric experiences does the course introduce?
The opening chapter names seven: Data Factory, Data Engineering, Data Warehouse, Data Science, Real-Time Intelligence, Power BI, and Data Activator. Short exercises explore a warehouse, a lakehouse, a notebook, an ML model, and detecting changes in data.
How does the course connect Fabric data to Power BI?
Through semantic models. The final chapter creates one, looks at the default semantic model, uses Direct Lake for fast analysis and weighs the pros and cons of the storage modes.


There are no reviews yet.