PL-200T00 – Microsoft Power Platform Functional Consultant

• Duration: 10 weeks

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