PL-200T00 – Microsoft Power Platform Functional Consultant

• Duration: 4 days

The PL-200 course provides a detailed exploration of the Microsoft Power Platform, equipping learners with the skills to leverage its business value for various solutions. The course covers the integration of Power Platform with Microsoft 365, Microsoft Teams, Microsoft Dynamics 365, and Azure services, enhancing productivity through Artificial Intelligence. Learners will delve into Power Pages, Power BI, and Microsoft Dataverse, learning how to create and manage analytics reports, tables, and relationships within Dataverse. Key topics include Power BI service management, workspace and dataset handling, and configuring data protection. The course also emphasizes customization and security in Power Pages, along with creating custom tables, columns, and relationships in Dataverse. Through practical exercises, knowledge checks, and case studies, learners gain comprehensive expertise in managing and optimizing the Power Platform to drive business outcomes.

Describe the business value of the Microsoft Power Platform

• Introduction
• Explore Microsoft Power Platform
• Describe the business value of the Power Platform
• Explore connectors and Microsoft Dataverse
• Describe how Power Platform works with Microsoft 365 apps and services
• Explore how Power Platform works with Microsoft Teams
• Describe how Power Platform works with Microsoft Dynamics 365 apps
• Describe how Power Platform solutions consume Microsoft Azure services
• Explore how Microsoft Power Platform apps work together
• Use Artificial Intelligence to increase productivity
• Knowledge check
• Summary and resources

Get Started with Power Pages

• Introduction to Power Pages
• Get started with Power Pages
• Core tools and components of Power Pages
• Overview of Power Pages security
• Overview of Power Pages extensibility
• Check your knowledge
• Summary

Create and use analytics reports with Power BI

• Introduction
• Use Power BI
• Building blocks of Power BI
• Tour and use the Power BI service
• Knowledge check
• Summary

Manage workspaces and datasets in Power BI

• Introduction
• Distribute a report or dashboard
• Monitor usage and performance
• Recommend a development life cycle strategy
• Troubleshoot data by viewing its lineage
• Configure data protection
• Check your knowledge
• Summary

Create tables in Dataverse

• Introduction to Microsoft Dataverse
• Table characteristics
• Exercise – Create a Microsoft Dataverse table
• Exercise – Import data into your Microsoft Dataverse database
• Table relationships
• Exercise – Create table relationships
• Dataverse logic and security
• Exercise – Create a custom table and import data
• Dataverse auditing
• Dual-write vs. virtual tables
• Check your knowledge
• Summary

Manage tables in Dataverse

• Identify tables and table types in Dataverse
• Create a custom table
• Enable attachments within a table
• Licensing requirements for each table type
• Lab – Create a new custom table and enable attachments
• Check your knowledge
• Summary

Create and manage columns within a table in Dataverse

• Define columns in Microsoft Dataverse
• Column types in Microsoft Dataverse
• Add a column to a table
• Create a primary name column
• Restrictions that apply to columns in a table
• Create an auto numbering column
• Create an alternate key
• Exercises
• Check your knowledge
• Summary

Create a relationship between tables in Dataverse

• Relate one or more tables – Introduction
• Relationship types that are available in Microsoft Dataverse
• Create a one-to-many relationship between tables
• Create a many-to-many relationship between tables
• Edit or delete relationships
• Exercise – Create two tables and relate them by using a one-to-many relationship
• Check your knowledge
• Summary

Working with choices in Dataverse

• Define choice column
• Standard choices column
• Lab – Create a new choice or modify an existing choice
• Check your knowledge
• Summary