Microsoft Power Platform Fundamentals (PL-900) Online Course

Microsoft Power Platform Fundamentals (PL-900) Online Course

This course closely follows the PL-900 curriculum, covering all 76 learning objectives set by Microsoft. It is designed to systematically address each objective in sequence, maximizing your chances of passing the exam. The structured approach ensures clarity and keeps you on track throughout your learning journey.

By the end of the course, you will have the skills to learn, showcase, and utilize Power BI capabilities to create advanced reports.

Who is this Course for?

This course is tailored for a diverse audience, including students preparing for the PL-900 exam to earn the prestigious Microsoft Power Platform Fundamentals certification. It is also highly valuable for data analysts and business managers looking to explore the capabilities of the Power Platform. Additionally, anyone interested in mastering Power Apps, Power Automate, Power BI, Power Virtual Agents, Dataverse, Connectors, and AI Builder will find this course beneficial.

What you will learn

• Gain the knowledge needed 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 valuable insights.
• Learn Power Apps to design and develop custom business applications.
• Develop expertise in Power Automate to automate everyday business processes.
• Effectively communicate the importance of Microsoft Power Platform’s core components.

Course Table of Contents

Introduction

• Course Intro
• 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

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

• Next Steps