Microsoft Power Platform Training

Discover our Microsoft Power Platform learning paths and certifications

Training Course PL-900: Microsoft Power Platform Fundamentals

Overview:

Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate.

Audience Profile:

Candidates for this course are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences.

Certification:

This course prepares you for the PL-900: Power Platform Fundamentals.

Course Objectives:

After completing this course, students will be able to:

Describe the business value of the Microsoft Power Platform.
Identify foundational components of Microsoft Power Platform.
Describe how to build applications with Microsoft Power Apps.
Describe building automation with Microsoft Power Automate.
Describe the capabilities of Microsoft Power BI.
Describe complementary Microsoft Power Platform solutions.

Course Outline

Describe the business value of the Microsoft Power Platform
o Examine Microsoft Power Platform.
o Describe the business value of the Power Platform.
o Explore connectors in Power Platform.
o Review using Microsoft Dataverse to organize business data.
o Examine how Power Platform works together with Microsoft 365 apps and services.
o Explore solutions using Power Platform Microsoft Teams.
o Describe how Power Platform works with Dynamics 365.
o Describe how Power Platform solutions can consume Azure Services.
o Explore how Power Platform apps work together to create solutions.
Identify foundational components of Microsoft Power Platform
o Discover Microsoft Dataverse.
o Learn about the Common Data Model.
o Identify tables, columns, and relationships.
o Learn about environments.
o Discover business rules.
Describe how to build applications with Microsoft Power Apps
o Examine Power Apps.
o Explore canvas applications.
o
Explore model-driven applications.
o Differentiate between canvas and model-driven applications.
o Build a basic canvas app.
o Build a basic model-driven app.
Describe building automation with Microsoft Power Automate
o Examine the capabilities of Power Automate.
o Explore the different Power Automate apps.
o Examine the components of a cloud flow.
o Examine Power Automate scenarios.
o Build a basic cloud flow.
o Build a basic desktop flow.
o Examine the business value provided by Power Automate.
Describe the capabilities of Microsoft Power BI
o Describe the business value and features of Power BI.
o Compare and contrast the different components that make up Power BI.
o Describe how to clean and transform data.
o Examine how AI insights help detect anomalies and spot trends.
o Build a basic dashboard.
o Consume Power BI reports and dashboards.
Describe complementary Microsoft Power Platform solutions
o Describe the capabilities of Power Virtual Agents and the business value it provides.
o Examine the process of building a simple chatbot.
o Describe the capabilities of Power Pages and the business value it provides.
o Examine the process for building a basic site.
o Describe the capabilities of AI Builder and the business value it provides.

Training Course PL-300: Microsoft Power BI Data Analyst

Overview:

This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Audience Profile:

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

Certification:

This course prepares you for the PL-300: Microsoft Power BI Data Analyst.

Course Objectives:

After completing this course, students will be able to:

Discover data analysis.
Get started building with Power BI
Get data in Power BI
Clean, transform, and load data in Power BI
Design a data model in Power BI
Add measures to Power BI Desktop models.
Add calculated tables and columns to Power BI Desktop models.
Use DAX time intelligence functions in Power BI Desktop models.
Optimize a model for performance in Power BI
Design Power BI reports
Configure Power BI report filters.
Enhance Power BI report designs for the user experience.
Perform analytics in Power BI
Create and manage workspaces in Power BI
Manage datasets in Power BI
Create dashboards in Power BI
Implement row-level security.

Course Outline

Discover data analysis.
o Learn about the roles in data.
o Learn about the tasks of a data analyst.
Get started building with Power BI
o Learn how Power BI services and applications work together.
o Explore how Power BI can make your business more efficient.
o Learn how to create compelling visuals and reports.
Get data in Power BI
o Identify and connect to a data source.
o Get data from a relational database, like Microsoft SQL Server
o Get data from a file, like Microsoft Excel
o Get data from applications.
o Get data from Azure Analysis Services
o Select a storage mode.
o Fix performance issues
o Resolve data import errors.
Clean, transform, and load data in Power BI
o Resolve inconsistencies, unexpected or null values, and data quality issues.
o Apply user-friendly value replacements.
o Profile data so you can learn more about a specific column before using it.
o Evaluate and transform column data types.
o Apply data shape transformations to table structures.
o Combine queries.
o Apply user-friendly naming conventions to columns and queries.
o Edit M code in the Advanced Editor.
Design a data model in Power BI
o Create common date tables.
o Configure many-to-many relationships.
o Resolve circular relationships.
o Design star schemas
Add measures to Power BI Desktop models.
o Determine when to use implicit and explicit measures.
o Create simple measures.
o Create compound measures.
o Create quick measures.
o Describe similarities of, and differences between, a calculated column and a measure.
Add calculated tables and columns to Power BI Desktop models.
o Create calculated tables.
o Create calculated columns.
o Identify row context.
o Determine when to use a calculated column in place of a Power Query custom column.
o Add a date table to your model by using DAX calculations.
Use DAX time intelligence functions in Power BI Desktop models.
o Define time intelligence.
o Use common DAX time intelligence functions.
o Create useful intelligence calculations.
Optimize a model for performance in Power BI
o Review the performance of measures, relationships, and visuals.
o Use variables to improve performance and troubleshooting.
o Improve performance by reducing cardinality levels.
o Optimize Direct Query models with table level storage.
o Create and manage aggregations.
Design Power BI reports
o Learn about the structure of a Power BI report.
o Learn about report objects.
o Select the appropriate visual type to use.
Configure Power BI report filters.
o Design reports for filtering.
o Design reports with slicers.
o Design reports by using advanced filtering techniques.
o Apply consumption-time filtering.
o Select appropriate report filtering techniques.
Enhance Power BI report designs for the user experience.
o Design reports to show details.
o Design reports to highlight values.
o Design reports that behave like apps.
o Work with bookmarks.
o Design reports for navigation.
o Work with visual headers.
o Design reports with built-in assistance.
o Use specialized visuals.
Perform analytics in Power BI
o Explore statistical summary.
o Identify outliers with Power BI visuals.
o Group and bin data for analysis.
o Apply clustering techniques.
o Conduct time series analysis.
o Use the Analyze feature.
o Use advanced analytics custom visuals.
o Review Quick insights.
o Apply AI Insights.
Create and manage workspaces in Power BI
o Create and manage Power BI workspaces and items.
o Distribute a report or dashboard.
o Monitor usage and performance.
o Recommend a development lifecycle strategy.
o Troubleshoot data by viewing its lineage.
o Configure data protection.
Manage datasets in Power BI
o Use a Power BI gateway to connect to on-premises data sources.
o Configure a scheduled refresh for a dataset.
o Configure incremental refresh settings.
o Manage and promote datasets.
o Troubleshoot service connectivity.
o Boost performance with query caching (Premium).
Create dashboards in Power BI
o Set a mobile view.
o Add a theme to the visuals in your dashboard.
o Configure data classification.
o Add real-time dataset visuals to your dashboards.
o Pin a live report page to a dashboard.
Implement row-level security.
o Configure row-level security by using a static method.
o Configure row-level security by using a dynamic method.

Training Course PL-400: Microsoft Power Platform Developer

Overview:

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 requirements and solve complex business problems.

Audience Profile:

Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints. Candidates should have development experience that includes JavaScript, JSON, TypeScript, C#, HTML, .NET, Microsoft Azure, Microsoft 365, RESTful Web Services, ASP.NET, and Power BI.

Certification:

This course prepares you for the PL-400: Microsoft Power Platform Developer

Course Objectives:

After completing this course, students will be able to:

How to build your first model-driven app with Dataverse.
Get started with model-driven apps in Power Apps.
Manage tables in Dataverse.
Create and manage columns within a table in Dataverse.
Working with choices in Dataverse.
Create a relationship between tables in Dataverse.
Define and create business rules in Dataverse.
Create and define calculation or rollup columns in Dataverse.
Get started with security roles in Dataverse.
Get started with Power Apps canvas apps.
Customize a canvas app in Power Apps
Manage apps in Power Apps.
Navigation in a canvas app in Power Apps.
How to build the UI in a canvas app in Power Apps.
Use and understand Controls in a canvas app in Power Apps.
Document and test your Power Apps application.
Use imperative development techniques for canvas apps in Power Apps
Create formulas that use tables, records, and collections in a canvas app in Power Apps
Perform custom updates in a Power Apps canvas app.
Complete testing and performance checks in a Power Apps canvas app
Work with relational data in a Power Apps canvas app.
Work with data source limits (delegation limits) in a Power Apps canvas app
Connect to other data in a Power Apps canvas app.
Use custom connectors in a Power Apps canvas app.
Get started with Power Automate.
Build approval flows with Power Automate.
Introduction to expressions in Power Automate.
Introduction to Microsoft Power Platform developer resources.
Use developer tools to extend Microsoft Power Platform.
Introduction to extending Microsoft Power Platform.
Introduction to Dataverse for developers.
Extend plug-ins.
Performing common actions with client script.
Automated business process flows with client script.
Get started with Power Apps component framework.
Build a Power Apps component.
Use advanced features with Power Apps component framework.
Work with Dataverse Web API.
Integrate Dataverse Azure solutions.

Course Outline

How to build your first model-driven app with Dataverse
o Discover the value and key features of Dataverse.
o Learn about the value and key features of model-driven apps.
o Explore sample model-driven template apps.
Get started with model-driven apps in Power Apps
o Learn about model-driven app design.
Manage tables in Dataverse.
o Tables in Dataverse.
o Types of tables that are available in Dataverse.
o Creating a custom table.
o Enabling attachments within a table.
o Which licensing requirements to apply to use each type of table.
Create and manage columns within a table in Dataverse.
o Learn what a column is in Dataverse.
o Learn about the types of columns that are available in Dataverse.
o Add a column to a table.
o Learn what a primary name column is in Dataverse.
o Identify restrictions that are associated with columns.
o Create an auto-numbering column.
o Create an alternate key.
Working with choices in Dataverse
o Learn about choices.
o Explore the standard choices.
o Create a new choice or modify an existing one.
Create a relationship between tables in Dataverse.
o Why you should segment data that is used by your solutions into many tables.
o Why you need to relate one table to another.
o How to build relationships between tables.
o How to select the proper relationship type when you’re building solutions with Dataverse.
Define and create business rules in Dataverse.
o Define business rules in Dataverse.
o Create and manage business rules in Dataverse.
Create and define calculation or rollup columns in Dataverse.
o Define a rollup column.
o Create a rollup column.
o Identify a calculation column.
o Create a calculation column.
Get started with security roles in Dataverse.
o Learn about security roles and apply them to users in an environment.
o Learn how to add users to an environment.
o Understand security concepts in Dataverse.
o Identify default security roles.
o Create a custom role.
o Create a custom security role and assign it to entities and users.
o Learn how to configure Dataverse teams for security.
o Learn how to configure Dataverse group teams for security.
Get started with Power Apps canvas apps.
o Explore how Power Apps can make your business more efficient.
o Learn how to use different technologies to perform different tasks in Power Apps.
o Learn about the different ways to build an app in Power Apps.
o Create your first app from data in an Excel workbook.
o Module 11: Customize a canvas app in Power Apps
o Change the layout of a gallery.
o Change the data that a control shows.
o Change the order in which fields appear.
o Change the control with which a user provides information.
o Explore controls on each screen of an app.
o Format a number as a price.
o Color prices based on their values.
o Explore formulas in a generated app.
Customize a canvas app in Power Apps.
o Change the layout of a gallery.
o Change the data that a control shows.
o Change the order in which fields appear.
o Change the control with which a user provides information.
o Explore controls on each screen of an app.
o Format a number as a price.
o Color prices based on their values.
o Explore formulas in a generated app.
Manage apps in Power Apps
o Learn how to view and restore app versions.
o Explore how to share an app, including permissions and notifications.
o Learn about what environments are, how to create them, and how to manage security.
o Find more information about Power Apps.
Navigation in a canvas app in Power Apps
o Understand how navigation works in a canvas app.
o Use the Navigate and Back functions.
o Understand the different ways these functions can be invoked.
How to build the UI in a canvas app in Power Apps
o Understand the basics of building the UI through themes, icons, control customization, and images.
o Use personalization in a canvas app.
o Understand the differences between the Tablet and Mobile form factors.
Use and understand Controls in a canvas app in Power Apps
o Understand how to use controls in a canvas app.
o Use the different types of controls.
o Understand how Galleries and Forms related to controls.
Document and test your Power Apps application.
o Learn about the different types of test plans and components of a good test plan.
o Identify and discuss optimization tools and performance tuning.
o Learn about the benefits of documenting your application.
Use imperative development techniques for canvas apps in Power Apps
o Understand imperative vs. declarative development.
o Understand the variables in Power Apps
o Understand when to utilize each of the three different types of variables.
Create formulas that use tables, records, and collections in a canvas app in Power Apps
o Utilize formulas that process multiple records.
o Use the Concat function to combine text from multiple records.
o Utilize the Countrows, CountIf, ForAll
o Perform math operations on data in a table.
Perform custom updates in a Power Apps canvas app
o Use the Patch function to update your data.
o Understand how the Defaults function is used to create new records with Patch.
o Utilize the Remove and RemoveIf functions to delete records.
o Determine whether to use Clear and Collect or ClearCollect in their scenario.
Complete testing and performance checks in a Power Apps canvas app
o Use best practices to improve the performance of your app.
o Understand how to best test an app.
o Use fiddler for troubleshooting.
Work with relational data in a Power Apps canvas app
o Understand relational data.
o Use relational data to improve an app user’s experience in Power Apps
o Understand how to use relational data in Microsoft Dataverse
Work with data source limits (delegation limits) in a Power Apps canvas app
o Understand the different limits of different data sources.
o Understand how functions, predicates, and operators all play roles in the limits.
o Use this new understanding to choose the best data source for an app.
Connect to other data in a Power Apps canvas app.
o Understand and use action-based connectors.
o Integrate user information and user-profile information into a canvas app.
o Use Power Automate with Power Apps
Use custom connectors in a Power Apps canvas app.
o Understand custom connectors and the basics of how to build one.
o Understand the custom connector lifecycle.
o Use postman with a custom connector.
Get started with Power Automate.
o Create a flow that automatically saves email attachments.
o Learn how to create a button flow to send yourself a reminder.
Build approval flows with Power Automate
o Create and process approval requests.
o Build a flow that runs at recurring time intervals.
o Create a business process flow with conditions.
Introduction to expressions in Power Automate
o Use one or more functions to create expressions.
o Use functions to retrieve data, change data, evaluate data, and more.
Introduction to Microsoft Power Platform developer resources
o Explain what solution components exist within Microsoft Power Platform.
o Explain key components of Microsoft Dataverse and the Common Data Model.
o Explain what Azure solution elements relate to Microsoft Power Platform.
o Explain what AI Solutions exist as it relates to Microsoft Power Platform.
o Navigate the Developer Guide successfully in support of their Microsoft Power Platform development efforts.
Use developer tools to extend Microsoft Power Platform
o Install NuGet packages available for Microsoft Power Platform development.
o Work with the Configuration Migration tool
o Work with Package Deployer
o Leverage Solution Packager to isolate features.
o Run the Plugin Registration Tool
Introduction to extending Microsoft Power Platform
o Identify which elements architecturally comprise Microsoft Power Platform.
o Learn about the areas of extensibility that are available to customize Microsoft Power Platform through code.
o Discover different approaches to common business scenarios in respect to achieving extensibility by means of configuration versus code.
Introduction to Dataverse for developers
o Explain what functions can be executed against Microsoft Power Platform via Microsoft Power Platform SDKs.
o Perform basic operations against Microsoft Power Platform such as create/read/update/delete operations.
Extend plug-ins.
o Learn how to extend plug-ins.
Performing common actions with client script
o Write client script to perform common actions as listed in the module units.
Automate business process flows with client script.
o Automate business process flow actions by using JavaScript/TypeScript API methods.
Get started with Power Apps component framework.
o Learn about Power Apps component framework architecture.
o Learn about Power Apps component tooling.
Build a Power Apps component.
o Create a custom Power Apps component.
o Create a code component solution package.
o Test and debug a code component.
o Learn key concepts of Dataverse auditing.
Use advanced features with Power Apps component framework.
o Use formatting API in a Power Apps component.
o Use Dataverse web API in a Power Apps component.
Work with Dataverse Web API
o Interact with Dataverse Web API by using Postman.
o Authorize against Dataverse with OAuth.
o Use OData to query data.
Integrate Dataverse Azure solutions
o Publish Dataverse events to Microsoft Azure Service Bus.
o Write a Service Bus Event Listener that consumes Dataverse events.

Discover our Trainings and certifications

Learn new skills to boost your productivity and enable your organization to accomplish more with our Trainings and Certifications.

THINK

Grow your expertise and advance your career