COR 745 - Microsoft Fabric Analytics Engineer
Course Description
Learn the comprehensive capabilities of Microsoft Fabric in this course designed for IT professionals and data analysts. Microsoft Fabric is a cutting-edge end-to-end analytics and data platform tailored for enterprise-level integration and efficiency. This course dives deep into Fabric's unified solution approach, covering essential components such as data movement, processing, ingestion, transformation, real-time event routing, and report generation.
You will gain hands-on experience with Fabric components, including lakehouses, data warehouses, notebooks, dataflows, data pipelines, and semantic models, to create and deploy analytics assets. This course is best suited for those who have completed DAT 350 Microsoft Power BI Data Analyst, or similar expertise in using Power BI for data transformation, modeling, visualization, and sharing.
This course covers the objectives for Microsoft Exam DP-600: Microsoft Fabric Analytics Engineer. The University of Calgary is a Microsoft Education Global Training Partner
Course Details
Upon completing this course, successful students will be able to:• Plan, implement, and manage a solution for data analytics with Microsoft Fabric
• Prepare and serve data in a lakehouse or warehouse
• Implement and manage semantic models in Microsoft Fabric
• Explore and analyze data
Topics
• Implement a Lakehouse with Microsoft Fabric
- Use Apache Spark
- Work with Delta Lake tables
- Use Data Factory pipelines
- Organize a Fabric lakehouse using medallion architecture design
- Ingest Data with Dataflows Gen2 in Microsoft Fabric
- Ingest Data with Spark and Microsoft Fabric notebooks
- Use Data Factory pipelines in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
- Query a data warehouse in Microsoft Fabric
- Monitor a Microsoft Fabric data warehouse
- Secure a Microsoft Fabric data warehouse
- Understand Scalability in Power BI
- Create Power BI model relationships
- Use tools to optimize Power BI Performance
- Enforce Power BI model security
This course includes hands-on activities to reinforce the concepts taught and provide a practical learning experience.
Lab access will be provided at no additional cost.