- Design gold layers, semantic models, and documentation that enable Copilot, data agents, and enterprise ontologies to deliver accurate, business-relevant insights.
By the end of this module, you're able to:
- Explain how semantic model context guides Copilot answers.
- Design a focused gold layer for AI consumption.
- Select the appropriate Prep for AI control for a semantic model failure.
- Decide when to use Fabric IQ to share stable semantic model entities across teams.
- Validate AI readiness by testing priority questions and fixing the cause of wrong answers.
- Learn the fundamentals of Microsoft Fabric IQ, including how ontologies create a shared business vocabulary, the six items in the IQ workload, and how ontology modeling differs from traditional data modeling approaches.
By the end of this module, you'll be able to:
- Explain what Fabric IQ is and how it fits within the Microsoft IQ enterprise intelligence layer
- Describe the role of ontology items in creating entity types, entity instances, properties, relationships, and rules
- Distinguish between the roles of each IQ workload item: ontology items, data agents, Graph in Microsoft Fabric, semantic models, operations agents, and planning
- Compare ontology modeling's concept-driven approach with traditional use-case-driven data modeling
- Learn how to create ontologies in Fabric IQ by building manually or generating from Power BI semantic models, then bind ontology definitions to OneLake data sources including lakehouse tables and eventhouse streams.
By the end of this module, you'll be able to:
- Evaluate two approaches for creating an ontology in Fabric IQ
- Build an ontology manually by working with entity types, properties, keys, and relationships
- Generate an ontology from a Power BI semantic model
- Connect an ontology to data sources and preview the ontology
The Most Addictive Python and SQL Courses
Master AI and Machine Learning: From Neural Networks to Applications
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Syllabus
- Prepare semantic models for AI in Power BI and Microsoft Fabric
- Introduction
- Explain how semantic model context guides Copilot answers
- Design a focused gold layer for AI consumption
- Select the appropriate prep for AI control
- Decide when to extend a semantic model with Fabric IQ
- Validate AI readiness
- Exercise: Prepare a semantic model for AI
- Module assessment
- Summary
- Understand Microsoft Fabric IQ fundamentals
- Introduction
- Get started with Fabric IQ
- Explore Microsoft Fabric IQ components
- Understand the ontology modeling paradigm
- Module assessment
- Summary
- Create an ontology with Fabric IQ
- Introduction
- Choose an ontology creation approach
- Build an ontology manually
- Generate an ontology from a Power BI semantic model
- Connect an ontology to data
- Configure ontology relationships
- Preview the ontology
- Exercise - Build an ontology manually
- Exercise - Generate an ontology from a Power BI semantic model
- Module assessment
- Summary