• Hotline: (+84) 939 586 168

    Microsoft Power Platform Fundamentals

    Overview

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

    Duration

    02 days

    Objectives
    Learners should start this course already having the following skills:
    • Describe the Power Platform components
    • Describe Microsoft Dataverse, Connectors and AI builder
    • Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services
    • Identify benefits and capabilities of Power Platform
    • Identify the basic functionality and business value Power Platform components
    • Implement simple solutions with Power Apps, Power Automate, Power BI, and Power Virtual Agents
    Intended Audience

    Candidates for this exam 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.

    Job roleDeveloper

    Preparation for exam: PL-900

    Features: none

    Prerequisites
    • No prerequisites for this course
    Course Outline

    Module 1: Introduction to Power Platform

    Learn about the components of Power Platform, ways to connect data, and how organizations can leverage this technology to create business solutions.

    Lessons

    • Power Platform Overview
    • Module Summary
    After completing this module, students will be able to:
    • Identify when to use each Power Platform component application to create business solutions
    • Learn the value of using Power Platform to create business solutions
    • Learn the components and features of Power Platform

    Module 2: Introduction to Microsoft Dataverse

    Dataverse allows you to delve into powerful, scalable data solutions in the cloud. Learn what makes Dataverse tick and how it can work with the Power Platform to create unique and efficient business solutions.

    Lessons

    • Microsoft Dataverse Overview
    • Module Summary

    Lab: Data Modeling

    • Create Solution
    • Add Existing and Create New Tables
    • Create Relationships
    • Import Data
    After completing this module, students will be able to:
    • Descibe the difference between Dataverse and Common Data Model
    • Explain use cases and limitations of business rules and process flows
    • Explain what environments, tables, columns, and relationships are in Dataverse

    Module 3:  Get Started with Power Apps

    Learn about the value and capabilities of Power Apps, and ways other organizations have leverage this technology to build simple applications for their business.

    Lessons

    • Create Staff Canvas App
    • Complete the App

    Lab: How to build a canvas app, part 1

    • Create Staff Canvas App
    • Complete the App

    Lab: How to build a canvas app, part 2

    • Create Security Canvas App

    Lab: How to build a model-driven app

    • Customize Views and Forms
    • Create Model-Driven Application

    Lab: How to build a Power Apps portal

    • Provision a Power Apps portal
    • Create a Portal Webpage
    • Change the Portal Theme
    After completing this module, students will be able to:
    • Learn how other organizations digitize their processes using Power Apps
    • See Power Apps in action and learn options for making your first app
    • Learn about what Power Apps is and its business value

    Module 4: Get Started with Power Automate

    Learn how users can leverage Power Automate to improve business efficiency and productivity.

    Lessons

    • Power Automate Overview
    • How to Build an Automated Solution

    Lab: Power Automate

    • Create Visit Notification flow
    • Create Security Sweep Flow
    After completing this module, students will be able to:
    • See how Power Automate works and looks from the user's perspective
    • Build a simple flow
    • Learn the business value and features of Power Automate

    Module 5: Get Started with Power BI

    Learn how organizations can use Power BI to easily clean, display, and understand data to ensure better informed decisions.

    Lessons

    • Power BI Overview
    • How to Build a Simple Dashboard

    Lab: How to build a simple dashboard

    • Create Power BI Report
    • Create Power BI Dashboard
    After completing this module, students will be able to:
    • See how Power BI works and looks from the user's perspective
    • Learn how to build a simple Power BI dashboard
    • Describe the business value and features of Power BI

    Module 6: Introduction to Power Virtual Agents

    Learn about the value and capabilities of Power Virtual Agents and ways organizations can leverage this technology to build chatbot solutions for their business.

    Lessons

    • Power Virtual Agents overview
    • How to build a chatbot

    Lab: How to build a basic chatbot

    • Sign up for PVA and Create a New Bot
    • Create Topics
    • Test Topics
    • Change the Greeting
    • Publish the Bot
    After completing this module, students will be able to:
    • Describe the business value and features of Power Virtual Agents
    • Build a basic chatbot
    • Learn essential components that make up Power Virtual Agents and chatbots

    Microsoft Power Platform Functional Consultant

    Overview

    The Power Platform empowers organizations to automate business processes, develop their own rich app experiences, and connect with customers better and faster. In this course, students will learn to perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Power Platform solutions and apps. They will supplement their learnings with hands-on labs to create application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations. Power Platform is comprised of four key products: Power Apps, Power Automate, Power BI, and Power Virtual Agents. In this course, we will cover these four applications in depth, with additional focus on Microsoft Dataverse (formerly Common Data Service), AI Builder, connectors, and portals.

    Duration

    05 days

    Objectives
    After completing this course, students will be able to:
    • Work with an organization to gather requirements and implement Power Platform solutions
    • Build model-driven, canvas, and portal apps
    • Create Power Automate flows
    • Design a simple chatbot using Power Virtual Agents
    • Analyze data using Power BI visualizations and dashboards
    Intended Audience

    A Power Platform Functional Consultant is responsible for performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring Power Platform solutions and apps. The Functional Consultant implements components of a solution that include application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations.

    Job role: Developer

    Preparation for exam: PL-200

    Features: none

    Prerequisites
    Before attending this course, students must have:
    • 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
    Course Outline

    Module 1: Introduction to the Power Platform

    This module will provide the learner with background about the Power Platform and its 4 key components: Power Apps, Power Automate, Power BI, and Power Virtual Agents.

    Lessons

    • Power Platform Overview

    Lab: Validate lab environment

    After completing this module, students will be able to:
    • Identify the key components of the Power Platform
    • Describe the role of a functional consultant

    Module 2: The Functional Consultant role

    In this module, students will learn more about the functional consultant role and the skills required to successfully implement a Power Platform solution for an organization.

    Lessons

    • Consultant skills overview
    • Create and validate documentation
    • Engage stakeholders
    • Perform quality assurance
    • Configure integrations
    After completing this module, students will be able to:
    • Engage stakeholders with demos
    • Create table (entity) relationship diagrams
    • Design integrations
    • Interact with consultant and customer organization teams

    Module 3:  Work with Dataverse

    In this module, students will learn about creating a data model in Microsoft Dataverse, including importing data, using tabular reporting options, and configuring security. They will also learn about creating easy AI with AI Builder.

    Lessons

    • Work with the data model
    • Create and manage processes
    • Work with AI Builder
    • Configure Dataverse settings
    • Import and export data
    • Use tabular reporting options
    • Configure security settings

    Lab: Create an app

    Lab: Create tables and columns

    Lab: Create relationships

    Lab: Additional table options

    After completing this module, students will be able to:
    • Understand tables, columns, rows, and relationships
    • Configure a data model in Dataverse
    • Work in an environment within the Power Platform admin center

    Module 4: Make Power Apps

    In this module, students will learn the business value of the three types of Power Apps. They will then learn to how to configure and design them, including user experience considerations for each type of application

    Lessons

    • Make model-driven apps
    • Make canvas apps
    • Make portal apps

    Lab: App designer

    Lab: Modify forms

    Lab: Modify views

    Lab: Build dashboards

    Lab: Canvas app fundamentals

    Lab: Work with data and services

    Lab: User experience

    After completing this module, students will be able to:
    • Connect to data in Power Apps
    • Build a Power App
    • Design an application user experience

    Module 5: Build Power Automate flows

    In this module, students will learn how to automate business processes using Power Automate flows, business process flows, and UI flows

    Lessons

    • Build flows
    • Build business process flows
    • Build UI flows

    Lab: Create users

    Lab: Create security role

    Lab: Configure a new business rule

    Lab: Advanced business rules

    Lab: Create a flow

    Lab: Build approval flow

    Lab: Build a business process flow

    Lab: Add branching to business process flow

    After completing this module, students will be able to:
    • Create flows
    • Create business process flows
    • Understand UI flows

    Module 6: Work with Power Virtual Agents

    In this module, students will learn how to automate customer interactions with a chatbot using Power Virtual Agents.

    Lessons

    • Create a chatbot
    • Configure topics
    • Automate and integrate
    • Configure entities
    • Test and publish chatbots

    Lab: Create a chatbot

    After completing this module, students will be able to:
    • Create a chatbot
    • Include a flow in a chatbot
    • Create topics and entities

    Module 7: Analyze data with Power BI

    In this module, students will learn how to work with Power BI Desktop and Power BI Service to analyze data and create visualizations

    Lessons

    • Get started with Power BI
    • Model data in Power BI
    • Create visualizations
    • Create dashboards
    • Publish and share in Power BI

    Lab: Build a Word template

    Lab: Build an Excel template

    Lab: Duplicate detection

    Lab: Import data

    Lab: Export data

    Lab: Bulk delete

    After completing this module, students will be able to:
    • Create visualizations
    • Consume data in Power BI
    • Export data visualizations for stakeholders

    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.

    Duration

    05 days

    Objectives
    After completing this course, students will be able to:
    • Create a technical design
    • Configure Common Data Service
    • Create and configure Power Apps
    • Configure business process automation
    • Extend the user experience
    • Extend the platform
    • Develop Integrations
    Intended Audience

    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.

    Job role: Developer

    Preparation for exam: PL-400

    Features: none

    Prerequisites
    Before attending this course, students must have:
    • Candidates should have an introductory knowledge of Power Platfom
    • 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
    Course Outline

    Module 1: Create a model-driven application in Power Apps

    This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.

    Lessons

    • Introduction to model-driven apps and Common Data Service
    • Get started with model-driven apps in Power Apps
    • Create and manage entities in Common Data Service
    • Create and manage fields within an entity in Common Data Service
    • Working with option sets in Common Data Service
    • Create a relationship between entities in Common Data Service
    • Define and create business rules in Common Data Service
    • Create and define calculation or rollup fields in Common Data Service
    • Get started with security roles in Common Data Service

    Module 2: Create a canvas app in Power Apps

    This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.

    Lessons

    • Get started with Power 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

    Module 3:  Master advance techniques and data options in canvas apps

    This module will help you use advanced formulas, perform custom updates, performance checks and testing. It will also help you to improve user's experience, use custom connectors and focus on working with data source limits.

    Lessons

    • Use imperative development techniques for canvas apps in Power Apps
    • Author an advanced formula that uses 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
    • Connecting to other data in a Power Apps canvas app
    • Use custom connectors in a Power Apps canvas app

    Module 4: Automate a business process using Power Automate

    This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.

    Lessons

    • Get started with Power Automate
    • Build more complex flows with Power Automate
    • Introduction to business process flows in Power Automate
    • Create an immersive business process flow in Power Automate
    • Understand advanced business process flow concepts in Power Automate
    • Introduction to expressions in Power Automate

    Module 5: Introduction to developing with Power Platform

    This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform.

    Lessons

    • Introduction to Power Platform developer resources
    • Use developer tools to extend the Power Platform
    • Introduction to extending the Microsoft Power Platform

    Module 6: Extending the Power Platform Common Data Service

    This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.

    Lessons

    • Introduction to Common Data Service for developers
    • Extend plug-ins

    Module 7: Extending the Power Platform user experience Model Driven apps

    This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.

    Lessons

    • Introduction to web resources
    • Performing common actions with client script
    • Automate business process flows with client script

    Module 8: Create components with Power Apps Component Framework

    This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.

    Lessons

    • Get started with Power Apps component framework
    • Build a Power Apps component
    • Use advanced features with Power Apps component framework

    Module 9: Extend Power Apps portals

    This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.

    Lessons

    • Introduction to Power Apps portals
    • Access Common Data Service in Power Apps portals
    • Extend Power Apps portals
    • Build custom Power Apps portals web templates

    Module 10: Integrate with Power Platform and Common Data Service

    This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.

    Lessons

    • Work with Common Data Service Web API
    • Integrate Common Data Service Azure solutions

    Microsoft Power Platform App Maker

    Overview

    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.

    Duration

    03 days

    Objectives
    After completing this course, students will be able to:
    • Design apps and automate workflows
    • Create apps and automate workflows
    • Analyze and visualize data in context of an app or automated workflow
    • Implement and manage apps and automated workflows
    Intended Audience

    The App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies

    Job role: Developer

    Preparation for exam: PL-100

    Features: none

    Prerequisites
    Before attending this course, students must have:
    • Basic data modeling, user experience design, requirements analysis, and process analysis skills.
    • A personal growth mindset and are comfortable using technology to solve business problems.
    • An understanding of the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies
    Course Outline

    Module 1: Create a model-driven application in Power Apps

    This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.

    Module 2: Create a canvas app in Power Apps

    This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it.

    Module 3:  Use the UI and controls in a canvas app in Power Apps

    This module will focus on how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.

    Module 4: Automate a business process using Power Automate

    This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows

    Module 5: Create and use analytics reports with Power BI

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

    Module 6: Get started with AI Builder

    This 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.

    Microsoft Dynamics 365 + Power Platform Solution Architect

    Overview

    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 decisions a Solution Architect makes during an implementation, covering security, integrations, Power Apps architecture, Power Automate architecture, and more. This course is designed to give you an introduction to the Solution Architect role.

    Duration

    03 days

    Intended Audience

    Senior Consultants (both functional and technical) that aspire to be Solution Architects, or current Solution Architects that are new to the role.

    Job roleSolution Architect

    Preparation for exam: MB-600

    Features: none

    Prerequisites
    Before attending this course, students must have:
    • Passed MB-200 Exam
    • Experience with Dynamics 365 and the Power Platform
    • Senior Consultant (functional or technical) or Solution Architect new to role
    • Some knowledge of Microsoft Azure
    Course Outline

    Module 1: Becoming a Solution Architect/Getting to know your customer

    Lessons

    • Define a Solution Architect
    • Role of a Solution Architect on projects
    • Project Methodology
    • Getting to know your customer
    • Group exercise - Getting to know your customer

    Module 2: Conceptualizing the design from requirements

    Lessons

    • How to lead the requirement collection effort
    • Using fit gap analysis
    • Pillars of good architecture
    • Blueprinting the solution architecture
    • Group exercise - Design from requirements

    Module 3:  Project governance and working as a team

    Lessons

    • Solution Architect's role in project governance
    • Techniques for keeping a project on track
    • Scenarios that could cause a project to fail
    • Group exercise - Project governance and working as a team

    Module 4: Power Platform Architecture

    Lessons

    • Key Power Platform architecture components
    • Understand how platform design and limits influence solution architectures
    • Updates and feature releases
    • Understand how to communicate how the platform meets customer needs

    Module 5: Data Modeling

    Lessons

    • Data model influences
    • Data model strategy
    • Data types
    • Data relationships
    • Group exercise - Data modeling

    Module 6: Analytics and artificial intelligence

    Lessons

    • Planning and evaluating requirements
    • Operational reporting
    • Power BI
    • Enterprise BI
    • Pre-built insights and custom AI

    Module 7: Power Apps Architecture

    Lessons

    • Discuss options for apps and how to choose where to start
    • Discuss app composition options
    • Using components as part of your app architecture
    • Considerations for including Portals as an app in your architecture
    • Group exercise - Power Apps Architecture topics

    Module 8: Application Lifecycle Management (ALM)

    Lessons

    • Microsoft vision and Solution Architect's role in ALM
    • Environment strategies
    • Defning a solution structure for your deliverable

    Lab : ALM Hands-on Lab

    Module 9: Power Automate Architecture

    Lessons

    • Discuss options for automation and custom logic
    • Review considerations for using triggers and common actions
    • Explore using Business Process Flows (BPF) to guide users through business processes
    • Group Exercise - Evaluate scenarios for Power Automate usage

    Module 10: Security Modeling

    Lessons

    • Solution Architect's role in security modeling
    • Discovery and learning your client's environment
    • Controlling access to environments and resources
    • Controlling access to CDS Data
    • Group Exercise - Security Modeling

    Module 11: Integration

    Lessons

    • Solution Architects role in Integrations
    • What is an integration and why do we need it
    • Platform features that enable integration
    • CDS Event Publishing
    • Scenarios for group discussion

    Module 12: Dynamics 365 Applications Architecture

    Lessons

    • Solution Architect's role when deploying Dynamics 365 apps
    • Architecture Considerations for primary apps
    • Group Exercise - App specific working groups evaluate requirements

    Module 13: Testing and Go Live

    Lessons

    • Solution Architect's role with testing and go live
    • Planning for testing
    • Planning for go live