Microsoft Certified: Power Platform Functional Consultant Associate (PL200)
In this five-day Microsoft certified course, students will learn to perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Power Platform solutions and apps. They will supplement their learnings with hands-on labs to create application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations. Power Platform is comprised of four key products: Power Apps, Power Automate, Power BI, and Power Virtual Agents. In this course, we will cover these four applications in depth, with additional focus on Microsoft Dataverse (formerly Common Data Service), AI Builder, connectors, and portals.
This training is a comprehensive preparation for the PL-200: Microsoft Power Platform Functional Consultant exam to earn the Microsoft Certified: Power Platform Functional Consultant Associate certification.
Public class
2875$
Duration:
4 days / 28 hours
Private class
On site / Virtual classroom
Minimum no. of participants: 5
4 days/ 28 hours
Price on request
English or French
Training plan:
Microsoft Power Platform Functional Consultant (PL-200T00)
Module 1: Introduction to Microsoft Power Platform
- What is Microsoft Power Platform?
- The business value of Microsoft Power Platform
- Data Connectors
- Data loss prevention, compliance, privacy, and accessibility
- Pulling it all together
Module 2: Create tables in Dataverse
- Table characteristics
- Dual-write vs. virtual tables
- Dataverse auditing
- Import data into your Microsoft Dataverse database
Module 3: 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
Module 4: 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
Module 5: 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
Module 6: Working with choices in Dataverse
- Define choice column
- Standard choices column
Module 7: Get started with security roles in Dataverse
- Introduction to environment roles
- Understand environment roles
- Adding or disabling an environment user
- Understand security concepts in Dataverse
- Understand user security roles and security role defaults
- Check the roles that a user belongs to
- Configure Dataverse teams for security
- Configure Dataverse group teams for security
Module 8: Use administration options for Dataverse
- Introduction to Microsoft Power Platform Admin Center portal
- Use Microsoft Power Platform Admin Center portal
- Tenant storage capacity
- Advanced Customization options in Power Apps Portal
- Enable and disable auditing
Module 9: Manage Dynamics 365 model-driven app settings and security
- Configure role-based security
- Manage teams and business units
- Explore settings and customizations
Module 10: Introduction to Microsoft Power Platform security and governance
- Identify Microsoft Power Platform environments
- Data Loss Prevention policies
- Microsoft Power Platform Center of Excellence Starter Kit
Module 11: Get started with model-driven apps in Power Apps
- Introducing model-driven apps
- Components of model-driven apps
- Design model-driven apps
- Incorporate business process flows
Module 12: Configure forms, charts, and dashboards in model-driven apps
- Forms overview
- Form elements
- Configure multiple forms
- Use specialized form components
- Configure views overview
- Configure grids
- Use specialty views
- Configure charts overview
- Dashboards overview
- Use interactive streams and tiles
Module 13: Get started with Power Apps canvas apps
- Introduction to Power Apps
- Power Apps building blocks
- Ways to build Power Apps
- Power Apps related technologies
- Additional Power Apps related technologies
- Designing a Power Apps app
Module 14: Connect to other data in a Power Apps canvas app
- Overview of the different data sources
- Work with action-based data sources
- Power Automate is a companion to Power Apps
Module 15: Manage apps in Power Apps
- Power Apps review
Module 16: Build your first app with Power Apps and Dataverse for Teams
- Create your first app with the hero template
- Customize your app with Power Apps Studio
- Publish your app
- Install template apps
Module 17: Core components of 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
Module 18: Explore Power Pages templates
- Introduction to site templates in Power Pages
- Site design templates
- Scenario-based templates
- Dynamics 365 Power Pages site templates
Module 19: Access Dataverse in Power Apps portals
- Use table lists to display multiple Microsoft Dataverse records
- Use table forms to interact with Microsoft Dataverse data
Module 20: Authentication and user management in Power Apps portals
- Power Apps portals authentication settings
- User registration in Power Apps portals
- Portal user authentication management
- Power Apps portals authentication providers
Module 21: Power Apps portals maintenance and troubleshooting
- Portal maintenance
Module 22: Define and create business rules in Dataverse
- Define business rules - Introduction
- Define the components of a business rule
- Create a business rule
Module 23: Get started with Power Automate
- Introducing Power Automate
- Troubleshoot flows
Module 24: Use the Admin center to manage environments and data policies in Power Automate
- Administer flows
- Export and import flows
- Learn how to distribute button flows
Module 25: Use Dataverse triggers and actions in Power Automate
- Dataverse triggers
- Use triggers
- Work with Dataverse actions
Module 26: Extend Dataverse with Power Automate
- Set up a flow and configure its trigger
- Email Dataverse record
- Add to-do items
- Test and run your flow
Module 27: Introduction to expressions in Power Automate
- Introduction to expressions
- Get started with expressions
- Notes make things easier
- Types of functions
- Write complex expressions
Module 28: Build your first Power Automate for desktop flow
- Set up the environment
- Explore Power Automate for desktop
- Create your first Power Automate for desktop flow
- Record Power Automate for desktop actions
- Edit and test recorded actions
Module 29: Run a Power Automate for desktop flow in unattended mode
- Set up an unattended desktop flow
- Create a new cloud flow that calls an existing flow in unattended mode
- Perform a test run
- Best practices
Module 30: Optimize your business process with process advisor
- Get familiar with process advisor
- Create your first recording
- Edit recordings and group actions
- Analyze recordings and interpret results
- Automation recommendations
Module 31: Get started with Power Virtual Agents bots
- Get started working with environments
- Create bots and work with the Power Virtual Agents interface
- Create topics
- Test bots
- Publish bots and analyze performance
Module 32: Enhance Power Virtual Agents bots
- Use Power Automate to add actions
- Transfer conversations to agents by using Omnichannel for Customer Service
- Create topics for existing support content
- Analyze bot performance
Module 33: Manage topics in Power Virtual Agents
- Work with bot topics
- Branch a topic
- System topics
- Create topics for existing support content
- Work with system fallback topics
- Manage topics
Module 34: Manage Power Virtual Agents
- Environments in Power Virtual Agents
- Bot topics permissions
- Bot entities and flow permissions
- Monitor and diagnose
- Administer and manage
- Export and import bots
- Authentication
Module 35: Get started building with Power BI
- Use Power BI
- Building blocks of Power BI
- Tour and use the Power BI service
Module 36: Get data with Power BI Desktop
- Overview of Power BI Desktop
- Explore Power BI Desktop
- Connect to data sources
- Get data from Excel
- Transform data to include in a report
- Combine data from multiple sources
- Clean data to include in a report
Module 37: Model data in Power BI
- Introduction to modeling your data
- How to manage your data relationships
- Create calculated columns
- Optimize data models
- Create measures
- Create calculated tables
- Explore time-based data
Module 38: Use visuals in Power BI
- Introduction to visuals in Power BI
- Create and customize simple visualizations
- Create slicers
- Map visualizations
- Matrices and tables
- Create scatter, waterfall, and funnel charts
- Modify colors in charts and visuals
- Page layout and formatting
Module 39: Explore data in Power BI
- Introduction to the Power BI service
- Quick insights in Power BI
- Create and configure a dashboard
- Ask questions of your data with natural language
- Create custom Q&A suggestions
- Share dashboards with your organization
- Display visuals and tiles in full screen
- Edit tile details and add widgets
- Get more space on your dashboard
Module 40: Publish and share in Power BI
- Introduction to using workspaces
- Publish Power BI Desktop reports
- Print and export dashboards and reports
- Introducing Power BI Mobile
- Create workspaces in Power BI
- Build apps
- Use apps
- Integrate OneDrive for Business with Power BI
- Publish to web
Module 41: Manage solutions in Power Apps and Power Automate
- Add and remove apps, flows, and entities in a solution
- Edit a solution-aware app, flow, and table
- Build and deploy a complex solution with flows, apps, and entities
- Automate solution management
Module 42: Load/export data and create data views in Dataverse
- View data in a table
- Create or edit views of data in a table
- Load data into a table
- Export data from a table
- Add, update, or delete data in a table by using Excel
- Import data using Power Query
- Generate a new dataflow from an Excel Template
- Dataflow and Azure integration
Module 43: Get started with AI Builder
- Introduction to AI Builder
- Choose an AI capability
- Create your first model
- Ways to use your models
Module 44: Manage models in AI Builder
- Model lifecycle
- Manage model versions
- Share your models
Module 45: Use AI Builder in Power Automate
- Introduction to AI Builder usage in Power Automate
- AI Builder in Power Automate saves time
- Advanced usage of AI Builder in Power Automate
Module 46: Functional Consultant skills
- Create entity relationship diagrams
- Create and document mock-ups
- Document functional requirements and artifacts
- Complete fit-gap analysis
- Discuss stakeholder management responsibilities
- Understand industry accelerators
- Define Application Lifecycle Management
- Participate in testing
- Evaluate options
- Define connectors
- Understand Power Apps component framework
Exclusives:
- One FREE attendance to the Microsoft 365 Certified: Fundamentals (MS900) training
- One year access to the class recording
- 180 days access to the lab environment after class
- One voucher to take the exam
- Up to date courseware with Microsoft Learn
- Microsoft course achievement badge
Prerequisites:
- Experience as an IT professional or student
- Working knowledge of the Power Platform and its key components
- A knowledge of Microsoft Dataverse (or general data modeling) and security concepts
Certification information:
Exam characteristics:
- Exam code: PL-200
- Cost: $0 (included in your training)
- Skills measured
- Configure Microsoft Dataverse
- Create apps by using Power Apps
- Create and manage Power Automate
- Implement Power Virtual Agents chatbots
- Integrate Power Apps with other apps and services
- All details...
Follow-on trainings:
Audiences:
Contact us for more information on pricing::
Eccentrix
Office: 1-888-718-9732
E-mail: info@eccentrix.ca
130, King Street West, Suite 1800
Toronto, Ontario M5X 1E3
www.eccentrix.ca