Microsoft Power Platform Functional Consultant Associate (PL-200)
Level: Intermediate
Course Overview
Course Overview
This course is designed for delegates who are planning to take the corresponding Functional Consultant Certification Exam, or delegates who are performing Functional Consultant tasks in their daily jobs.
This course looks in-depth at the Power Platform including Dataverse, Power Apps, Power Automate, Power BI and Power Virtual Agents.
Prerequisites
Experience as an IT professional
Working knowledge of Microsoft Power Platform and its key components
General knowledge of data modelling and security concepts.
Target audience
Professionals with experience in Power Apps, Power Automate, Power BI, Power Virtual Agents, and Dataverse who aim to deepen their skills in these areas.
IT professionals looking to take the Microsoft Functional Consultant Certification Exam.
Those performing Functional Consultant tasks, including configuring solutions and apps within the Power Platform.
Delegates will learn how to:
Configure Microsoft Power Platform Solutions and Apps.
Work with and manage the Dataverse.
Create apps (model-driven and Canvas apps).
Discover how to create portals using Power Pages,
Build processes using Power Automate.
Build Chatbots using Power Virtual Agents.
Create reports and Dashboards using Power BI.
Discuss solution management and integrations.
This course is designed for delegates who are planning to take the corresponding Functional Consultant Certification Exam, or delegates who are performing Functional Consultant tasks in their daily jobs.
This course looks in-depth at the Power Platform including Dataverse, Power Apps, Power Automate, Power BI and Power Virtual Agents.
Prerequisites
Experience as an IT professional
Working knowledge of Microsoft Power Platform and its key components
General knowledge of data modelling and security concepts.
Target audience
Professionals with experience in Power Apps, Power Automate, Power BI, Power Virtual Agents, and Dataverse who aim to deepen their skills in these areas.
IT professionals looking to take the Microsoft Functional Consultant Certification Exam.
Those performing Functional Consultant tasks, including configuring solutions and apps within the Power Platform.
Delegates will learn how to:
Configure Microsoft Power Platform Solutions and Apps.
Work with and manage the Dataverse.
Create apps (model-driven and Canvas apps).
Discover how to create portals using Power Pages,
Build processes using Power Automate.
Build Chatbots using Power Virtual Agents.
Create reports and Dashboards using Power BI.
Discuss solution management and integrations.
Microsoft Certified: Power Platform Functional Consultant Associate (PL-200)
Learning Path 1: Work with Microsoft Dataverse
What is a relational database?
Introduction to Microsoft Dataverse
Manage Environments
Manage customisations with solutions
Create and manage tables in Microsoft Dataverse
Create and manage columns in Microsoft Dataverse
Create relationships between tables
Create and define calculated and rollup columns in Microsoft Dataverse
Learning Path 2: Manage Microsoft Dataverse
Define and create Business Rules
Load/export data in Microsoft Dataverse
Manage security in Microsoft Dataverse
Administration options in Microsoft Dataverse
Learning Path 3: Create a Model-driven app in Power Apps
Introduction to model-driven apps
Design and create model-driven apps
Configure forms
Configure views
Configure charts & Dashboards
Learning Path 4: Create Canvas apps in Power Apps
Introduction to Canvas apps
Customise a Canvas app
Build the UI in a Canvas app
Navigation in Canvas app
Manage apps
Build a mobile-optimised app
Connect to other data in Canvas apps
Learning Path 5: Make portals in Power Pages
Introduction to Power Pages
Core components and features
Portals architecture
Explore design studio
Learning Path 6: Build automation with Power Automate
Introduction to automation in Dataverse
Introduction to Power Automate
Create Power Automate Cloud Flows
Use Dataverse triggers and actions in Power Automate cloud flows
Introduction to expressions in Power Automate
Test and troubleshoot Power Automate cloud flows
Administer Power Automate cloud flows
Create Business Process Flows
Learning Path 7: Build chatbots with Power Virtual Agents
Identify use cases for Power Virtual Agents
Identify components of Power Virtual Agents
Build Chatbots
Learning Path 8: Visualise data with Power BI
Introduction to analysing data with Power BI
Consume Power BI in Power Platform
Learning Path 9: Solutions and Integrations
Application Lifecycle Management
Interoperability with other services
Additional workshop to consolidate knowledge if time permits
Microsoft Certified: Power Platform Functional Consultant Associate (PL-200)
Learning Path 1: Work with Microsoft Dataverse
What is a relational database?
Introduction to Microsoft Dataverse
Manage Environments
Manage customisations with solutions
Create and manage tables in Microsoft Dataverse
Create and manage columns in Microsoft Dataverse
Create relationships between tables
Create and define calculated and rollup columns in Microsoft Dataverse
Learning Path 2: Manage Microsoft Dataverse
Define and create Business Rules
Load/export data in Microsoft Dataverse
Manage security in Microsoft Dataverse
Administration options in Microsoft Dataverse
Learning Path 3: Create a Model-driven app in Power Apps
Introduction to model-driven apps
Design and create model-driven apps
Configure forms
Configure views
Configure charts & Dashboards
Learning Path 4: Create Canvas apps in Power Apps
Introduction to Canvas apps
Customise a Canvas app
Build the UI in a Canvas app
Navigation in Canvas app
Manage apps
Build a mobile-optimised app
Connect to other data in Canvas apps
Learning Path 5: Make portals in Power Pages
Introduction to Power Pages
Core components and features
Portals architecture
Explore design studio
Learning Path 6: Build automation with Power Automate
Introduction to automation in Dataverse
Introduction to Power Automate
Create Power Automate Cloud Flows
Use Dataverse triggers and actions in Power Automate cloud flows
Introduction to expressions in Power Automate
Test and troubleshoot Power Automate cloud flows
Administer Power Automate cloud flows
Create Business Process Flows
Learning Path 7: Build chatbots with Power Virtual Agents
Identify use cases for Power Virtual Agents
Identify components of Power Virtual Agents
Build Chatbots
Learning Path 8: Visualise data with Power BI
Introduction to analysing data with Power BI
Consume Power BI in Power Platform
Learning Path 9: Solutions and Integrations
Application Lifecycle Management
Interoperability with other services
Additional workshop to consolidate knowledge if time permits
Power Platform Functional Consultant Associate (PL-200)
- Exam time: 100 minutes
- Multiple-choice style: 40-60 questions
- Pass mark: 700 (on a scale of 100-1000)
- Closed-book exam (i.e. no reference materials are allowed during the exam)
Power Platform Functional Consultant Associate (PL-200)
- Exam time: 100 minutes
- Multiple-choice style: 40-60 questions
- Pass mark: 700 (on a scale of 100-1000)
- Closed-book exam (i.e. no reference materials are allowed during the exam)
- 5-days training and exam preparation from NILC’s accredited Microsoft trainer
- Microsoft official course materials and labs
- Microsoft examination voucher – valid for 12 months (funding conditions may apply)
- Exam Pass Guarantee – if you do not pass the exam after attending this training course with us, you will be eligible to attend the same training again for free. All that will be payable is the examination fee which is charged by the examination board. Applies to instructor-led courses only
- 5-days training and exam preparation from NILC’s accredited Microsoft trainer
- Microsoft official course materials and labs
- Microsoft examination voucher – valid for 12 months (funding conditions may apply)
- Exam Pass Guarantee – if you do not pass the exam after attending this training course with us, you will be eligible to attend the same training again for free. All that will be payable is the examination fee which is charged by the examination board. Applies to instructor-led courses only
How do I take my Microsoft exam?
You can take a Microsoft certification exam either online or in-person at a Person VUE test center.
Which Microsoft Azure course should I take?
The best Microsoft Azure certification for you depends on your career goals and experience level. Here are a few of the most popular Microsoft Azure certifications: Microsoft Certified: Azure Fundamentals (AZ-900): This is a foundational certification that covers the basics of Microsoft Azure. It is a good starting point for anyone who wants to learn about Azure, including IT professionals, business decision-makers, and students. Microsoft Certified: Azure Administrator Associate (AZ-104): This certification covers the skills and knowledge required to administer Microsoft Azure. It is a good choice for IT professionals who want to manage Azure resources, such as virtual machines, storage, and networking. Microsoft Certified: Azure Developer Associate (AZ-204): This certification covers the skills and knowledge required to develop applications on Microsoft Azure. It is a good choice for developers who want to build and deploy applications on Azure. If you are new to Azure, we recommend starting with the AZ-900 certification. Once you have passed the AZ-900 certification, you can then choose a certification that is aligned with your career goals.
What is Microsoft Azure?
Microsoft Azure is a cloud computing platform that offers a broad range of services, including computing, storage, networking, databases, analytics, machine learning, and artificial intelligence. Azure can be used to build, deploy, and manage applications and services.
How do I take my Microsoft exam?
You can take a Microsoft certification exam either online or in-person at a Person VUE test center.
Which Microsoft Azure course should I take?
The best Microsoft Azure certification for you depends on your career goals and experience level. Here are a few of the most popular Microsoft Azure certifications: Microsoft Certified: Azure Fundamentals (AZ-900): This is a foundational certification that covers the basics of Microsoft Azure. It is a good starting point for anyone who wants to learn about Azure, including IT professionals, business decision-makers, and students. Microsoft Certified: Azure Administrator Associate (AZ-104): This certification covers the skills and knowledge required to administer Microsoft Azure. It is a good choice for IT professionals who want to manage Azure resources, such as virtual machines, storage, and networking. Microsoft Certified: Azure Developer Associate (AZ-204): This certification covers the skills and knowledge required to develop applications on Microsoft Azure. It is a good choice for developers who want to build and deploy applications on Azure. If you are new to Azure, we recommend starting with the AZ-900 certification. Once you have passed the AZ-900 certification, you can then choose a certification that is aligned with your career goals.
What is Microsoft Azure?
Microsoft Azure is a cloud computing platform that offers a broad range of services, including computing, storage, networking, databases, analytics, machine learning, and artificial intelligence. Azure can be used to build, deploy, and manage applications and services.
Dates & Prices
No upcoming dates available.
Send course enquiryCan't find the course dates, location or delivery type you are looking for?
Fill out the request dates form above and we'll try our best to accommodate or contact us directly.
"*" indicates required fields
How we deliver our courses
Virtual
Our virtual courses allow you to access live instructor-led training from the same expert instructors that deliver our classroom courses, without leaving the comfort of your home or office. All virtual courses are fully interactive, and learners can communicate with their trainer and peers at any time.
Many of our virtual courses are also recorded, so you can recap over the content you learnt as many time as you wish.
Classroom
Our classroom courses allow you to learn and interact face-to-face with our expert instructors in a comfortable and modern training environment. All of our classroom based courses take place at NILC centers, or high quality training facilities, and include all required IT and physical equipment.
We also limit our class sizes to help promote better discussions and to ensure your learning experience is comfortable as possible.
Onsite
Save time and hassle by arranging for one of our expert instructors to come to you. Our onsite courses allow you to learn in a location of your choosing, and you can train as many or as few people as you want – from a single person or team to whole departments. We can also fully customize the course content to the specific requirements of your business or project.
We offer onsite courses throughout the UK and it can be a great team building opportunity for colleagues to come together, bond and discuss.
Online
Our Online Self Paced courses allow you to learn new skills from our expert instructors, in your own time and at your own pace. Our flexible online learning platform allows you to access content on your computer, tablet or mobile device, whether you’re on the move or at home. All our online courses come with immediate access and you can start learning straight away, from any internet enabled compatible device.
We also offer online email support from our expert instructors, so they’re always on hand and happy to help you with any questions which may arise.
Why choose NILC for your training?
Award-Winning Training with Industry-Leading Customer Satisfaction
Trusted Training Partner by Colleges, Government Organisations and Businesses
UK-Based Trainers with Real-World Industry Experience
Family-Run Business with Customer Service at Its Core
Rated Excellent on Trustpilot with 950+ Customer Reviews
Our learners rate us 'Excellent' on Trustpilot
Microsoft Technical FAQ's
You can take a Microsoft certification exam either online or in-person at a Person VUE test center.
The best Microsoft Azure certification for you depends on your career goals and experience level. Here are a few of the most popular Microsoft Azure certifications: Microsoft Certified: Azure Fundamentals (AZ-900): This is a foundational certification that covers the basics of Microsoft Azure. It is a good starting point for anyone who wants to learn about Azure, including IT professionals, business decision-makers, and students. Microsoft Certified: Azure Administrator Associate (AZ-104): This certification covers the skills and knowledge required to administer Microsoft Azure. It is a good choice for IT professionals who want to manage Azure resources, such as virtual machines, storage, and networking. Microsoft Certified: Azure Developer Associate (AZ-204): This certification covers the skills and knowledge required to develop applications on Microsoft Azure. It is a good choice for developers who want to build and deploy applications on Azure. If you are new to Azure, we recommend starting with the AZ-900 certification. Once you have passed the AZ-900 certification, you can then choose a certification that is aligned with your career goals.
Microsoft Azure is a cloud computing platform that offers a broad range of services, including computing, storage, networking, databases, analytics, machine learning, and artificial intelligence. Azure can be used to build, deploy, and manage applications and services.
There are many benefits to using Microsoft Azure, including: Scalability: Azure is a scalable platform that can be easily scaled up or down to meet your needs. Reliability: Azure is a reliable platform with a 99.9% uptime SLA. Security: Azure is a secure platform with a number of security features, such as encryption and role-based access control. Cost-effectiveness: Azure is a cost-effective platform with a pay-as-you-go pricing model.
Here are some of the jobs you can get with an Azure certification: Azure Administrator: Azure administrators are responsible for managing Azure resources, such as virtual machines, storage, and networking. They also work with customers to design and implement Azure solutions. Azure Developer: Azure developers are responsible for developing applications on Azure. They use Azure services to build, deploy, and manage applications. Azure Solutions Architect: Azure solutions architects are responsible for designing and implementing solutions on Azure. They work with customers to understand their needs and then design and implement solutions that meet those needs.
Microsoft Technical FAQ's
You can take a Microsoft certification exam either online or in-person at a Person VUE test center.
The best Microsoft Azure certification for you depends on your career goals and experience level. Here are a few of the most popular Microsoft Azure certifications: Microsoft Certified: Azure Fundamentals (AZ-900): This is a foundational certification that covers the basics of Microsoft Azure. It is a good starting point for anyone who wants to learn about Azure, including IT professionals, business decision-makers, and students. Microsoft Certified: Azure Administrator Associate (AZ-104): This certification covers the skills and knowledge required to administer Microsoft Azure. It is a good choice for IT professionals who want to manage Azure resources, such as virtual machines, storage, and networking. Microsoft Certified: Azure Developer Associate (AZ-204): This certification covers the skills and knowledge required to develop applications on Microsoft Azure. It is a good choice for developers who want to build and deploy applications on Azure. If you are new to Azure, we recommend starting with the AZ-900 certification. Once you have passed the AZ-900 certification, you can then choose a certification that is aligned with your career goals.
Microsoft Azure is a cloud computing platform that offers a broad range of services, including computing, storage, networking, databases, analytics, machine learning, and artificial intelligence. Azure can be used to build, deploy, and manage applications and services.
There are many benefits to using Microsoft Azure, including: Scalability: Azure is a scalable platform that can be easily scaled up or down to meet your needs. Reliability: Azure is a reliable platform with a 99.9% uptime SLA. Security: Azure is a secure platform with a number of security features, such as encryption and role-based access control. Cost-effectiveness: Azure is a cost-effective platform with a pay-as-you-go pricing model.
Here are some of the jobs you can get with an Azure certification: Azure Administrator: Azure administrators are responsible for managing Azure resources, such as virtual machines, storage, and networking. They also work with customers to design and implement Azure solutions. Azure Developer: Azure developers are responsible for developing applications on Azure. They use Azure services to build, deploy, and manage applications. Azure Solutions Architect: Azure solutions architects are responsible for designing and implementing solutions on Azure. They work with customers to understand their needs and then design and implement solutions that meet those needs.
Trusted By