CertPREP Courseware: Microsoft Power Platform Fundamentals (PL-900) — 180-Day access

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

Click here for Instructor Resources

Student access for each license to the course content and resources for 6 months including:

• All text, video, and end of lesson questions
• Lab content (where available)
• Practice Test