PL-200 Microsoft Power Platform Functional Consultant (PL-200T00)

Seminarinformationen

Seminar - Ziel

This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.

Teilnehmer - Zielgruppe

A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.

Kurs - Voraussetzungen

  • Experience as an IT professional or student
  • Working knowledge of the Power Platform and its key components
  • A knowledge of Microsoft Dataverse (or general data modeling) and security concepts.

Seminardauer

  • 4 Tage
  • 09:00 Uhr bis 17:00 Uhr

Schulungsunterlagen

  • nach Absprache

Seminar-Inhalt / Agenda

Introduction to Microsoft Power Platform

Learn about the components of Microsoft Power Platform, the business value for customers, and security of the technology.

In this module, you will:

  • Learn the components and features of Microsoft Power Platform
  • Identify when to use each Microsoft Power Platform component application to create business solutions
  • Understand connectors
  • Learn the value of using Microsoft Power Platform to create business solutions

Create tables in Dataverse

Dataverse lets you securely store and manage data that's used by business applications. Standard and custom tables within Dataverse provide a secure and cloud-based storage option for your data.

In this module, you will:

  • Create tables with Dataverse
  • Import data into a Dataverse database

Manage tables in Dataverse

Dataverse tables are similar to tables in a database. Every instance of a Dataverse database includes a base set of tables that provide structure for data that is commonly used by business applications.

In this module, you'll learn about:

  • Tables in Dataverse.
  • Types of tables that are available in Dataverse.
  • Creating a custom table.
  • Enabling attachments within a table.
  • Which licensing requirements to apply to use each type of table.

Create and manage columns within a table in Dataverse

Do you want to create new data columns or use existing standardized columns for your business solutions? This module will show you how to manage or create new columns within a table in Dataverse.

In this module, you will:

  • Learn what a column is in Dataverse.
  • Learn about the types of columns that are available in Dataverse.
  • Add a column to a table.
  • Learn what a primary name column is in Dataverse.
  • Identify restrictions that are associated with columns.
  • Create an auto-numbering column.
  • Create an alternate key.

Create a relationship between tables in Dataverse

Do you need to create relationships between tables? This module will show how and why you can separate data into tables and how to relate between tables to build complex and robust business solutions. It will also explain the different kinds of relationships that you can define between tables in Dataverse.

In this module, you will learn:

  • Why you should segment data that is used by your solutions into many tables.
  • Why you need to relate one table to another.
  • How to build relationships between tables.
  • How to select the proper relationship type when you are building solutions with Dataverse.

Working with choices in Dataverse

Do you want to create standardized choice lists that you can use across all of your Power Apps? This module will show you how to create new or use standard choice lists called choices in Dataverse.

In this module, you will:

  • Learn about choices.
  • Explore the standard choices.
  • Create a new choice or modify an existing one.

Get started with security roles in Dataverse

Do you want to use security roles to limit user permissions? This module will show you how you can set permissions to limit access to an environment. Or limit which users can view, edit, or delete data in an environment within Dataverse.

In this module, you will:

  • Learn about security roles and apply them to users in an environment.
  • Learn how to add users to an environment.
  • Understand security concepts in Dataverse
  • Identify default security roles.
  • Create a custom role.
  • Create a custom security role and assign it to entities and users.
  • Learn how to configure Dataverse teams for security
  • Learn how to configure Dataverse group teams for security

Use administration options for Dataverse

Do you need to use administration options that are available for Dataverse? This module will show you how you can use solutions within Dataverse and administer environments.

In this module, you'll learn how to:

  • Administer Dataverse.
  • Identify the different portals that are available for Dataverse.

Manage Dynamics 365 model-driven app settings and security

In this module, students will learn about the role-based security model. They will also learn how to explore and navigate Dynamics 365 settings and configure a theme for the application.

At the end of this module, you will be able to:

  • Manage role-based security
  • Explore customization functionality and customize themes

Introduction to Microsoft Power Platform security and governance

Do you want to learn about how to help secure and govern Microsoft Power Platform apps like Power Automate and Power Apps? This module focuses on introducing Microsoft Power Platform environments and their role in creating Data Loss Prevention (DLP) policies by using examples and use cases. A brief introduction and overview of tools will also be discussed, including Microsoft Power Platform and Power Automate Admin experiences and Microsoft Power Platform Center of Excellence (COE) toolkit.

In this module, you will:

  • Access Microsoft Power Platform admin experiences.
  • Create simple environment and tenant-wide DLP policies.
  • Discover and identify the differences between the Business data group and the No-business data group.
  • Learn about the differences between out-of-the-box Power Automate Admin experiences and Microsoft Power Platform Center of Excellence toolkit.

Get started with model-driven apps in Power Apps

Model-driven app design is an approach that focuses on quickly adding components to your apps. These components include dashboards, forms, views, and charts. With little or no code, you can make apps that are simple or complex.

In this module, you will:

  • Learn about model-driven app design
  • Create a model-driven app

Configure forms, charts, and dashboards in model-driven apps

In this module, you'll learn about forms, grids, views, charts, and dashboards that can be used in model-driven apps.

In this module, you will:

  • Learn about form elements and controls
  • Configure forms
  • Use specialized form components
  • Use editable grids
  • Identify views and use public views
  • Learn how to configure charts
  • Learn how to configure dashboards

Get started with Power Apps canvas apps

Learn the basics of Power Apps and how you can use it in your organization.

In this module, you will:

  • Explore how Power Apps can make your business more efficient.
  • Learn how to use different technologies to perform different tasks in Power Apps.
  • Learn about the different ways to build an app in Power Apps.
  • Create your first app from data in an Excel workbook.

Connect to other data in a Power Apps canvas app

Do you need to connect to data that isn't tabular? This module will help with that. It includes discussion of action-based connectors, Flow, and user data.

In this module, you'll:

  • Understand and use action-based connectors
  • Integrate user information and user-profile information into a canvas app
  • Use Power Automate with Power Apps

How to build the UI in a canvas app in Power Apps

Do you want to build a better UI for app users? This module helps you do that using themes, icons, images, personalization, different form factors, and controls.

In this module, you will:

  • Understand the basics of building the UI through themes, icons, control customization, and images.
  • Use personalization in a canvas app
  • Understand the differences between the Tablet and Mobile form factors

Manage apps in Power Apps

Manage app versions, app sharing, and environments in Power Apps.

In this module, you will:

  • Learn how to view and restore app versions.
  • Explore how to share an app, including permissions and notifications.
  • Learn about what environments are, how to create them, and how to manage security.
  • Find more information about Power Apps.

Build your first app with Power Apps and Dataverse for Teams

Today’s business problems increasingly require modern digital solutions. With a low-code platform, anyone with a great idea can build a digital app. Dataverse for Teams allows you to build modern digital apps and deploy them to help you and your team solve those problems.

In this module, you will:

  • Create an app by using the hero template.
  • Customize and publish your app.
  • Install templates.

Core components of Power Apps portals

Extend Dataverse interaction to external and internal audiences such as customers, partners, and employees. Use portals to set up an interactive, web-based sales, services, support, and social engagement application platform to connect with customers, engage with communities, manage site content, and empower your channel partners. Empower anyone inside or outside your organization to interact with Dataverse data by using portals.

In this module, you will:

  • Identify the capabilities of portal solutions.
  • Review the portal provisioning process.
  • Learn about Power Apps portals core components and tools.
  • Discover how to control user access to portal content and Dataverse data

Explore Power Apps portals

Dynamics 365 starter portals are pre-configured portal solutions that are available to help accelerate deployment. Typical portal projects will have unique requirements, but a starter portal provides an environment that is immediately suitable for specific scenarios and audiences.

In this module, you will:

  • Identify the features of the Community portal.
  • Discover the features of the Customer self-service portal.
  • Learn about the features of the Employee self-service portal.
  • Review the features of the Partner portal.
  • Identify the features of the Portal from blank.
  • Learn about licensing requirements when portals are used by employees.
  • Learn about the process to incorporate specific features from different starter portals to another portal type or the custom portal.

Power Apps portals architecture

This module focuses on the Power Apps portals architecture, such as how the various components work together to build a portal. Additionally, it explains how the components are installed and come to together in a working portal. The module also describes the maker and configuration tools that you can use to build and customize Power Apps portals.

In this module, you will:

  • Identify the key components of the Power Apps portals architecture.
  • Learn about the portal provisioning process.
  • Differentiate the various maker tools, their purposes, and when to use each particular tool.

Access Dataverse in Power Apps portals

The ability to show and interact with Dataverse data on a website is a core benefit of implementing a Microsoft Power Apps portal. This module focuses on the several techniques and methods to display and interact with Dataverse data in Power Apps portals.

In this module, you will:

  • Discover the portal components that are available to display and interact with Dataverse data on the portal.
  • Identify the various features of the portal components.
  • Display a list of data and an associated drill-down for details.
  • Configure a table form to access individual records.
  • Trigger classic Dataverse workflows from the portal.

Authentication and user management in Power Apps portals

An individual, external user might have several identities from which to choose when registering and accessing a portal. Portal users can be onboarded in many ways, and several options are available to portal users for validating their identity and maintaining their profiles. Microsoft Power Apps portals supports a variety of authentication options and provides powerful user-management capabilities. Administrators can choose between using local authentication or delegating authentication to a trusted authentication provider. Power Apps portals supports multiple authentication providers and various industry standards.

In this module, you will:

  • Explore common authentication tasks in a Power Apps portal deployment.
  • Learn about portal contact extensions.
  • Configure and register contacts as portal users.
  • Align portal authentication settings with the business requirements.
  • Identify authentication provider capabilities and steps that are involved in the registration.
  • Select and configure identity providers.

Power Apps portals maintenance and troubleshooting

When building a Microsoft Power Apps portal, administrators should consider various techniques, best practices, and features. This module will cover the various troubleshooting tools that are available and explain the importance of using the Portal Checker tool.

In this module, you will:

  • Apply strategies and techniques to troubleshoot portal issues.
  • Learn about how the Portal Checker works and how to resolve potential portal issues.
  • Perform the portal update process.

Define and create business rules in Dataverse

The ability to build business rules that ensure consistent business logic whatever app is accessing that data set is imperative to a successful business operation. This module will show you how you can build business rules that are triggered anytime they're used within Dataverse.

In this module, you'll learn how to:

  • Define business rules in Dataverse.
  • Create and manage business rules in Dataverse.

Get started with Power Automate

Power Automate is an online workflow service that automates actions across the most common apps and services.

In this module, you will:

  • Create a flow that automatically saves email attachments
  • Learn how to create a button flow to send yourself a reminder

Use the Admin center to manage environments and data policies in Power Automate

Tenant and environment admins use the Power Automate Admin center to manage data policies and environments for Power Automate deployments.

In this module, you will:

  • Learn about the Admin center
  • Learn how to import and export flows
  • Learn how to share flows

Use Dataverse triggers and actions in Power Automate

This module introduces the triggers and actions that you can use to build flows in Power Automate with Dataverse.

In this module, you will:

  • Learn about the Dataverse triggers and actions in Power Automate.
  • Discover the additional inputs that are available.

Extend Dataverse with Power Automate

This module explains how to create your first flow in Power Automate with triggers and actions from Dataverse.

In this module, you will:

  • Build flows with Dataverse.
  • Integrate Dataverse with Microsoft Outlook.
  • Integrate Dataverse with Microsoft To Do.

Introduction to expressions in Power Automate

Get the most out of your data using functions to create expressions.

In this module, you will:

  • Use one or more functions to create expressions.
  • Use functions to retrieve data, change data, evaluate data, and more.

Build your first Power Automate for desktop flow

This module introduces the basics of Power Automate for desktop flows and explains how to build the first flow to help automate a repetitive task.

In this module, you will:

  • Learn about Power Automate for desktop flows.
  • Learn how to create a new desktop flow.
  • Record actions that are performed in the desktop-based Contoso Invoicing application.
  • Perform a test run of the new desktop flow.

Run a Power Automate for desktop flow in unattended mode

When building robotic process automation (RPA), you can't always monitor the flow. This module demonstrates the solution for this issue by explaining how to run your UI and API flows unattended.

In this module, you will:

  • Run a basic desktop flow in unattended mode.
  • Run a desktop flow and cloud flow scenario in unattended mode.
  • Learn best practices and setup for unattended desktop flows.

Introduction to business process flows in Power Automate

Do you want to create business process flows? This module will discuss what business process flows are and how to use them to solve business solutions. You will discover why automating the business process is important to organizations and how to build business process flow solutions by using Microsoft Power Platform and Dataverse. Additionally, you will learn how business process flows differ from regular Power Automate workflows and when to use each.

In this module, you will:

  • Discover why standardizing business process flows is important and valuable to an organization.
  • Learn about the difference between a workflow and a business process.
  • Find out about how business process flows are used within Microsoft Power Platform and Dataverse.

Advanced concepts to improve business process flows in Power Automate

Do you want to improve your business process flow? This module introduces more advanced business process flow concepts and techniques that you can use to help improve your flow.

In this module, you will:

  • Learn about branching logic.
  • Create additional fields and a main form to enhance a business process flow.
  • Discover how to use instant flows with business process flows.
  • Enhance immersive business process flows by using advanced techniques.

Optimize your business process with process advisor

With the process advisor capability in Power Automate, you can record existing business processes and analyze them to increase efficacy by tracking completion times and mapping various actions that are involved. The first step to automating a solution is knowing the process, and process advisor helps simplify that task.

In this module, you will:

  • Create your first recording.
  • Edit recordings and group actions.
  • Analyze recordings and interpret results.

Get started with Power Virtual Agents bots

Create a Microsoft Power Virtual Agents bot in this module.

In this module, you will:

  • Create Power Virtual Agents bots.
  • Test Power Virtual Agents bots.
  • Analyze performance.

Enhance Power Virtual Agents bots

Microsoft Power Virtual Agents helps you quickly enhance your bot’s functionality to make it even more powerful. This module examines methods that you can use to enhance your Power Virtual Agents bots.

In this module, you will:

  • Initiate Power Automate flows directly from topics in your bot.
  • Configure bots to pass conversations to applications such as Omnichannel for Customer Service.
  • Extract content from support pages and configure it into bot topics that you can use in conversations.

Manage topics in Power Virtual Agents

Microsoft Power Virtual Agents uses trigger phrases in bots to identify when to present a topic to a customer. This module will examine how you can use topics to create and manage conversation paths in a bot.

In this module, you will:

  • Work with bot topics and branch a topic.
  • Use entities in a conversation.
  • Use variables across topics.
  • Use a fallback topic rather than triggering an escalation.
  • Manage a topic status, copy topics, and resolve topic errors.

Manage Power Virtual Agents

Learn how to implement no-code chatbots to solve common customer issues.

In this module, you will:

  • Create and configure a new bot.
  • Set permissions and security.
  • Use topics and entities.
  • Import and export bots.
  • Authenticate users.

Get started building with Power BI

Learn what Power BI is, including its building blocks and how they work together.

In this module, you will:

  • Learn how Power BI services and applications work together.
  • Explore how Power BI can make your business more efficient.
  • Learn how to create compelling visuals and reports.

Get data with Power BI Desktop

How can you find, collect, and clean data from different sources? Power BI is a tool for making sense of your data. You will learn tricks to make data-gathering easier.

In this module, you will:

  • Explore the data-centric features and tools of Power BI.
  • Explore ways to find data.

Model data in Power BI

Connect Power BI to multiple data sources to create reports. Define the relationship between your data sources.

In this module, you will:

  • Create relationships between your data sources
  • Create a new field with calculated columns
  • Optimize data by hiding fields and sorting visualization data
  • Create a measure to perform calculations on your data
  • Use a calculated table to create a relationship between two tables
  • Format time-based data so that you can drill down for more details

Use visuals in Power BI

Create and customize visuals to present data in compelling and insightful ways.

In this module, you will:

  • Explore Power BI visuals
  • Create visuals

Explore data in Power BI

Turn your business intelligence data into data insights by creating and configuring Power BI dashboards.

In this module, you will:

  • Upload reports
  • Create dashboards
  • Ask questions of your data

Publish and share in Power BI

Publish and share your Power BI reports and dashboards to teammates in your organization or to everyone on the web.

In this module, you will:

  • Publish reports
  • Print and export reports
  • Build apps
  • Integrate with OneDrive
  • Publish to the web

Manage solutions in Power Apps and Power Automate

Microsoft Power Apps and Power Automate include such package features as apps from Microsoft Power Apps, site maps, flows, entities, customer connectors, and more. In this module, you'll learn how to manage solutions with Power Automate.

In this module, you will:

  • Package existing items into a solution.
  • Create solutions.
  • Edit existing solution-aware apps, flows in a solution.
  • Import and export solutions.
  • Deploy complex solutions with many components.

Load/export data and create data views in Dataverse

Dataverse lets you load data into or export tables from other tables by using Microsoft Excel. You can also create views to quickly review data that is stored within a table.

In this module, you will:

  • View data within a table.
  • Create or edit views of data in a table.
  • Load data into a table.
  • Export data from a table.
  • Add, update, or delete data in a table by using Excel.
  • Import data using Power Query in Maker Portal
  • Generate a new dataflow from an Excel Template
  • Learn about dataflows and Azure integration

Get started with AI Builder

This self-paced module helps you build an AI model from the beginning and shows how you can use it in your business without writing a single line of code.

In this module, you will:

  • Explore how AI Builder can help improve your business performance.
  • Learn how to use different AI technologies to enhance your processes.
  • Create your first model.
  • Learn how to use your models in Power Apps and Power Automate.

Manage models in AI Builder

Understand your model, model versions, and model sharing in AI Builder.

In this module, you will:

  • Learn about the lifecycle of a model.
  • Learn how to manage model versions.
  • Explore how to share a model, including permissions.
  • Get a better understanding of AI Builder.

Use AI Builder in Power Automate

Learn the basics of AI Builder usage in Power Automate and how it can benefit your organization. 

In this module, you will:

  • Explore how using AI Builder in Power Automate can save you time. 
  • Learn how to use AI Builder actions in Power Automate.
  • Discover advanced AI Builder usage in Power Automate.

Functional Consultant skills

Learn about the functional consultant role and the key skills needed to be successful in this role on a Microsoft Power Platform project.

In this module, you will:

  • Learn the key responsibilities and skills of the functional consultant role on a project that involves Microsoft Power Platform.
  • Learn about creating entity relationship diagrams, wireframes, and mockups for apps, documenting requirements and solution artifacts, and documenting details of data for migration and integration.
  • Understand how functional consultants are expected to engage with stakeholders, perform quality assurance, and configure integrations on projects.

Weitere Schulungen zu Thema Microsoft Power Platform

PL-100 Microsoft Power Platform App Maker (PL-100T00)

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course may contain a 1-day Applied Workshop that is in preview. This workshop will allow you to practice ...

PL-400 Microsoft Power Platform Developer (PL-400T00)

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business ...

PL-600 Power Platform Solution Architect (PL-600T00)

- u.a. in Hannover, München, Wien, Essen, Darmstadt

The Solution Architect is responsible for the successful design, implementation, deployment and adoption of an overall solution. The Solution Architect ensures that the solution meets the customer’s needs now and in the future. In this course, students will learn about ...

MOC 55265 Microsoft PowerApps

- u.a. in Berlin, Köln, Leipzig, München, Darmstadt

Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business. This course may earn a Credly Badge. After ...