Pl-900: Microsoft Power Platform Fundamentals

Learn about Power Apps, Power Automate, Power BI, the AI Builder and the Dataverse (CDS) - for Microsoft's PL-900 exam.

What you'll learn

Describe the business value of Microsoft's Power Platform

Identify the Core Components of Power Platform, including Dataverse (CDS), Connectors and AI Builder

Demonstrate the capabilities of Power BI

Demonstrate the capabilities of Power Apps

Demonstrate the capabilities of Power Automate

Demonstrate the capabilities of Power Virtual Agents

Requirements

You need to know how to use a computer, and hopefully know how to use a spreadsheet.

No prior knowledge of Microsoft's Power Platform or any of its apps are required

You need Windows 7 SP1 or above, or for other machines an internet browser (Edge or Chrome preferred) to access most of the apps used in this course.

You need Windows 8, 10 or 11 to access Power BI Desktop; however, you can access the Power BI Service on other devices.

There is a 30-day refund guarantee of this Udemy course (see Udemy's refund policy).

Why not have a look at the curriculum below and see what you can learn?

Description

This course covers the content required for the PL-900 certification exam, current as per the PL-900 exam update of 22 June 2023, including the minor changes as of 27 December 2023, with new versions based on the updates as of 8 April 2024 and 21 June 2024.What do people like you say about this course?Halima says: "Excellent delivery! This course is quite up-to-date with all the new terminologies included. It was just what I needed to pass the PL-900 exam on first attempt. Thank you : )"Vibhaw says: "Pin point course to crack Pl-900 exam. Today i write the exam and got 807 marks. Thanks for your teaching."Madeline says: "Scored a 740 out of 700 with this course and a few weeks of hands on power BI. It was my very first MS test. Thanks for the course!" This course is the foundation for the Microsoft Certificate PL-900 "Microsoft Power Platform Fundamentals", and focuses on the various apps which make up the Power Platform, together with how they can be used by other programs, apps and services.We'll start off with looking at Power BI. If you have a PC, we'll download for free Power BI Desktop, and look at the various processes which you can use on the Power BI Desktop. Then, we'll look at the Power BI Service (available through any modern web browser), see what you can do with this, and how they compare. We'll then look at Power Apps. We'll get a free Developer edition and or free trial of Power Apps, and get some sample data using the Dataverse (previously known as the Common Data Service). We'll then create both a canvas and a model-driven Power App, while looking at the various types of connectors you can use to connect to different data sources.Next up is Power Automate. Using our free Developer edition, we'll create several automated flows, and the different triggers and actions you can use.The next app is Power Virtual Agents (now renamed to Microsoft Copilot Studio). We'll create a basic chatbot (now called a "Copilot") which can ask and answer a few questions. We'll then see how you can find out how well it is performing. (Up to 7 April 2024, the PL-900 exam will ask questions about Power Virtual Agents).We will have a brief look at the AI Builder, and how models such as the business card reader, object detection model, form processing model and prediction model can be integrated into Power Apps and Power Automate.We'll finish off by looking at how Power Platform can extend other business solutions, and some Power Platform administration and security.No prior knowledge is required - we'll even see how to get a free Power Platform trial!There are regular quizzes to help you remember the information, so you can be sure that you are learning.Once you have completed this course, you will have a good introductory knowledge of Power Platform and what the capacities of these different apps are. And with some practice, you could even go for the official Microsoft certification PL-900 - wouldn't that look good on your CV or resume? And if you are an American college student, you might even get college credit for passing that exam.So, without any further ado, let's have a look at how you can use Udemy interface, and then we'll have a look at the objectives for the exam and therefore the syllabus for this course.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Welcome to Udemy

Lecture 3 How to get the best out of your Udemy course

Lecture 4 Do you want auto-translated subtitles in more languages?

Lecture 5 1, 2, 3, 4, 5, 6/1-3, 5-6. The business value of Power Platform services

Lecture 6 4, 7, 8. The business value of Power Pages, Microsoft Dataverse and AI Builder

Lecture 7 Curriculum

Lecture 8 Resources

Section 2: Power BI Desktop - Visualizations

Lecture 9 Downloading Power BI Desktop

Lecture 10 Identify available types of data sources including Microsoft Excel

Lecture 11 29. Creating our first visualization

Lecture 12 Describe and implement aggregate functions

Lecture 13 29. Identify and describe uses for visualization controls - basic types

Lecture 14 28. Describe how AI Insights helps identify anomalies and trends in data

Lecture 15 Describe types of filters

Section 3: Power BI Desktop - Managing Data

Lecture 16 27. Loading queries into the Power Query Editor

Lecture 17 27. Menus in Power Query Editor

Lecture 18 27. Clean and transform data

Lecture 19 27. Combine multiple data sources

Lecture 20 25. Describe the Power BI Desktop Reports, Data, and Model tabs

Lecture 21 27. Design data layout and mapping

Section 4: Power BI Service

Lecture 22 Publishing to the Power BI Service

Lecture 23 Getting a free work email address for India

Lecture 24 Why do I need a Work email address? And how can I get one, if I don't have it?

Lecture 25 A quick look around the Power BI Service

Lecture 26 Power BI Terminology: data sources, semantic models, reports and dashboards

Lecture 27 Power BI Terminology: workspaces and apps

Lecture 28 25. Compare and contrast Power BI Desktop and Power BI Service

Lecture 29 30, 31. Design a Power BI Dashboard, including adding visuals by using Q&A

Lecture 30 26, 32. Compare and contrast and publish reports, dashboards, workspaces

Lecture 31 26d. Paginated reports

Lecture 32 29. Create a Power BI report

Lecture 33 32. Describe options for viewing Power BI reports and dashboards

Section 5: Installing Power Apps and Environments

Lecture 34 33. Introduction to Power Apps, incl. canvas and model-driven apps

Lecture 35 Signing up for PowerApps

Lecture 36 Creating our first canvas Power App

Lecture 37 15. Describe Environments

Section 6: The Dataverse (Common Data Service)

Lecture 38 The Power Apps User Experience

Lecture 39 19. Tables

Lecture 40 19. Columns and Relationships, and describing people, places, things

Lecture 41 18. The difference between databases and Dataverse

Lecture 42 Solutions

Lecture 43 20. Business Rules

Lecture 44 20. Real-time workflows and actions

Lecture 45 21. Dataflows

Section 7: Creating PowerApps canvas app

Lecture 46 34. Templates, including types of data sources and multiple data sources

Lecture 47 23, 36. Connect to data by using connectors, premium licensing options

Lecture 48 What does the end-user see?

Lecture 49 38. Use controls to design the user experience

Lecture 50 34. Components

Lecture 51 34. Formulas

Lecture 52 8a. Using Copilots with canvas Power Apps

Lecture 53 38a. Build responsive pages by dragging and dropping containers

Section 8: Building a basic model-driven app

Lecture 54 41. Modify views

Lecture 55 40. Modify forms

Lecture 56 Charts and Dashboards

Lecture 57 Model-driven app update

Lecture 58 35, 39. Creating our first model-driven app, adding tables to app navigation

Section 9: Power Automate - connectors, triggers and actions

Lecture 59 22, 42-44: Intro, incl. flow types, templates, connectors, triggers

Lecture 60 45. Power Automate use cases for Microsoft Teams, Outlook, SharePoint, Forms

Lecture 61 22, 49, 50: Creating, modifying and running an instant (button) flow

Lecture 62 49: Creating an automated flow template with a condition and expression

Lecture 63 49. Creating a scheduled flow, using an Apply to Each loop

Lecture 64 51. Other flow controls, such as Switch and Do Until

Lecture 65 45. Approvals and Business Processes

Lecture 66 24. Identify use cases for custom connectors

Lecture 67 46. Describe the Power Automate portal and mobile

Lecture 68 47, 53. Describe the Power Automate Desktop

Lecture 69 48a. Describe Process Mining and Task Mining

Lecture 70 49a. Describe how to create cloud flows by using Copilot in Power Automate

Section 10: Power Pages

Lecture 71 57. Provision and create our first Power Pages portal

Lecture 72 58. Other Portal templates

Lecture 73 59. Common portal customizations, including how to share data externally

Lecture 74 59a. Describe use cases for creating sites by using Copilot in Power Pages

Section 11: Power Virtual Agents

Lecture 75 54. Uses and where you can publish chatbots, creating our first chatbot

Lecture 76 -. Test a chatbot

Lecture 77 55. Topics, entities and actions

Lecture 78 Looking at topic conversation flowcharts

Lecture 79 -. Creating a topic, using nodes, conditions, and trigger phrases

Lecture 80 56. Create topics from existing FAQs by using Suggest Topics

Lecture 81 54. Publish a chatbot

Section 12: Other Power Platform Topics

Lecture 82 60, 61. Use cases and lifecycle for AI Builder models

Lecture 83 48. Describe document processing in Power Automate

Lecture 84 14. Power Platform Security

Lecture 85 14. Azure Identity Services and Access Management (IAM)

Lecture 86 16. Manage apps and users, and where to perform specific admin tasks

Lecture 87 16. Data Loss Prevention (DLP) policies

Lecture 88 17. Privacy and accessibility guidelines

Lecture 89 16. Power Platform governance capabilities

Lecture 90 9. Dynamics 365 and Power Platform

Lecture 91 10, 12. Microsoft 365 and Power Platform

Lecture 92 13. Microsoft Azure, Third-party apps, and Power Platform

Lecture 93 11. How Microsoft Power Platforms apps works together

Section 13: Congratulations

Lecture 94 What's Next?

Lecture 95 Well done

Section 14: Bonus Section - Power BI - No longer needed in the PL-900 as of March 2023

Lecture 96 No longer needed for PL-900 exam

Lecture 97 Describe uses for custom visuals including charts or controls

Lecture 98 Shared datasets and template apps

Lecture 99 Describe using Power BI in mobile apps

Section 15: Bonus Section - Dataverse and Power Apps

Lecture 100 The Common Data Model (CDM)

Lecture 101 The Native Dataverse connector

Lecture 102 The difference between Dataverse and Dataverse for Teams

Lecture 103 Publish and share a canvas app

Lecture 104 Revert to an earlier version

Lecture 105 -. Embedding into Microsoft Teams

Lecture 106 -. Publish and share an model-driven app

Section 16: Bonus Section - Other Power Platform Topics

Lecture 107 Power Pages - User authentication

Lecture 108 -. Describe use cases for Power Virtual Agents within Microsoft Teams

Lecture 109 Power Virtual Agents - Monitor chatbot usage and performance

Lecture 110 -. Consuming AI Builder in Microsoft Teams and SharePoint

Lecture 111 -. How Power Platform can consume Azure Cognitive Services

Lecture 112 -. Privacy and accessibility capabilities

Lecture 113 -. AppSource

Lecture 114 -. Analytics

Section 17: Bonus Lecture

Lecture 115 Bonus Lecture - PL-900

This course is for you if you want to understand what is available on Microsoft's Power Platform.,By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official PL-900 exam.,Wouldn't the "Microsoft Certified: Power Platform Fundamentals" certification look good on your CV or resume?