Course Summary
This Microsoft Power Platform Fundamentals CertPREP course prepares you for the Microsoft Exam PL-900 while helping demonstrate your real-world knowledge of the four Microsoft Power Platform products: Power BI, Power Apps, Power Automate, and Power Virtual Agents. PL-900 focuses on knowledge needed to describe the business value of Microsoft Power Platform; identify the core components of Microsoft Power platform; describe the business value of Power BI; demonstrate the capabilities of Power Apps; demonstrate the capabilities of Power Automate; and demonstrate the capabilities of Power Virtual Agents
The goal of this course is to provide you with all the tools you need to prepare for the PL-900 Microsoft Power Platform Fundamentals exam — including text explanations, video demos, lab activities, self-assessment questions, and a practice exam— to increase your chances of passing the exam on your first try.
Methodology:
180-day access to:
- Lessons
- Video learning
- MeasureUp Practice Test for Microsoft PL-900. Practice Mode with remediation and Certification mode to simulate the test day experience.
Duration:
18 hours of primary content. Every learner will progress at their own pace.
Audience:
Beginners who desire to learn more about the Microsoft Power Platform Fundamentals.
Prerequisites:
- No coding experience required.
- No administration experience required.
Course Outline:
Upon successful completion of this course, students should be able to:
- Describe the business value of Microsoft Power Platform.
- Identify the core components of Microsoft Power Platform.
- Describe the business value of Power BI.
- Demonstrate the capabilities of Power Apps.
- Demonstrate the capabilities of Power Automate.
- Demonstrate the capabilities of Power Virtual Agents.
Lesson 1: Describe the business value of Microsoft Power Platform (4 hours and 12 minutes).
- Skill 1.1: Describe the business value of Microsoft Power Platform services (1 hour and 12 minutes).
- Gain insights into data by using Power BI.
- Build applications quickly by using Power Apps.
- Build solutions that use the Microsoft Dataverse.
- Automate processes by using Power Automate.
- Use connectors to integrate services and data.
- Create powerful chatbots by using the Power Virtual Agents web app and Power Virtual Agents in Microsoft Teams.
- Skill 1.2: Describe the business value of extending business solutions by using Microsoft Power Platform (1 hour and 24 minutes).
- Describe how Microsoft Power Platform apps work together with Dynamics 365 apps.
- Describe how Power Platform business solutions work together with Microsoft 365 apps. and services.
- Describe how Microsoft Power Platform apps work together.
- Describe how to use Microsoft Power Platform solutions with Microsoft Teams.
- Describe how Microsoft Power Platform business solutions can consume Microsoft. Azure services including Azure Cognitive Services.
- Describe how Power Platform business solutions can consume third-party apps and services.
- Describe use cases for AppSource.
- Skill 1.3: Describe Microsoft Power Platform administration and security (1 hour and 36 minutes).
- Describe how Power Platform implements security, including awareness of Microsoft. Dataverse security roles, Azure Identity Services, and Access Management (IAM).
- Describe how to manage apps and users.
- Describe environments.
- Describe where to perform specific administrative tasks, including Power Platform admin center and Microsoft 365 admin center.
- Describe data policies.
- Describe how Microsoft Power Platform supports privacy and accessibility guidelines.
- Describe Microsoft Power Platform governance capabilities.
- Describe analytics and how they can be used.
- Summary
- Case Study
- Quiz
Lesson 2: Identify the core components of Microsoft Power platform (2 hours and 24 minutes).
- Skill 2.1: Describe Microsoft Dataverse (1 hour and 36 minutes).
- Introduce Microsoft Dataverse.
- Describe the difference between databases and Dataverse.
- Describe the differences between Dataverse and Dataverse for Teams.
- Describe tables, columns, and relationships.
- Describe how to use common standard tables to describe people, places, and things.
- Describe business logic uses, including business rules, real-time workflows, and actions.
- Describe dataflows and their uses.
- Describe solutions and their purpose.
- Skill 2.2: Describe connectors (48 minutes).
- Describe triggers, including trigger types and where triggers are used.
- Describe actions.
- Describe licensing options for connectors, including standard or premium tier.
- Identify use cases for custom connectors.
- Summary
- Case Study
- Quiz
Lesson 3: Describe the business value of Power BI (3 hours and 12 minutes).
- Skill 3.1: Identify common Power BI components (1 hour and 12 minutes).
- Identify and describe uses for visualization controls, including pie, bar, donut, and scatter plots and KPIs.
- Describe the Power BI Desktop Reports, Data, and Model tabs.
- Compare and contrast Power BI Desktop and Power BI service.
- Compare and contrast dashboards, workspaces, and reports.
- Describe the Power BI security model.
- Describe using Power BI in mobile apps.
- Skill 3.2: Connect to and consume data (1 hour 24 minutes).
- Connect to and combine data from multiple sources, including Microsoft Excel.
- Describe how to use Power Query to clean and transform data.
- Describe and implement aggregate functions.
- Identify available types of data sources, including Microsoft Excel.
- Describe use cases for shared datasets.
- Describe use cases for template apps.
- Describe options for viewing Power BI reports and dashboards.
- Skill 3.3: Build a basic dashboard using Power BI (36 minutes).
- Create a Power BI report.
- Create a Power BI dashboard.
- Publish and share reports and dashboard.
- Summary
- Case Study
- Quiz
Lesson 4: Demonstrate the capabilities of Power Apps (2 hours and 24 minutes).
- Skill 4.1: Identify common Power Apps components (24 minutes).
- Describe the differences between canvas apps and model-driven apps.
- Describe use cases for formulas.
- Skill 4.2: Build a basic canvas app (1 hour and 12 minutes).
- Describe types of data sources.
- Connect to data by using connectors.
- Create an app from data.
- Use controls to design the user experience.
- Publish and share an app.
- Describe embedding into Microsoft Teams.
- Skill 4.3: Build a basic model-driven app (48 minutes).
- Create a model-driven app from tables.
- Modify forms.
- Create and modify views and columns.
- Publish and share an app.
- Summary
- Case Study
- Quiz
Lesson 5: Demonstrate the capabilities of Power Automate (2 hours and 12 minutes).
- Skill 5.1: Identify common Power Automate components (1 hour and 20 minutes).
- Identify flow types, including cloud, desktop, and business process flows.
- Describe use cases for flows and available flow templates.
- Describe how Power Automate uses connector triggers and actions.
- Describe loops and conditions, including switch, do until, and apply to each.
- Describe expressions.
- Describe use cases for approvals.
- Describe the Power Automate apps, including Power Automate Desktop, Power Automate mobile, and Power Automate portal.
- Skill 5.2: Build a basic cloud flow (48 minutes.)
- Create a cloud flow by using the instant, automated, or scheduled flow template.
- Modify a cloud flow.
- Use flow steps to perform data operations.
- Run a cloud flow.
- Summary
- Case Study
- Quiz
Lesson 6: Demonstrate the capabilities of Power Virtual Agents (1 hour and 36 minutes).
- Skill 6.1: Describe the capabilities of Power Virtual Agents in Microsoft Teams (36 minutes).
- Describe use cases for Power Virtual Agents within Microsoft Teams.
- Describe topics, entities, and actions.
- Describe message nodes, question nodes, conditions, trigger phrases, and the authoring canvas.
- Skill 6.2: Build and publish a basic chatbot (1 hour).
- Create a chatbot.
- Create a topic.
- Call an action.
- Launch a Power Automate flow from a chatbot.
- Publish a chatbot.
- Summary
- Case Study
- Quiz