Pl-900 Microsoft Power Platform Fundamentals Complete Guide

Complete PL-900 training guide with video lectures, demos, study guides, and practice exams, to prepare you for PL-900

What you'll learn
Everything you need to pass the PL-900 exam and receive the Power Platform Fundamentals certification
All learning objectives in the PL-900 Microsoft Power Platform Fundamentals curriculum, through video lectures, demos, PDF study guides, and practice exams
Understand and communicate the business value, and the core components, of Microsoft Power Platform
Learn, demonstrate, and apply the capabilities of Power BI to build sophisticated reports
Learn, demonstrate, and apply the capabilities of Power Apps to create business applications
Learn, demonstrate, and apply the capabilities of Power Automate to automate routine business processes
Learn, demonstrate, and apply the capabilities of Power Virtual Agents to publish useful and productive chat bots
Requirements
This course goes starts from the beginner level, so no prerequisites are required. Come hungry to learn!
Computer with web browser and internet
For Power BI Desktop, Windows 8 minimum
Description
Do you want to learn about the Power Platform, and prove that you have the knowledge to use the Power Platform to solve problems?Do you want to learn and apply the capabilities within Power BI, Power Apps, Power Automate, Power Virtual Agents, Dataverse, AI Builder, and Connectors?Do you want to be certified from Microsoft, so that you can put it on your Resume/CV and showcase to potential employers that you know the Power Platform?Do you want to pass the Microsoft PL-900 on the first try, and want one single complete resource that has everything you need for the PL-900 certification?Then this is the course for you. Learn from over 15 hours of instructional content, 140 pages of study guides, and practice exams, with the only complete guide to everything you need to know to pass the PL-900 exam and receive your certification.This course gives you all the training you need to pass - with detailed lectures, demos, and practice questions for each of the 76 learning objectives within the PL900 curriculum. This course gives you the structure you need to succeed - we go through each learning objective in sequential order, so that you are never lost.This course is also for those students who want to learn the Power Platform, and its underlying services. Along with the training required to pass the PL 900 certification, students also learn Power BI, Power Apps, Power Automate, Power Virtual Agents, AI Builder, Dataverse, and Connectors.PL-900 Microsoft Power Platform Fundamentals is also called PL-900, PL900, and PL 900 certifications, and so these are used interchangeablyWhat is this course all about?The purpose of this course is to prepare you for the PL 900 Microsoft Power Platform Fundamentals exam. It offers you dedicated video lectures, walk through demos, PDF study guides, and practice exams to maximize your chances of success. This course covers 100% of the 76 learning objectives in Microsoft's curriculum, and trains you to receive the certification on the first try.What is the PL-900?The PL-900 is a certification exam offered by Microsoft, that enables you to receive the Microsoft Power Platform Fundamentals certification. This proves to employers and clients that understand the core capabilities of the Power Platform and can apply it to solve every day problems in business settings. The exam format varies, but is most often 45 questions within 65 minutes.What does the PL-900 cover?The PL-900 covers introductory concepts and capabilities related to the Power Platform. Specifically, this includes Power BI, Power Apps, Power Automate, Power Virtual Agents. It also includes related topics such as Dataverse, AI Builder, Connectors, Dynamics 365, Teams, Security, and Administration. The exam does not only cover understanding the platform's capabilities, but also applying it to build reports, create apps, automate processes, and publish chat bots.What is Power BI?Power BI is a business intelligence and analytics platform, enabling users to connect data sources, discover insights, and create reports and dashboards that can be shared within the entire organization. Power BI is the most popular service within the Power PlatformWhat is Power Apps?PowerApps in Microsoft's platform to build fully functional and cross-platform applications with little to no code. Think of PowerApps as Microsoft Word, but instead of building documents you are building real-life applications.What is Power Automate?Power Automate is a platform to automate any and all tasks. You can streamline anything, including your emails, calendars, and business processes. Users have seen more than a 15% increase in productivity after using Power Automate for only a week!What is Power Virtual Agents?Power Virtual Agents is the easiest and no-code way to create sophisticated chat bots to improve customer experience and automate requests in your company. PVA enables you to leverage Microsoft natural language processing and artificial intelligence at your fingertipsWhy should you get the PL-900 certification?The PL-900 certification from Microsoft is a recognized way to prove that you understand and can operate the services within the Power Platform. You can use the knowledge you learn in the PL-900 course to create impact in your organization. You can add it to your resume to significantly boost your chances of employment. Most employers even cover the cost of the training and exam because of the value that this certification provides. In certain countries, you can even receive ACE college credits.Why choose this course?Complete guide - this is the 100% complete, start to finish zero to hero training guide to passing the PL900 exam. It includes lectures, demos, study guides, practice exams, and more. It is the only resource that you will ever need to ace the exam. It contains over 15 hours of instructional content!Full coverage - we go through Microsoft's curriculum one-by-one and cover all aspects of each of the 76 different learning objectives. This means no surprises on the exam, and it ensures that you are best prepared to pass the PL-900 exam on the first try.Structured to succeed - the course mirrors Microsoft's PL 900 curriculum exactly. Each of the 76 learning objectives has a combination of a PDF study guide, full video lectures, full video walk through demos, and application.Instructional and applicable - we not only go through important concepts, but also apply them as we are building our application so that we can solidify them. This is not only a walkthrough of the all the features and theoretical concepts, but a PL-900 course that actually builds applications with youStudy guide PDF - you receive the full 120+ page study guide that we go through in detail in the course - students download these, print them, and annotate them so you can maximize your chances of success to pass the PL 900 exam.Practice exams - this course contains practice exams with questions that exactly mirror the types of questions found on the PL-900 exam. Use them to validate your knowledge and find weaker areas where you need to review.Step by step - each learning objective within Microsoft's PL 900 curriculum is covered in order, step by step. This ensures that you never get lost in the course.Teacher response - if there's anything else you would like to learn, or if there's something you cannot figure out, I'm here for you! Look at the ways to reach out videoCommunity - when you enroll in this course, you join a PL900 community full of learners just like youCourse overview theoryThe course follows exactly according to PL900 curriculum, based on 76 learning objectives (LO) that Microsoft has defined. Everything in this course is made to maximize your chances of passing the exam. For each learning objective, the course offers a combination of guided study notes, lecture videos, walk-through demos, and application. We then end with practice exams.Course overviewIntroduction - learn about the PL 900 exam and how best to succeedEnvironment Setup - set up the Power Platform on your computer so you can follow along, and review the curriculumSection 1: Describe the business value of Microsoft Power Platform (20-25%)Section 2: Identify the core components of Microsoft Power Platform (10-15%)Section 3: Demonstrate the capabilities of Power BI (20-25%)Section 4: Demonstrate the capabilities of Power Apps (25-30%)Section 5: Demonstrate the capabilities of Power Automate (10-15%)Section 6: Demonstrate the capabilities of Power Virtual Agents (5-10%)Practice Exams - practice what you have learned to validate your knowledgeConclusion - take your exam, earn your certification, and next stepsMedal icons created by Freepik. Music by Bensound.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What is PL-900?

Lecture 3 Course roadmap and PL-900 curriculum

Lecture 4 Curriculum and learning objectives

Lecture 5 Who am I?

Lecture 6 Ways to reach out

Lecture 7 Keys to success

Lecture 8 Leave a rating

Section 2: Environment

Lecture 9 Create a trial account

Lecture 10 App launcher and Power BI Desktop

Lecture 11 Quick app walkthrough

Lecture 12 Reference material

Lecture 13 Reference materials - see resources

Lecture 14 Study notes

Section 3: LO1: Describe the business value of Microsoft Power Platform

Lecture 15 1.1.1 Power BI

Lecture 16 1.1.2 Power Apps

Lecture 17 1.1.3 Power Automate

Lecture 18 1.1.4 Connectors

Lecture 19 1.1.5 Power Virtual Agents

Lecture 20 1.2.1 Dynamics 365 and Power Platform

Lecture 21 1.2.1 Dynamics 365 connectors

Lecture 22 1.2.2 Microsoft 365 and Power Platform

Lecture 23 1.2.3 Teams and Power Platform

Lecture 24 1.2.4 Azure and Power Platform

Lecture 25 1.2.5 Third party apps and services

Lecture 26 1.2.7 How the different apps work together

Lecture 27 1.3.1 Power Platform security

Lecture 28 1.3.1 Dataverse security roles

Lecture 29 1.3.1 Demo on Dataverse security roles

Lecture 30 1.3.1 Security roles deep dive

Lecture 31 1.3.2 Manage apps, workflows, and users

Lecture 32 1.3.3 Environments

Lecture 33 1.3.4 Admin center summary

Lecture 34 1.3.4 Demo Microsoft 365 admin center

Lecture 35 1.3.4 Power platform admin center

Lecture 36 1.3.5 DLP introduction

Lecture 37 1.3.5 DLP demo

Lecture 38 1.3.5 DLP block exceptions

Lecture 39 1.3.6 Privacy and accessibility guidelines

Lecture 40 1.3.7 Privacy and accessibility tools

Lecture 41 1.3.7 Demo of trust center and security compliance

Section 4: LO2: Identify the core components of Microsoft Power Platform

Lecture 42 2.1.1 Dataverse

Lecture 43 2.1.2 Dataverse for Teams

Lecture 44 2.1.3 Tables, columns, and relationships

Lecture 45 2.3.1 AI Builder

Lecture 46 2.3.2 AI Builder models

Lecture 47 2.3.2 Business card examples

Lecture 48 2.3.2 Document processing example 1

Lecture 49 2.3.2 Document processing example 2

Lecture 50 2.3.2 Document processing example 3

Lecture 51 2.3.3 AI Builder and the Power Platform

Section 5: LO3: Demonstrate the capabilities of Power BI

Lecture 52 3.1.2 Power BI desktop tabs

Lecture 53 3.1.2 Demo of Power BI desktop tabs

Lecture 54 3.1.3 Power BI Desktop vs. Power BI Service

Lecture 55 3.1.4 Power BI Service elements diagram

Lecture 56 3.1.4 Power BI Service elements detail

Lecture 57 3.1.4 Power BI Service elements walkthrough

Lecture 58 3.1.5 Power BI security model

Lecture 59 3.2.1 Go through sample data

Lecture 60 3.2.1 load data into Power Query

Lecture 61 3.2.1 Combine data

Lecture 62 3.2.2 Assign data types

Lecture 63 3.2.2 Replace values and clean data

Lecture 64 3.2.2 Preview data columns

Lecture 65 3.2.2 Add columns

Lecture 66 3.2.2 Walkthrough of other clean and transform features

Lecture 67 3.2.2 Apply queries and add more data

Lecture 68 3.2.3 Aggregate functions

Lecture 69 3.2.3 Demo of aggregate functions

Lecture 70 3.2.4 Data sources in Power BI

Lecture 71 3.2.5 Shared datasets

Lecture 72 3.2.6 Template apps

Lecture 73 3.2.6 Demo of template apps

Lecture 74 3.2.7 Viewing reports and dashboards

Lecture 75 3.3.1 Create a new score column

Lecture 76 3.3.1 Create our first visualization

Lecture 77 3.3.1 Formatting the visualization

Lecture 78 3.3.1 Build out remaining visualization

Lecture 79 3.3.1 New page and card and guage visualization

Lecture 80 3.3.1 Filters and slicers

Lecture 81 3.3.1 Stacked bar, clustered bar, and line chart

Lecture 82 3.3.1 KPI charts

Lecture 83 3.3.1 Bar charts

Lecture 84 3.3.1 Buttons

Lecture 85 3.3.1 Publish dataset and report

Lecture 86 3.3.1 Quick clarification

Lecture 87 3.3.2 Create dashboards

Lecture 88 3.3.2 Edit dashboards

Lecture 89 3.3.3 Share reports and dashboards

Lecture 90 3.3.3 Add elements to workspaces

Section 6: LO4: Demonstrate the capabilities of Power Apps

Lecture 91 4.1.1 App types

Lecture 92 4.1.2 Use cases of formulas

Lecture 93 4.1.2 Functions in formulas

Lecture 94 4.2.1 Data sources

Lecture 95 4.2.1 Data load

Lecture 96 4.2.1 Data update

Lecture 97 4.2.1 Table definitions

Lecture 98 4.2.1 Demo of load data

Lecture 99 4.2.1 Demo of update data

Lecture 100 4.2.1 Delegations

Lecture 101 4.2.2 Connectors overview

Lecture 102 4.2.3 Create apps from data

Lecture 103 4.2.3 Explore apps

Lecture 104 4.2.4 Common controls

Lecture 105 4.2.4 Development environment

Lecture 106 4.2.4 Dynamic assignment

Lecture 107 4.2.4 Actions and navigate

Lecture 108 4.2.4 Variables

Lecture 109 4.2.4 Functions and formulas

Lecture 110 4.2.4 If statements

Lecture 111 4.2.4 Setting up the data

Lecture 112 4.2.4 Connecting to data

Lecture 113 4.2.4 Data tables

Lecture 114 4.2.4 Galleries 1

Lecture 115 4.2.4 Galleries 2

Lecture 116 4.2.4 View forms and galleries

Lecture 117 4.2.4 Edit forms 1

Lecture 118 4.2.4 Edit forms 2

Lecture 119 4.2.4 Filter and search

Lecture 120 4.2.5 Publish and share apps

Lecture 121 4.2.5 Save and publish apps

Lecture 122 4.3.1 Model-driven apps introduction

Lecture 123 4.3.1 Add sample data

Lecture 124 4.3.1 Demo create an app from tables

Lecture 125 4.3.1 Model driven app building blocks

Lecture 126 4.3.2 Forms

Lecture 127 4.3.2 Demo of forms

Lecture 128 4.3.3 Views

Lecture 129 4.3.3 Demo of views

Lecture 130 4.3.4 Publish and share model-driven apps

Lecture 131 4.3.4 Security roles

Section 7: LO5: Demonstrate the capabilities of Power Automate

Lecture 132 5.1.1 Cloud and desktop and business processes

Lecture 133 5.1.1 Types of flows and how to choose

Lecture 134 5.1.2 Use case of flows

Lecture 135 5.1.2 What is a flow

Lecture 136 5.1.2 Flows can have multiple actions

Lecture 137 5.1.2 Flow templates

Lecture 138 5.1.2 Demo of templates

Lecture 139 5.1.3 Connecting triggers and actions

Lecture 140 5.1.3 Example connectors

Lecture 141 5.1.3 Types of connectors

Lecture 142 5.1.3 Demo of connectors

Lecture 143 5.1.4 Different built-in controls

Lecture 144 5.1.4 Conditions

Lecture 145 5.1.4 Switches

Lecture 146 5.1.4 Loops (do until and apply to each)

Lecture 147 5.1.5 Expressions introduction

Lecture 148 5.1.5 Demo of expressions

Lecture 149 5.1.6 Approvals introductions

Lecture 150 5.1.6 Approval system

Lecture 151 5.1.6 Prerequisites

Lecture 152 5.1.6 Demo of approvals

Lecture 153 5.1.7 Power Automate apps

Lecture 154 5.2.1 Example of instant, scheduled, and automated flows

Lecture 155 5.2.2 Modify a cloud flow

Lecture 156 5.2.3 Data operations

Lecture 157 5.2.3 Example of compose

Lecture 158 5.2.3 Example of parse JSON

Lecture 159 5.2.4 Run a cloud flow

Section 8: LO6: Demonstrate the capabilities of Power Virtual Agents

Lecture 160 6.1.1 Power Virtual Agents and business value

Lecture 161 6.1.2 Power Virtual Agents elements of topics, entities, actions

Lecture 162 6.1.3 Topic breakdown of message, question, condition, action nodes

Lecture 163 6.2.1 Create a chatbot

Lecture 164 6.2.1 Manage and delete bots

Lecture 165 6.2.2 Create a simple topic

Lecture 166 6.2.2 Add entities to topics

Lecture 167 6.2.3 Power Virtual Agents actions

Lecture 168 6.2.4 Call a Power Automate flow from Power Virtual Agents

Lecture 169 6.2.4 Return variables from Power Automate to Power Virtual Agents

Lecture 170 6.2.5 Publish Power Virtual Agents

Lecture 171 6.2.5 Demo and publish Power Virtual Agents bots

Section 9: Practice Exams

Section 10: Conclusion

Lecture 172 Congratulations

Lecture 173 Next steps

Lecture 174 Ways to reach out and contact me

Lecture 175 Certificate

Section 11: Bonus

Lecture 176 Bonus

Students who want to pass the PL-900 exam and receive the Microsoft Power Platform Fundamentals certification,Data analysts and business managers who want to understand the capabilities of the Power Platform,Individuals who want to learn Power Apps, Power Automate, Power BI, Power Virtual Agents, Dataverse, Connectors, and AI Builder,Individuals who want to receive a formal certificate from Microsoft for their progress and achievement (useful for moving upwards and getting hired),Users who want an introductory look (more breath, instead of depth) into the Power Platform