{"product_id":"microsoft-fabric-analytics-engineer-dp-600","title":"Microsoft Fabric Analytics Engineer (DP-600)","description":"\u003cdiv\u003e\n\u003cp\u003eThis Microsoft Fabric Analytics Engineer (DP-600) course teaches experienced data professionals how to design, implement, secure, and manage enterprise-scale analytics solutions using Microsoft Fabric.\u003c\/p\u003e\r\n\u003cp\u003eStudents will learn how to prepare, transform, enrich, and serve data for analytics consumers, including data analysts, report developers, and AI agents. The course covers end-to-end analytics in Microsoft Fabric, including OneLake, lakehouses, data warehouses, Real-Time Intelligence, Dataflows Gen2, notebooks, T-SQL, semantic models, Fabric IQ, ontologies, security, governance, and analytics lifecycle management.\u003c\/p\u003e\r\n\u003cp\u003eThis course also helps prepare learners for the Microsoft Certified: Fabric Analytics Engineer Associate certification exam.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eMicrosoft Fabric Analytics Engineer (DP-600) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn This Course, You Will Learn How To\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e•    Use Microsoft Fabric to support end-to-end enterprise analytics solutions\u003cbr\u003e•    Discover, connect to, and manage data using OneLake\u003cbr\u003e•    Create and work with lakehouses, warehouses, and eventhouses\u003cbr\u003e•    Choose the right Fabric data store for different analytics scenarios\u003cbr\u003e•    Transform data using Dataflows Gen2, notebooks, Spark SQL, PySpark, and T-SQL\u003cbr\u003e•    Design dimensional models for analytics workloads\u003cbr\u003e•    Create DAX calculations in Power BI semantic models\u003cbr\u003e•    Design, optimize, secure, and manage semantic models at scale\u003cbr\u003e•    Prepare semantic models and gold layers for AI, Copilot, data agents, and enterprise ontologies\u003cbr\u003e•    Understand Microsoft Fabric IQ and create ontologies\u003cbr\u003e•    Secure data access across Microsoft Fabric workspaces, items, warehouses, and semantic models\u003cbr\u003e•    Apply governance practices such as data classification, sensitivity labels, endorsement, and documentation\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eTraining Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eWhile there are no required prerequisites for taking this course, students should have experience with data modeling, data transformation, and analytics.\u003c\/p\u003e\n\u003cp\u003eRecommended experience includes:\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eTranslating business requirements into analytical measures\u003c\/li\u003e\n\u003cli\u003eWorking with SQL or DAX\u003c\/li\u003e\n\u003cli\u003eBuilding semantic models and reports in Power BI\u003c\/li\u003e\n\u003cli\u003eUnderstanding core data analytics concepts\u003c\/li\u003e\n\u003cli\u003eFamiliarity with KQL and Python is helpful, but not required\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eMicrosoft Fabric Analytics Engineer (DP-600) Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eCourse Outline\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eIntroduction to end-to-end analytics using Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eDiscover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Learn about Microsoft Fabric, how it works, and identify how you can use it for your analytics needs.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eExplore end-to-end analytics with Microsoft Fabric\u003c\/li\u003e\n\u003cli\u003eExplore data teams and Microsoft Fabric\u003c\/li\u003e\n\u003cli\u003eEnable and use Microsoft Fabric\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDiscover and connect to data in OneLake\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eBrowse and connect to data using Microsoft OneLake's unified storage. Discover data across workspaces with the OneLake catalog, create shortcuts to reference existing data, and explore streaming sources in Real-Time hub.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUnderstand OneLake\u003c\/li\u003e\n\u003cli\u003eBrowse and connect to data in OneLake\u003c\/li\u003e\n\u003cli\u003eDiscover streaming data in Real-Time hub\u003c\/li\u003e\n\u003cli\u003eExercise: Discover and connect to data in OneLake\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eGet started with lakehouses in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eLakehouses in Microsoft Fabric combine data lake storage flexibility with data warehouse analytical capabilities. Learn how to create a lakehouse, ingest and transform data, and query data with SQL and Spark.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe lakehouse features and capabilities\u003c\/li\u003e\n\u003cli\u003eIngest and transform data in a lakehouse\u003c\/li\u003e\n\u003cli\u003eQuery and analyze lakehouse data\u003c\/li\u003e\n\u003cli\u003eExercise: Create a Microsoft Fabric lakehouse\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eGet started with data warehouses in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eUnderstand what a Fabric data warehouse is, why it provides full T-SQL transactional capabilities, and how to create, query, and transform data for analytics.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUnderstand data warehouses\u003c\/li\u003e\n\u003cli\u003eUnderstand data warehouses in Fabric\u003c\/li\u003e\n\u003cli\u003eQuery and transform data\u003c\/li\u003e\n\u003cli\u003eModel data in a warehouse\u003c\/li\u003e\n\u003cli\u003eSecure and monitor a warehouse\u003c\/li\u003e\n\u003cli\u003eExercise: Create and query a warehouse\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eGet started with Real-Time Intelligence in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eReal-Time Intelligence in Microsoft Fabric helps you ingest, process, store, visualize, and act on data in motion to get insights from events as they happen.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eWhat is real-time data analytics?\u003c\/li\u003e\n\u003cli\u003eReal-Time Intelligence in Microsoft Fabric\u003c\/li\u003e\n\u003cli\u003eIngest and transform real-time data\u003c\/li\u003e\n\u003cli\u003eStore and query real-time data\u003c\/li\u003e\n\u003cli\u003eVisualize real-time data\u003c\/li\u003e\n\u003cli\u003eAutomate actions\u003c\/li\u003e\n\u003cli\u003eExercise: Get started with Real-Time Intelligence in Microsoft Fabric\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eChoose data stores in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eEvaluate lakehouse, warehouse, and eventhouse options to select the appropriate analytical data store for business scenarios in Microsoft Fabric.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe analytical data store options\u003c\/li\u003e\n\u003cli\u003eEvaluate lakehouse capabilities\u003c\/li\u003e\n\u003cli\u003eEvaluate warehouse capabilities\u003c\/li\u003e\n\u003cli\u003eEvaluate eventhouse capabilities\u003c\/li\u003e\n\u003cli\u003eCase study: Choose data stores for an integrated analytics solution\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDesign dimensional models for analytics in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eLearn dimensional schema types, fact and dimension table design, and slowly changing dimension patterns for analytics workloads in Microsoft Fabric.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe dimensional schema types\u003c\/li\u003e\n\u003cli\u003eDesign fact tables\u003c\/li\u003e\n\u003cli\u003eDesign dimension tables\u003c\/li\u003e\n\u003cli\u003eImplement slowly changing dimensions\u003c\/li\u003e\n\u003cli\u003eExercise: Design and implement a dimensional model\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eTransform data using Dataflows Gen2 in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eApply low-code transformations using Power Query in Dataflows Gen2 to prepare analytical data for downstream consumption.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUnderstand Dataflows Gen2\u003c\/li\u003e\n\u003cli\u003eTransform data with Power Query\u003c\/li\u003e\n\u003cli\u003eOptimize Dataflows Gen2 performance\u003c\/li\u003e\n\u003cli\u003eExercise: Transform data with Dataflows Gen2\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eTransform data using notebooks in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eUse Fabric notebooks to transform data with Spark SQL and PySpark, connecting to lakehouses, warehouses, and other data stores.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe notebooks in Fabric\u003c\/li\u003e\n\u003cli\u003eShape and clean data\u003c\/li\u003e\n\u003cli\u003eCombine and aggregate data\u003c\/li\u003e\n\u003cli\u003eWrite and size Delta tables\u003c\/li\u003e\n\u003cli\u003eExercise: Transform data with notebooks\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eTransform data using T-SQL in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eUse T-SQL in Microsoft Fabric warehouses to transform and query data, create reusable views and stored procedures, and build dimensional tables.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eTransform data with T-SQL queries\u003c\/li\u003e\n\u003cli\u003eCreate views for reusable logic\u003c\/li\u003e\n\u003cli\u003eBuild stored procedures\u003c\/li\u003e\n\u003cli\u003eImplement dimensional tables\u003c\/li\u003e\n\u003cli\u003eExercise: Transform data with T-SQL\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCreate DAX calculations in semantic models\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eAdding DAX calculations to Power BI semantic models allows you to define custom logic within your data model, enabling deeper analysis and data-driven business decisions.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eCreate calculated tables\u003c\/li\u003e\n\u003cli\u003eCreate calculated columns\u003c\/li\u003e\n\u003cli\u003eUnderstand implicit measures\u003c\/li\u003e\n\u003cli\u003eCreate explicit measures\u003c\/li\u003e\n\u003cli\u003eUse iterator functions\u003c\/li\u003e\n\u003cli\u003eExercise: Create DAX calculations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDesign semantic models for scale in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eDesign semantic models for scale in Microsoft Fabric. Choose the right storage mode, design star schema relationships for clarity and performance, create scalable calculation patterns, and configure settings that support large datasets and concurrent consumption.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eChoose a storage mode\u003c\/li\u003e\n\u003cli\u003eDesign star schema for semantic models\u003c\/li\u003e\n\u003cli\u003eDesign scalable calculations\u003c\/li\u003e\n\u003cli\u003eConfigure settings for scale\u003c\/li\u003e\n\u003cli\u003eExercise: Design a semantic model for scale in Fabric\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eOptimize semantic model performance\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eDiagnose and fix semantic model and report performance issues. Use Performance analyzer to identify bottlenecks, optimize DAX calculations, reduce cardinality, and implement aggregations to improve query speed.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUse Performance analyzer to diagnose issues\u003c\/li\u003e\n\u003cli\u003eOptimize DAX calculations\u003c\/li\u003e\n\u003cli\u003eReduce cardinality for better performance\u003c\/li\u003e\n\u003cli\u003eImplement aggregations\u003c\/li\u003e\n\u003cli\u003eTroubleshoot common performance issues\u003c\/li\u003e\n\u003cli\u003eExercise: Diagnose and fix a slow report\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eEnforce semantic model security\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eImplement row-level security, object-level security, and dynamic security patterns to protect sensitive data in semantic models while enabling appropriate access for different user groups.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eImplement row-level security\u003c\/li\u003e\n\u003cli\u003eApply object-level security\u003c\/li\u003e\n\u003cli\u003eTest security and manage roles\u003c\/li\u003e\n\u003cli\u003eExercise: Implement RLS for a semantic model\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eManage the semantic model development lifecycle\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eManage semantic models through their full development lifecycle. Create reusable assets, version-control with Git, inspect and validate with the XMLA endpoint and SemPy, deploy through pipelines, and maintain with monitoring and impact analysis.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eCreate reusable Power BI assets\u003c\/li\u003e\n\u003cli\u003eManage Power BI content in version control\u003c\/li\u003e\n\u003cli\u003eManage semantic models with the XMLA endpoint\u003c\/li\u003e\n\u003cli\u003eDeploy content through stages\u003c\/li\u003e\n\u003cli\u003eMaintain and monitor semantic models\u003c\/li\u003e\n\u003cli\u003eExercise: Manage semantic models through their lifecycle\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003ePrepare the semantic layer for AI in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eDesign gold layers, semantic models, and documentation that enable Copilot, data agents, and enterprise ontologies to deliver accurate, business-relevant insights.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUnderstand what AI needs from your data\u003c\/li\u003e\n\u003cli\u003eDesign gold layers with AI in mind\u003c\/li\u003e\n\u003cli\u003ePrepare a semantic model for AI\u003c\/li\u003e\n\u003cli\u003eFrom semantic models to enterprise ontology\u003c\/li\u003e\n\u003cli\u003eValidate AI readiness\u003c\/li\u003e\n\u003cli\u003eExercise: Prepare a semantic model for AI\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eUnderstand Microsoft Fabric IQ fundamentals\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eMicrosoft Fabric IQ provides a way to define business vocabulary in an ontology and bind the ontology to data sources. Learn about ontology items, data agents, Graph in Microsoft Fabric, and Power BI semantic models. Discover how ontology modeling differs from traditional analytical modeling by starting with business concepts rather than specific use cases.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eGet started with Fabric IQ\u003c\/li\u003e\n\u003cli\u003eExplore Microsoft Fabric IQ components\u003c\/li\u003e\n\u003cli\u003eUnderstand the ontology modeling paradigm\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCreate an ontology with Fabric IQ\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eOntologies in Fabric IQ transform your data into a business vocabulary that everyone can understand. Learn two ways to create ontologies: building manually to understand the core components, or generating automatically from Power BI semantic models to accelerate development. Practice both approaches and learn how to connect your ontology to data sources in OneLake, including lakehouse tables and eventhouse streams.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eChoose an ontology creation approach\u003c\/li\u003e\n\u003cli\u003eBuild an ontology manually\u003c\/li\u003e\n\u003cli\u003eGenerate an ontology from a Power BI semantic model\u003c\/li\u003e\n\u003cli\u003eConnect an ontology to data\u003c\/li\u003e\n\u003cli\u003eConfigure ontology relationships\u003c\/li\u003e\n\u003cli\u003ePreview the ontology\u003c\/li\u003e\n\u003cli\u003eExercise: Build an ontology manually\u003c\/li\u003e\n\u003cli\u003eExercise: Generate an ontology from a Power BI semantic model\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSecure data access in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eImplement workspace roles, item permissions, and OneLake security roles to control data access in Microsoft Fabric.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUnderstand the Fabric security model\u003c\/li\u003e\n\u003cli\u003eConfigure workspace and item permissions\u003c\/li\u003e\n\u003cli\u003eApply granular permissions\u003c\/li\u003e\n\u003cli\u003eExercise: Secure data access in Microsoft Fabric\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSecure a Microsoft Fabric data warehouse\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eLearn how to protect sensitive data in a Microsoft Fabric warehouse using dynamic data masking, row-level security, column-level security, and SQL granular permissions.\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eExplore dynamic data masking\u003c\/li\u003e\n\u003cli\u003eImplement row-level security\u003c\/li\u003e\n\u003cli\u003eImplement column-level security\u003c\/li\u003e\n\u003cli\u003eConfigure SQL granular permissions using T-SQL\u003c\/li\u003e\n\u003cli\u003eExercise: Secure a warehouse in Microsoft Fabric\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eGovern analytics data in Microsoft Fabric\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eImplement Fabric-native governance practices including data classification, sensitivity labels, endorsement, and documentation. Ensure data assets are trustworthy and governed for both human and AI consumption.\u003c\/p\u003e\n\u003cul\u003e\n\u003cli style=\"list-style-type: none;\"\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eClassify and protect data in Microsoft Fabric\u003c\/li\u003e\n\u003cli\u003eEndorse and document data assets\u003c\/li\u003e\n\u003cli\u003eGovern data for AI consumption\u003c\/li\u003e\n\u003cli\u003eExercise: Govern analytics data in Microsoft Fabric\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul\u003e\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"269A74CN \/ 2026-09-01T09:00:00 \/ Online","offer_id":44748325224584,"sku":"US-8692-IL","price":2080.0,"currency_code":"USD","in_stock":true},{"title":"26AB56US \/ 2026-10-27T09:00:00 \/ Herndon, VA","offer_id":44748325257352,"sku":"US-8692-IL","price":2080.0,"currency_code":"USD","in_stock":true},{"title":"26CA11CN \/ 2026-12-01T09:00:00 \/ Ottawa","offer_id":44748325290120,"sku":"US-8692-IL","price":2080.0,"currency_code":"USD","in_stock":true},{"title":"272B30US \/ 2027-02-02T09:00:00 \/ Herndon, VA","offer_id":44748325355656,"sku":"US-8692-IL","price":2080.0,"currency_code":"USD","in_stock":true},{"title":"273A11CN \/ 2027-03-02T09:00:00 \/ Ottawa","offer_id":44851681230984,"sku":"US-8692-IL","price":2080.0,"currency_code":"USD","in_stock":true},{"title":"275B79US \/ 2027-05-04T09:00:00 \/ Herndon, VA","offer_id":45100012011656,"sku":"US-8692-IL","price":2080.0,"currency_code":"USD","in_stock":true},{"title":"276A14CN \/ 2027-06-01T09:00:00 \/ Ottawa","offer_id":45917605134472,"sku":"US-8692-IL","price":2080.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/kpit.learningtree.com\/products\/microsoft-fabric-analytics-engineer-dp-600","provider":"Learning Tree International","version":"1.0","type":"link"}