The Complete Masterclass on PL-900 Certification

The Complete Masterclass on PL-900 Certification

by HHN Automate Book Inc.
Released November 2023
Publisher(s): Packt Publishing
ISBN: 9781805125044

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Set out on a comprehensive journey through our PL-900 certification course, which equips you with the knowledge you need to pass the PL-900 exam. This course offers over 15 hours of instructional content, 140 pages of study guides, and practice exams, ensuring that you have all the resources required for success. The course aligns closely with the PL-900 curriculum, following the 76 learning objectives defined by Microsoft.

It‘s structured to enhance your chances of passing the exam by systematically addressing each learning objective in sequence, ensuring that you never feel lost. Start by familiarizing yourself with the PL-900 exam and the most effective strategies for success. Then, configure the Power Platform on your computer to prepare your learning environment. Throughout the course, you will dive into understanding the business value and core components of Microsoft Power Platform, master Power BI to create powerful reports and gain valuable insights, develop proficiency in Power Apps for crafting custom business applications, and gain in-depth knowledge of Power Automate to streamline business processes. Additionally, you will explore how to leverage the capabilities of Power Virtual Agents to create efficient chatbots.

By the end of the course, you will be equipped to learn, demonstrate, and apply Power BI capabilities to build sophisticated reports. Join us on this empowering learning journey to unlock your full potential in the Microsoft Power Platform realm.

What you will learn

  • Learn everything required to pass the PL-900 exam and achieve the Power Platform Fundamentals certification
  • Understand the core components and business value of Microsoft Power Platform
  • Master Power BI capabilities for creating advanced reports and gaining valuable insights
  • Learn Power Apps to design and build customized business applications
  • Gain expertise in Power Automate for streamlined automation of everyday business processes
  • Learn how to effectively communicate the significance of Microsoft Power Platform’s core components

Audience

This course is designed to cater to a diverse range of learners, including students aiming to pass the PL-900 exam and earn the esteemed Microsoft Power Platform Fundamentals certification. Data analysts and business managers seeking insights into the Power Platform’s capabilities will find this course invaluable. Additionally, individuals interested in mastering Power Apps, Power Automate, Power BI, Power Virtual Agents, Dataverse, Connectors, and AI Builder will benefit greatly. If you aspire to receive an official Microsoft certificate, or if you are looking for a comprehensive introduction to the Power Platform, this course caters to your learning needs.

About the Author

HHN Automate Book Inc.: Henry Habib is a seasoned manager at a leading management consulting firm. He leverages his expertise to provide counsel on growth strategy, operation, and analytics to Fortune 500 companies. With a strong background in implementing data-driven solutions, Henry has a proven track record of making an impact in organizations of all sizes.

He strongly advocates for no-code application development in business and deploys such solutions for his clients. These solutions are not only easier to understand but also quicker to implement. In addition to his consulting work, Henry is a dedicated professor who takes pleasure in guiding students toward success in various fields, ranging from case interviews to no-code application development and automation. His courses are designed to be engaging and informative, and he is always available to assist students in mastering challenging concepts.

Table of contents

  1. Chapter 1 : Introduction
    1. Introduction
    2. What Is PL-900?
    3. Course Roadmap and PL-900 Curriculum
    4. Who Am I?
    5. Keys to Success
  2. Chapter 2 : Updates to the Exam for June 22, 2023
    1. Updates to the Exam - June 22, 2023
  3. Chapter 3 : Environment
    1. Create a Trial Account
    2. App Launcher and Power BI Desktop
    3. Quick App Walkthrough
    4. Reference Material
    5. Study Notes
  4. Chapter 4 : LO1: Describe the Business Value of Microsoft Power Platform
    1. 1.1.1 Power BI
    2. 1.1.2 Power Apps
    3. 1.1.3 Power Automate
    4. 1.1.4 Connectors
    5. 1.1.5 Power Virtual Agents
    6. 1.2.1 Dynamics 365 and Power Platform
    7. 1.2.1 Dynamics 365 Connectors
    8. 1.2.2 Microsoft 365 and Power Platform
    9. 1.2.3 Teams and Power Platform
    10. 1.2.4 Azure and Power Platform
    11. 1.2.5 Third-Party Apps and Services
    12. 1.2.6 AppSource
    13. 1.2.6 Demo of AppSource
    14. 1.2.7 How the Different Apps Work Together
    15. 1.3.1 Power Platform Security
    16. 1.3.1 Dataverse Security Roles
    17. 1.3.1 Demo on Dataverse Security Roles
    18. 1.3.1 Security Roles Deep Dive
    19. 1.3.2 Manage Apps, Workflows, and Users
    20. 1.3.3 Environments
    21. 1.3.4 Admin Center Summary
    22. 1.3.4 Demo Microsoft 365 Admin Center
    23. 1.3.4 Power Platform Admin Center
    24. 1.3.5 DLP Introduction
    25. 1.3.5 DLP Demo
    26. 1.3.5 DLP Block Exceptions
    27. 1.3.6 Privacy and Accessibility Guidelines
    28. 1.3.7 Privacy and Accessibility Tools
    29. 1.3.7 Demo of Trust Center and Security Compliance
    30. 1.3.8 Governance Structure
    31. U1.1.6 Power Pages
    32. U1.1.7 AI Builder
  5. Chapter 5 : LO2: Identify the Core Components of Microsoft Power Platform
    1. 2.1.1 Dataverse
    2. 2.1.2 Dataverse for Teams
    3. 2.1.3 Tables, Columns, and Relationships
    4. 2.1.4 Common Data Model
    5. 2.2.2 Actions
    6. 2.2.3 Types of Connectors
    7. 2.2.4 Use Case of Custom Connectors
    8. 2.2.4 Connectors Overall
    9. 2.3.1 AI Builder
    10. 2.3.2 AI Builder Models
    11. 2.3.2 Business Card Examples
    12. 2.3.2 Document Processing Example 1
    13. 2.3.2 Document Processing Example 2
    14. 2.3.2 Document Processing Example 3
    15. 2.3.3 AI Builder and the Power Platform
  6. Chapter 6 : LO3: Demonstrate the Capabilities of Power BI
    1. 3.1.1 Visualization Options 1
    2. 3.1.1 Visualization Options 2
    3. 3.1.1 Visualization Options 3
    4. 3.1.1 Visualization Options 4
    5. 3.1.2 Power BI Desktop Tabs
    6. 3.1.2 Demo of Power BI Desktop Tabs
    7. 3.1.3 Power BI Desktop Versus Power BI Service
    8. 3.1.4 Power BI Service Elements Diagram
    9. 3.1.4 Power BI Service Elements Detail
    10. 3.1.4 Power BI Service Elements Walkthrough
    11. 3.1.5 Power BI Security Model
    12. 3.2.1 Go Through Sample Data
    13. 3.2.1 Load Data into Power Query
    14. 3.2.1 Combine Data
    15. 3.2.2 Assign Data Types
    16. 3.2.2 Replace Values and Clean Data
    17. 3.2.2 Preview Data Columns
    18. 3.2.2 Add Columns
    19. 3.2.2 Walkthrough of Other Clean and Transform Features
    20. 3.2.2 Apply Queries and Add More Data
    21. 3.2.3 Aggregate Functions
    22. 3.2.3 Demo of Aggregate Functions
    23. 3.2.4 Data Sources in Power BI
    24. 3.2.5 Shared Datasets
    25. 3.2.6 Template Apps
    26. 3.2.6 Demo of Template Apps
    27. 3.2.7 Viewing Reports and Dashboards
    28. 3.3.1 Create a New Score Column
    29. 3.3.1 Create Our First Visualization
    30. 3.3.1 Formatting the Visualization
    31. 3.3.1 Build Out Remaining Visualization
    32. 3.3.1 New Page and Card and Gauge Visualization
    33. 3.3.1 Filters and Slicers
    34. 3.3.1 Stacked Bar, Clustered Bar, and Line Chart
    35. 3.3.1 KPI Charts
    36. 3.3.1 Bar Charts
    37. 3.3.1 Buttons
    38. 3.3.1 Publish Dataset and Report
    39. 3.3.1 Quick Clarification
    40. 3.3.2 Create Dashboards
    41. 3.3.2 Edit Dashboards
    42. 3.3.3 Share Reports and Dashboards
    43. 3.3.3 Add Elements to Workspaces
  7. Chapter 7 : LO4: Demonstrate the Capabilities of Power Apps
    1. 4.1.1 App Types
    2. 4.1.2 Use Cases of Formulas
    3. 4.1.2 Functions in Formulas
    4. 4.2.1 Data Sources
    5. 4.2.1 Data Load
    6. 4.2.1 Data Update
    7. 4.2.1 Table Definitions
    8. 4.2.1 Demo of Load Data
    9. 4.2.1 Demo of Update Data
    10. 4.2.1 Delegations
    11. 4.2.2 Connectors Overview
    12. 4.2.3 Create Apps from Data
    13. 4.2.3 Explore Apps
    14. 4.2.4 Common Controls
    15. 4.2.4 Development Environment
    16. 4.2.4 Dynamic Assignment
    17. 4.2.4 Actions and Navigate
    18. 4.2.4 Variables
    19. 4.2.4 Functions and Formulas
    20. 4.2.4 If Statements
    21. 4.2.4 Setting Up the Data
    22. 4.2.4 Connecting to Data
    23. 4.2.4 Data Tables
    24. 4.2.4 Galleries 1
    25. 4.2.4 Galleries 2
    26. 4.2.4 View Forms and Galleries
    27. 4.2.4 Edit Forms 1
    28. 4.2.4 Edit Forms 2
    29. 4.2.4 Filter and Search
    30. 4.2.5 Publish and Share Apps
    31. 4.2.5 Save and Publish Apps
    32. 4.3.1 Model-Driven Apps Introduction
    33. 4.3.1 Add Sample Data
    34. 4.3.1 Demo Create an App from Tables
    35. 4.3.1 Model-Driven App Building Blocks
    36. 4.3.2 Forms
    37. 4.3.2 Demo of Forms
    38. 4.3.3 Views
    39. 4.3.3 Demo of Views
    40. 4.3.4 Publish and Share Model-Driven Apps
    41. 4.3.4 Security Roles
  8. Chapter 8 : LO5: Demonstrate the Capabilities of Power Automate
    1. 5.1.1 Cloud and Desktop and Business Processes
    2. 5.1.1 Types of Flows and How to Choose
    3. 5.1.2 Use Case of Flows
    4. 5.1.2 What Is a Flow
    5. 5.1.2 Flows Can Have Multiple Actions
    6. 5.1.2 Flow Templates
    7. 5.1.2 Demo of Templates
    8. 5.1.3 Connecting Triggers and Actions
    9. 5.1.3 Example Connectors
    10. 5.1.3 Types of Connectors
    11. 5.1.3 Demo of Connectors
    12. 5.1.4 Different Built-In Controls
    13. 5.1.4 Conditions
    14. 5.1.4 Switches
    15. 5.1.4 Loops (Do Until and Apply to Each)
    16. 5.1.5 Expressions Introduction
    17. 5.1.5 Demo of Expressions
    18. 5.1.6 Approvals Introductions
    19. 5.1.6 Approval System
    20. 5.1.6 Prerequisites
    21. 5.1.6 Demo of Approvals
    22. 5.1.7 Power Automate Apps
    23. 5.2.1 Example of Instant, Scheduled, and Automated Flows
    24. 5.2.2 Modify a Cloud Flow
    25. 5.2.3 Data Operations
    26. 5.2.3 Example of Compose
    27. 5.2.3 Example of Parse JSON
    28. 5.2.4 Run a Cloud Flow
  9. Chapter 9 : LO6: Demonstrate the Capabilities of Power Virtual Agents
    1. 6.1.1 Power Virtual Agents and Business Value
    2. 6.1.2 Power Virtual Agents Elements of Topics, Entities, Actions
    3. 6.1.3 Topic Breakdown of Message, Question, Condition, Action Nodes
    4. 6.2.1 Create a Chatbot
    5. 6.2.1 Manage and Delete Bots
    6. 6.2.2 Create a Simple Topic
    7. 6.2.2 Add Entities to Topics
    8. 6.2.3 Power Virtual Agents Actions
    9. 6.2.4 Call a Power Automate Flow from Power Virtual Agents
    10. 6.2.4 Return Variables from Power Automate to Power Virtual Agents
    11. 6.2.5 Publish Power Virtual Agents
    12. 6.2.5 Demo and Publish Power Virtual Agents Bots
  10. Chapter 10 : Updates to the Exam - June 22, 2023
    1. U6.3.1 Power Pages Use Cases
    2. U6.3.2 Power Pages Templates
    3. U6.3.3 1 Power Pages Walkthrough 1
    4. U6.3.3 2 Power Pages Walkthrough 2
    5. U6.4.1 1 AI Builder Models
    6. U6.4.1 2_3 AI Builder and Business Cards
    7. U6.4.1 4 Document Processing 1
    8. U6.4.1 5 Document Processing 2
    9. U6.4.1 6 Document Processing 3
    10. U6.4.1 7 AI Builder and Power Platform
    11. U6.4.2 Lifecycle of AI Builder Model
  11. Chapter 11 : Conclusion
    1. Congratulations
    2. Next Steps

Product information

  • Title: The Complete Masterclass on PL-900 Certification
  • Author(s): HHN Automate Book Inc.
  • Release date: November 2023
  • Publisher(s): Packt Publishing
  • ISBN: 9781805125044