Microsoft Fabric Analytics Engineer Training

Duration

Skills Gained

• Describe end-to-end analytics in Microsoft Fabric
• Configure features and manage access to suit your organization's needs
• Use Microsoft Fabric's Data FactoryDataflows to visually create multi-step data ingestion and transformation using Power Query Online
• Use Apache Spark and Python for data ingestion into a Microsoft Fabric lakehouse
• Create pipelines that orchestrate data ingestion and transformation tasks
• Describe core features and capabilities of lakehouses in Microsoft Fabric
• Query lakehouse tables with SQL
• Organize and transform your data across Bronze, Silver, and Gold layers of a lakehouse for optimized analytics
• Configure Spark in a Microsoft Fabric workspace
• Understand Delta Lake and delta tables in Microsoft Fabric
• Create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution
• Use advanced query processing and full transactional T-SQL capabilities for easy data management and analysis
• Monitor a data warehouse to understand the activity that occurs in it
• Implement Power BI data modeling best practices
• Use the Power BI large dataset storage format
• Define Power BI model relationships, set up relationships, recognize DAX relationship functions, and describe relationship evaluation.
• Use tools to develop, manage, and optimize Power BI data model and DAX query performance
• Enforce model security in Power BI using row-level security and object-level security

Prerequisites

Target Audience