The Complete Masterclass on PL-900 Certification

Overview

In this online training course, students will learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Microsoft Dataverse, build a Power BI Dashboard, automate a process with Power Automate, and work with Microsoft Copilot Studio.

Exam – PL-900: Microsoft Power Platform Fundamentals

COURSE DIFFICULTY

Beginner

COURSE DURATION

17h

SKILLS LEARNED
COURSE OUTLINE

Skills Learned

After completing this online training course, students will be able to:

Describe the business value of Microsoft's Power Platform
Demonstrate the capabilities of Power BI
Demonstrate the capabilities of Power Automate
Identify the Core components of Power Platform
Demonstrate the capabilities of PowerApps
Demonstrate the capabilities of Power Virtual Agents

01. Introduction

Introduction
What Is PL-900?
Course Roadmap and PL-900 Curriculum
Who Am I?
Keys to Success

02. Updates to the PL-900 Exam

Updates to the Exam

03. Environment

Create a Trial Account
App Launcher and Power BI Desktop
Quick App Walkthrough

04. Describe the Business Value of Microsoft Power Platform

Power BI
Power Apps
Power Automate
Connectors
Power Virtual Agents
Dynamics 365 and Power Platform
Dynamics 365 Connectors
Microsoft 365 and Power Platform
Teams and Power Platform
Azure and Power Platform
Third-Party Apps and Services
AppSource
Demo of AppSource
How the Different Apps Work Together
Power Platform Security
Dataverse Security Roles
Demo on Dataverse Security Roles
Security Roles Deep Dive
Manage Apps, Workflows, and Users
Environments
Admin Center Summary
Demo Microsoft 365 Admin Center
Power Platform Admin Center
DLP Introduction
DLP Demo
DLP Block Exceptions
Privacy and Accessibility Guidelines
Privacy and Accessibility Tools
Demo of Trust Center and Security Compliance
Governance Structure
Power Pages
AI Builder

05. Identify the Core Components of Microsoft Power Platform

Dataverse
Dataverse for Teams
Tables, Columns, and Relationships
Common Data Model
Actions
Types of Connectors
Use Case of Custom Connectors
Connectors Overall
AI Builder
AI Builder Models
Business Card Examples
Document Processing Example 1
Document Processing Example 2
Document Processing Example 3
AI Builder and the Power Platform

06. Demonstrate the Capabilities of Power BI

Visualization Options 1
Visualization Options 2
Visualization Options 3
Visualization Options 4
Power BI Desktop Tabs
Demo of Power BI Desktop Tabs
Power BI Desktop Versus Power BI Service
Power BI Service Elements Diagram
Power BI Service Elements Detail
Power BI Service Elements Walkthrough
Power BI Security Model
Go Through Sample Data
Load Data into Power Query
Combine Data
Assign Data Types
Replace Values and Clean Data
Preview Data Columns
Add Columns
Walkthrough of Other Clean and Transform Features
Apply Queries and Add More Data
Aggregate Functions
Demo of Aggregate Functions
Data Sources in Power BI
Shared Datasets
Template Apps
Demo of Template Apps
Viewing Reports and Dashboards
Create a New Score Column
Create Our First Visualization
Formatting the Visualization
Build Out Remaining Visualization
New Page and Card and Gauge Visualization
Filters and Slicers
Stacked Bar, Clustered Bar, and Line Chart
KPI Charts
Bar Charts
Buttons
Publish Dataset and Report
Quick Clarification
Create Dashboards
Edit Dashboards
Share Reports and Dashboards
Add Elements to Workspaces

07. Demonstrate the Capabilities of Power Apps

App Types
Use Cases of Formulas
Functions in Formulas
Data Sources
Data Load
Data Update
Table Definitions
Demo of Load Data
Demo of Update Data
Delegations
Connectors Overview
Create Apps from Data
Explore Apps
Common Controls
Development Environment
Dynamic Assignment
Actions and Navigate
Variables
Functions and Formulas
If Statements
Setting Up the Data
Connecting to Data
Data Tables
Galleries 1
Galleries 2
View Forms and Galleries
Edit Forms 1
Edit Forms 2
Filter and Search
Publish and Share Apps
Save and Publish Apps
Model-Driven Apps Introduction
Add Sample Data
Demo Create an App from Tables
Model-Driven App Building Blocks
Forms
Demo of Forms
Views
Demo of Views
Publish and Share Model-Driven Apps
Security Roles

08. Demonstrate the Capabilities of Power Automate

Cloud and Desktop and Business Processes
Types of Flows and How to Choose
Use Case of Flows
What Is a Flow
Flows Can Have Multiple Actions
Flow Templates
Demo of Templates
Connecting Triggers and Actions
Example Connectors
Types of Connectors
Demo of Connectors
Different Built-In Controls
Conditions
Switches
Loops (Do Until and Apply to Each)
Expressions Introduction
Demo of Expressions
Approvals Introductions
Approval System
Prerequisites
Demo of Approvals
Power Automate Apps
Example of Instant, Scheduled, and Automated Flows
Modify a Cloud Flow
Data Operations
Example of Compose
Example of Parse JSON
Run a Cloud Flow

09. Demonstrate the Capabilities of Power Virtual Agents

Power Virtual Agents and Business Value
Power Virtual Agents Elements of Topics, Entities, Actions
Topic Breakdown of Message, Question, Condition, Action Nodes
Create a Chatbot
Manage and Delete Bots
Create a Simple Topic
Add Entities to Topics
Power Virtual Agents Actions
Call a Power Automate Flow from Power Virtual Agents
Return Variables from Power Automate to Power Virtual Agents
Publish Power Virtual Agents
Demo and Publish Power Virtual Agents Bots

10. Updates to the Exam - June 22, 2023

Power Pages Use Cases
Power Pages Templates
Power Pages Walkthrough 1
Power Pages Walkthrough 2
AI Builder Models
AI Builder and Business Cards
Document Processing 1
Document Processing 2
Document Processing 3
AI Builder and Power Platform
Lifecycle of AI Builder Model

SKILLS LEARNED

Skills Learned

After completing this online training course, students will be able to:

Describe the business value of Microsoft's Power Platform
Demonstrate the capabilities of Power BI
Demonstrate the capabilities of Power Automate
Identify the Core components of Power Platform
Demonstrate the capabilities of PowerApps
Demonstrate the capabilities of Power Virtual Agents

COURSE OUTLINE

01. Introduction

Introduction
What Is PL-900?
Course Roadmap and PL-900 Curriculum
Who Am I?
Keys to Success

02. Updates to the PL-900 Exam

Updates to the Exam

03. Environment

Create a Trial Account
App Launcher and Power BI Desktop
Quick App Walkthrough

04. Describe the Business Value of Microsoft Power Platform

Power BI
Power Apps
Power Automate
Connectors
Power Virtual Agents
Dynamics 365 and Power Platform
Dynamics 365 Connectors
Microsoft 365 and Power Platform
Teams and Power Platform
Azure and Power Platform
Third-Party Apps and Services
AppSource
Demo of AppSource
How the Different Apps Work Together
Power Platform Security
Dataverse Security Roles
Demo on Dataverse Security Roles
Security Roles Deep Dive
Manage Apps, Workflows, and Users
Environments
Admin Center Summary
Demo Microsoft 365 Admin Center
Power Platform Admin Center
DLP Introduction
DLP Demo
DLP Block Exceptions
Privacy and Accessibility Guidelines
Privacy and Accessibility Tools
Demo of Trust Center and Security Compliance
Governance Structure
Power Pages
AI Builder

05. Identify the Core Components of Microsoft Power Platform

Dataverse
Dataverse for Teams
Tables, Columns, and Relationships
Common Data Model
Actions
Types of Connectors
Use Case of Custom Connectors
Connectors Overall
AI Builder
AI Builder Models
Business Card Examples
Document Processing Example 1
Document Processing Example 2
Document Processing Example 3
AI Builder and the Power Platform

06. Demonstrate the Capabilities of Power BI

Visualization Options 1
Visualization Options 2
Visualization Options 3
Visualization Options 4
Power BI Desktop Tabs
Demo of Power BI Desktop Tabs
Power BI Desktop Versus Power BI Service
Power BI Service Elements Diagram
Power BI Service Elements Detail
Power BI Service Elements Walkthrough
Power BI Security Model
Go Through Sample Data
Load Data into Power Query
Combine Data
Assign Data Types
Replace Values and Clean Data
Preview Data Columns
Add Columns
Walkthrough of Other Clean and Transform Features
Apply Queries and Add More Data
Aggregate Functions
Demo of Aggregate Functions
Data Sources in Power BI
Shared Datasets
Template Apps
Demo of Template Apps
Viewing Reports and Dashboards
Create a New Score Column
Create Our First Visualization
Formatting the Visualization
Build Out Remaining Visualization
New Page and Card and Gauge Visualization
Filters and Slicers
Stacked Bar, Clustered Bar, and Line Chart
KPI Charts
Bar Charts
Buttons
Publish Dataset and Report
Quick Clarification
Create Dashboards
Edit Dashboards
Share Reports and Dashboards
Add Elements to Workspaces

07. Demonstrate the Capabilities of Power Apps

App Types
Use Cases of Formulas
Functions in Formulas
Data Sources
Data Load
Data Update
Table Definitions
Demo of Load Data
Demo of Update Data
Delegations
Connectors Overview
Create Apps from Data
Explore Apps
Common Controls
Development Environment
Dynamic Assignment
Actions and Navigate
Variables
Functions and Formulas
If Statements
Setting Up the Data
Connecting to Data
Data Tables
Galleries 1
Galleries 2
View Forms and Galleries
Edit Forms 1
Edit Forms 2
Filter and Search
Publish and Share Apps
Save and Publish Apps
Model-Driven Apps Introduction
Add Sample Data
Demo Create an App from Tables
Model-Driven App Building Blocks
Forms
Demo of Forms
Views
Demo of Views
Publish and Share Model-Driven Apps
Security Roles

08. Demonstrate the Capabilities of Power Automate

Cloud and Desktop and Business Processes
Types of Flows and How to Choose
Use Case of Flows
What Is a Flow
Flows Can Have Multiple Actions
Flow Templates
Demo of Templates
Connecting Triggers and Actions
Example Connectors
Types of Connectors
Demo of Connectors
Different Built-In Controls
Conditions
Switches
Loops (Do Until and Apply to Each)
Expressions Introduction
Demo of Expressions
Approvals Introductions
Approval System
Prerequisites
Demo of Approvals
Power Automate Apps
Example of Instant, Scheduled, and Automated Flows
Modify a Cloud Flow
Data Operations
Example of Compose
Example of Parse JSON
Run a Cloud Flow

09. Demonstrate the Capabilities of Power Virtual Agents

Power Virtual Agents and Business Value
Power Virtual Agents Elements of Topics, Entities, Actions
Topic Breakdown of Message, Question, Condition, Action Nodes
Create a Chatbot
Manage and Delete Bots
Create a Simple Topic
Add Entities to Topics
Power Virtual Agents Actions
Call a Power Automate Flow from Power Virtual Agents
Return Variables from Power Automate to Power Virtual Agents
Publish Power Virtual Agents
Demo and Publish Power Virtual Agents Bots

10. Updates to the Exam - June 22, 2023

Power Pages Use Cases
Power Pages Templates
Power Pages Walkthrough 1
Power Pages Walkthrough 2
AI Builder Models
AI Builder and Business Cards
Document Processing 1
Document Processing 2
Document Processing 3
AI Builder and Power Platform
Lifecycle of AI Builder Model

The Complete Masterclass on PL-900 Certification

Overview

Skills Learned

Describe the business value of Microsoft's Power Platform

Demonstrate the capabilities of Power BI

Demonstrate the capabilities of Power Automate

Identify the Core components of Power Platform

Demonstrate the capabilities of PowerApps

Demonstrate the capabilities of Power Virtual Agents

Skills Learned

Describe the business value of Microsoft's Power Platform

Demonstrate the capabilities of Power BI

Demonstrate the capabilities of Power Automate

Identify the Core components of Power Platform

Demonstrate the capabilities of PowerApps

Demonstrate the capabilities of Power Virtual Agents

Say Hi to Mike!