WSQ - Microsoft Power Platform Functional Consultant (PL-200)

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

Final Assessment 

• Written Assessment (SAQ)
• Practical Performance

Promotion Code

Promo or discount cannot be applied to WSQ courses

Minimum Entry Requirement

Knowledge and Skills

• Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
• 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.
• Minimum 18 years old

Minimum Software/Hardware Requirement

Software: 

You can download and install the following software:

• Power BI Desktop

You can also sign up a Power BI account

Hardware: Window Laptop

About Progressive Wage Model (PWM)

The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity. 

Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.

For more information on PWM, please visit MOM site.

Funding Eligility Criteria

Steps to Apply Skills Future Claim

• The staff will send you an invoice with the fee breakdown.
• Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
• Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
• Upload your invoice and click ‘Submit’

SkillsFuture Level-Up Program

The  SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme

Get Additional Course Fee Support Up to $500 under UTAP

The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)

Steps to Apply UTAP

• Log in to your U Portal account to submit your UTAP application upon completion of the course.

Note

• SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
• All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
• An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
• UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
• UTAP support amount will be paid to training provider first and claimed after end of class by learner.

• 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

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.