Microsoft Power Platform Fundamentals (PL-900) Online Course

Microsoft Power Platform Fundamentals (PL-900) Online Course

This PL-900 certification course equips you with the skills to master Microsoft Power Platform and succeed in the PL-900 exam. With over 15 hours of lessons, 140+ pages of study guides, and practice exams, it covers all 76 Microsoft-defined objectives in sequence for a clear, structured learning path. You’ll explore the business value and core components of the platform, build reports in Power BI, create apps with Power Apps, automate workflows in Power Automate, and develop chatbots with Power Virtual Agents. By course end, you’ll be fully prepared to demonstrate and apply Power Platform capabilities with confidence.

Who should take this Course?

This course is ideal for business users, functional consultants, and beginners looking to understand and leverage Microsoft Power Platform. It’s also well-suited for IT professionals, data analysts, and app developers seeking to enhance their skills in Power BI, Power Apps, Power Automate, and Power Virtual Agents, as well as anyone preparing for the PL-900 certification exam to validate their Power Platform expertise.

What You Will Learn

• Prepare thoroughly to pass the PL-900 exam and earn the Power Platform Fundamentals certification.

• Understand the core components and business value of Microsoft Power Platform.
• Master Power BI to create advanced reports and extract insights.
• Build custom business applications using Power Apps.
• Automate workflows and processes with Power Automate.
• Communicate the importance of Power Platform’s core components effectively.

Course Table of Contents

Introduction

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

Updates to the Exam for June 22, 2023

• Updates to the Exam - June 22, 2023

Environment

• Create a Trial Account
• App Launcher and Power BI Desktop
• Quick App Walkthrough
• Reference Material
• Study Notes

LO1: Describe the Business Value of Microsoft Power Platform

• 1.1.1 Power BI
• 1.1.2 Power Apps
• 1.1.3 Power Automate
• 1.1.4 Connectors
• 1.1.5 Power Virtual Agents
• 1.2.1 Dynamics 365 and Power Platform
• 1.2.1 Dynamics 365 Connectors
• 1.2.2 Microsoft 365 and Power Platform
• 1.2.3 Teams and Power Platform
• 1.2.4 Azure and Power Platform
• 1.2.5 Third-Party Apps and Services
• 1.2.6 AppSource
• 1.2.6 Demo of AppSource
• 1.2.7 How the Different Apps Work Together
• 1.3.1 Power Platform Security
• 1.3.1 Dataverse Security Roles
• 1.3.1 Demo on Dataverse Security Roles
• 1.3.1 Security Roles Deep Dive
• 1.3.2 Manage Apps, Workflows, and Users
• 1.3.3 Environments
• 1.3.4 Admin Center Summary
• 1.3.4 Demo Microsoft 365 Admin Center
• 1.3.4 Power Platform Admin Center
• 1.3.5 DLP Introduction
• 1.3.5 DLP Demo
• 1.3.5 DLP Block Exceptions
• 1.3.6 Privacy and Accessibility Guidelines
• 1.3.7 Privacy and Accessibility Tools
• 1.3.7 Demo of Trust Center and Security Compliance
• 1.3.8 Governance Structure
• U1.1.6 Power Pages
• U1.1.7 AI Builder

LO2: Identify the Core Components of Microsoft Power Platform

• 2.1.1 Dataverse
• 2.1.2 Dataverse for Teams
• 2.1.3 Tables, Columns, and Relationships
• 2.1.4 Common Data Model
• 2.2.2 Actions
• 2.2.3 Types of Connectors
• 2.2.4 Use Case of Custom Connectors
• 2.2.4 Connectors Overall
• 2.3.1 AI Builder
• 2.3.2 AI Builder Models
• 2.3.2 Business Card Examples
• 2.3.2 Document Processing Example 1
• 2.3.2 Document Processing Example 2
• 2.3.2 Document Processing Example 3
• 2.3.3 AI Builder and the Power Platform

LO3: Demonstrate the Capabilities of Power BI

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

LO4: Demonstrate the Capabilities of Power Apps

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

LO5: Demonstrate the Capabilities of Power Automate

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

LO6: Demonstrate the Capabilities of Power Virtual Agents

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

Updates to the Exam - June 22, 2023

• U6.3.1 Power Pages Use Cases
• U6.3.2 Power Pages Templates
• U6.3.3 1 Power Pages Walkthrough 1
• U6.3.3 2 Power Pages Walkthrough 2
• U6.4.1 1 AI Builder Models
• U6.4.1 2_3 AI Builder and Business Cards
• U6.4.1 4 Document Processing 1
• U6.4.1 5 Document Processing 2
• U6.4.1 6 Document Processing 3
• U6.4.1 7 AI Builder and Power Platform
• U6.4.2 Lifecycle of AI Builder Model

Conclusion

• Congratulations
• Next Steps