Home
PL-200 Microsoft Power Platform Functional Consultant Training

Sessions 3 days
Duration 22.5 hrs
Level Intermediate
Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Download Course Brochure

Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

Take Free Certificate Practice Exams at exams.tertiaryinfotech.com.

You can also purchase Certificate exam vouchers at exams.tertiaryinfotech.com.

PL-200 Microsoft Power Platform Functional Consultant Training

Course Code: C405

Be the first to review this product

Our PL-200 Microsoft Power Platform Functional Consultant Exam Prep course is meticulously designed to provide you with the knowledge, skills, and confidence needed to ace your PL-200 exam. This course covers all the essential topics and provides practical tips and strategies to help you succeed.

With our expert guidance, you will gain a deep understanding of the Microsoft Power Platform and learn how to effectively use it to your advantage. Our course is structured to ensure that you are well-prepared for the exam and can confidently demonstrate your skills and knowledge. Enroll now and take the first step towards becoming a Microsoft Power Platform Functional Consultant.

Microsoft Learning Partner

We are Authorised Microsoft Learning Partner (Org ID: 5238476). To get the official Microsoft certification, please register your certification exam at Pearson Vue Test Center.

Certification Exam at Pearson Vue

We are Authorised Pearson Vue Testing Center. Once you have prepared for the exam, you can register for the certification here. The course fee does not include the certification exam fee.

You can purchase the exam voucher (one of the lowest prices in Singapore) at Microsoft Role-Based Certification Exam Voucher.

No funding is available for this course

For WSQ funding, please checkout the details at WSQ - Microsoft Power Platform Functional Consultant (PL-200)

Course Fee

BTN56,700.00 (GST-exclusive)

BTN61,803.00 (GST-inclusive)

Include Exam Voucher *

No
Yes +BTN12,600.00

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Course Time * Course Time

9:30am - 5:30pm

No. of Participants

Sponsorship

Self-Sponsored
Organization Sponsored

Name(s) on Certificate *

Additional Message or Emails for Course Notification

* Required Fields

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

We provide free consultation related to the subject matter after the course.
Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Topic 1 Describe the business value of the Microsoft Power Platform

Explore Microsoft Power Platform
Describe the business value of the Power Platform
Explore connectors and Microsoft Dataverse
Use Artificial Intelligence to increase productivity
Explore the business value of the Power Fx
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
Explore how Microsoft Power Platform apps work together
Describe how Power Platform solutions consume Microsoft Azure services

Topic 2 Identify foundational components of Microsoft Power Platform

Describe Power Platform administration
Describe Power Platform security and governance
Explore Microsoft Dataverse
Examine Power Platform connectors
Exercise - Build a basic Dataverse data model

Topic 3 Create and manage environments in Dataverse

Environments in Microsoft Dataverse
Developer environments
Create and manage an environment
Create an instance of a Microsoft Dataverse database
Add users and roles within an environment
Manage settings in an environment
Environment operations

Topic 4 Create tables in Dataverse

Introduction to Microsoft Dataverse
Table characteristics
Dataverse logic and security
Dataverse auditing
Dual-write vs. virtual tables

Topic 5 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
Primary name column
Restrictions that apply to columns in a table
Create an auto numbering column
Create an alternate key

Topic 6 Working with choices in Dataverse

Define choice column
Choice columns
Standard choices column

Topic 7 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

Topic 8 Create and define calculation or rollup columns in Dataverse

Introduction to roll up columns
Create a rollup column
Introduction to calculated columns
Create a calculation column
Introduction to Power Fx formula columns

Topic 9 Load/export data and create data views in Dataverse

View data in a table
Create or edit views of data in a table
Dataverse data import options
Load data into a table
Dataverse data export options
Export
Add, update, or delete data in a table by using Excel
Import data using Power Query

Topic 10 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

Topic 11 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
Dataverse Search
Auditing
Duplicate detection
Bulk delete
Long term data retention

Topic 12 How to build your first model-driven app with Dataverse

Introduction to Dataverse
Introduction to model-driven apps
Model-driven apps, powered by Microsoft Dataverse
Explore sample apps

Topic 13 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

Topic 14 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
Create and edit views
Configure charts overview
Dashboards overview
Use interactive streams and tiles

Topic 15 Use specialized components in a model-driven form

Create business process flows
Embed a canvas app in a model-driven form
Add a timeline in a model-driven form
Create a report in a model-driven form

Topic 16 Customize the command bar

Create or edit modern commands
Work with classic commands
Use Power Fx

Topic 17 Get started with Power Apps canvas apps

Introduction to Power Apps
Start Power Apps
Power Apps data sources
Use Power Apps with Power Automate and Power BI
Designing a Power Apps app

Topic 18 Customize a canvas app in Power Apps

Improve your app by making basic customizations
Explore controls and screens in canvas apps

Topic 19 Navigation in a canvas app in Power Apps

Understanding navigation
The Navigate and Back functions
More ways to use the Navigate function

Topic 20 Create formulas to change behaviors in a Power Apps canvas app

Formulas and functionality
Understanding true and false
Understanding control behaviors and actions
Performing multiple actions in a formula
Control the display mode through a formula
Use controls and functions to create a dynamic formula

Topic 21 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

Topic 22 Introduction to Power Apps cards

Design Power Apps cards
Send Power Apps cards

Topic 23 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

Topic 24 Access Dataverse in Power Pages websites

Use lists to display multiple Dataverse records
Use forms to interact with Dataverse data

Topic 25 Explore Power Pages design studio

Get Started with Power Pages
Work with Power Pages websites
Introduction to Power Pages design studio
Work with pages
Page components
Site styling and templates

Topic 26 Integrate Power Pages websites with Dataverse

Basic form configuration
Multistep form processes
Set up multistep forms
Extend lists and forms

Topic 27 Integrate Power Pages with web-based technologies

Document management with SharePoint in Power Pages
Integration with Power BI in Power Pages
Model-driven charts in Power Pages

Topic 28 Explore Power Pages design studio data and security features

Introduction into Power Pages design studio data and security features
Data workspace in Power Pages design studio
Power Pages security features

Topic 29 Set up Power Pages security

Secure static content
Table permissions

Topic 30 Authentication and user management in Power Pages

Power Pages authentication settings
User registration in Power Pages
Authentication management for Power Pages users
Power Pages authentication providers

Topic 31 Best practices for error handling in Power Automate flows

Configure run after option
Power Automate analytics

Topic 32 Use Dataverse triggers and actions in Power Automate

Dataverse triggers
Query data
Create, update, delete, and relate actions

Topi 33 Introduction to expressions in Power Automate

Get started with expressions
Notes make things easier
Types of functions
Write complex expressions

Topic 34 Define and create business rules in Dataverse

Define business rules - Introduction
Define the components of a business rule
Create a business rule

Topic 35 Set up low-code plug-ins

Low-code plug-ins
Create a low-code plug-in
Instant plug-ins
Automated plug-ins

Topic 36 Use common low-code plug-in scenarios

Use Power Fx with plug-ins
Implement data validation
Data manipulation
Use connectors in plug-in logic
Use instant plug-ins from Power Apps
Use instant plug-ins from Power Automate

Topic 37 Get started building with Power BI

Use Power BI
Building blocks of Power BI
Tour and use the Power BI service

Topic 38 Introduction to solutions for Microsoft Power Platform

Solution layering
Solution architecture tools and techniques

Topic 39 Use Microsoft 365 services with model-driven apps and Microsoft Dataverse

Set up mailboxes
Server-side sync
Document management options
Document management
Deploy the app for Outlook
Set up Dynamics 365 App for Outlook
Integrate with Microsoft Teams

Topic 40 Use Microsoft Word and Excel templates with Dataverse

Create a dynamic Word template
Create a dynamic Excel template

Practice Exam

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

Able to operate using computer functions
Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

Positive Learning Attitude
Enthusiastic Learner

Experience

Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

TBD

Hardware: Window or Mac Laptops

Job Roles

Power Platform Developer
Software Developer
Application Developer
Systems Analyst
Data Analyst
Business Intelligence Developer
IT Consultant
Solutions Architect
Database Developer
CRM Developer
Cloud Developer
Full Stack Developer
Mobile App Developer
Front End Developer
Back End Developer

Trainers

Sanjiv Venkatram: Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team. Alan Tan: Alan Tan is a ACTA certified trainer. Alan Tan hold Masters in Data Science in Singapore University of Technology and Design. He is Microsoft Power Platform PL-900 certified and Microsoft Azure Data Fundamentals Certified DP-900. He have this skills in Microsoft Power Platform development skills such as Powerapps, Power Automate,Power Portal, Power Virtual Agent, Power BI, Sharepoint, Dataverse, etc. For Programming language such as Python and Robotics Process Automation (RPA) development. He is working as a Senior Data Engineer in an MNC.