dp-600

Plan, implement, and manage a solution for data analytics (10–15%)

Plan a data analytics environment

• Identify requirements for a solution, including components, features, performance, and capacity stock-keeping units (SKUs)

  • Microsoft Fabric concepts and licenses
  • Power BI guidance documentation
  • Power BI Embedded with Microsoft Fabric

• Recommend settings in the Fabric admin portal

  • Microsoft Fabric documentation for admins

• Choose a data gateway type

  • What is an on-premises data gateway?
  • Guidance for deploying a data gateway for the Power BI service
  • On-premises data gateway in-depth
  • Manage on-premises data gateway high-availability clusters and load balancing
  • Manage security roles of an on-premises data gateway
  • Add or remove a gateway data source
  • Manage your data source - import and scheduled refresh
  • Use custom data connectors with an on-premises data gateway
  • Plan, scale, and maintain a business-critical gateway solution
  • On-premises data gateway sizing
  • What is a virtual network (VNet) data gateway (Preview)?
  • Virtual network data gateway architecture

• Create a custom Power BI report theme

  • Use report themes in Power BI Desktop

Implement and manage a data analytics environment

• Implement workspace and item-level access controls for Fabric items

  • Roles in workspaces in Microsoft Fabric
  • Give users access to workspaces
  • Share items in Microsoft Fabric

• Implement data sharing for workspaces, warehouses, and lakehouses

  • Workspaces
    • Share Power BI reports and dashboards with coworkers and others
    • Display the dashboards and reports that others have shared with me
    • Request or grant access to shared dashboards or reports
    • Share a filtered Power BI report
    • Troubleshoot issues sharing dashboards and reports
    • Filter a report using query string parameters in the URL
    • Ways to collaborate and share in Power BI
    • View Power BI files in OneDrive and SharePoint
  • Lakehouses
    • How lakehouse sharing works
    • OneLake security
    • Get started securing your data in OneLake
  • Warehouses
    • Workspace roles in Fabric data warehousing
    • Security for data warehousing in Microsoft Fabric
    • Share your warehouse and manage permissions
    • SQL granular permissions in Microsoft Fabric
    • Column-level security in Fabric data warehousing
    • Row-level security in Fabric data warehousing
  • Best practices
    • Power BI implementation planning: Report consumer security planning
    • Power BI implementation planning: Content creator security planning
    • Distribute Power BI content to external guest users using Microsoft Entra B2B
    • Power BI usage scenarios

• Manage sensitivity labels in semantic models and lakehouses

  • Power BI implementation planning: Information protection for Power BI
  • Information protection in Microsoft Fabric
  • Sensitivity labels in Power BI
  • Enable sensitivity labels in Fabric
  • How to apply sensitivity labels in Power BI
  • Sensitivity label downstream inheritance
  • Audit schema for sensitivity labels in Power BI
  • Data protection metrics report

• Configure Fabric-enabled workspace settings

  • Create, configure, and use an environment in Microsoft Fabric
  • Spark workspace administration settings in Microsoft Fabric
  • Configuring starter pools in Microsoft Fabric
  • Billing and utilization reporting for Spark in Microsoft Fabric
  • How to create custom Spark pools in Microsoft Fabric
  • Configure high concurrency mode for Fabric notebooks

• Manage Fabric capacity

  • Microsoft Fabric concepts and licenses
  • Buy a Microsoft Fabric subscription
  • Pause and resume your capacity
  • Scale your capacity
  • The Fabric throttling policy
  • Microsoft Fabric Capacity Metrics app
  • Microsoft Fabric trial
  • Configure and manage data engineering and data science settings for Fabric capacities

Manage the analytics development lifecycle

• Implement version control for a workspace

  • Lifecycle management documentation in Microsoft Fabric
  • Lakehouse deployment pipelines and git integration (Preview)

• Create and manage a Power BI Desktop project (.pbip)

  • Power BI Desktop projects
  • Power BI Desktop project dataset folder
  • Power BI Desktop project report folder
  • Power BI Desktop projects Git integration
  • Power BI Desktop projects Azure DevOps integration
  • Power BI Project (PBIP) and Azure DevOps build pipelines for continuous integration

• Plan and implement deployment solutions

  • Introduction to deployment pipelines
  • The deployment pipelines process
  • Create deployment rules
  • Automate your deployment pipeline by using APIs and Azure DevOps

• Perform impact analysis of downstream dependencies from lakehouses, data warehouses, dataflows, and semantic models

  • Data lineage
  • Semantic model impact analysis
  • Data source impact analysis

• Deploy and manage semantic models by using the XMLA endpoint

  • Power BI usage scenarios: Advanced data model management
  • Semantic model connectivity with the XMLA endpoint
  • Troubleshoot XMLA endpoint connectivity
  • Create perspectives
  • ALM Toolkit

• Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models

  • Create and use report templates in Power BI Desktop
  • Use PBIDS files to get data
  • Use semantic models across workspaces
  • Semantic model description
  • Share access to a semantic model
  • Semantic model permissions
  • Manage semantic model access permissions
  • Build permission for shared semantic models
  • Create reports based on semantic models from different workspaces
  • Copy reports from other workspaces
  • Control the use of semantic models across workspaces
  • Endorse your content