The main components of the Microsoft Power Platform are presented and introduced, including PowerApps, Flow, PowerBI and Dynamics 365. Students will gain a detailed understanding of the individual products as well as where each product fits in to create a holistic business solution.
The concept of model driven apps is presented through Dynamics 365, the flexibility of PowerApps for data capture, automation of key business processes using Flow, and the power of data visualization through PowerBI.
No previous experience of the Microsoft Power Platform is needed to sit this course. This course applies to power and technical users and provides at foundation for subsequent learning and courses.
This course has been designed to apply to technical users of the Microsoft Power Platform.
It is recommended that attendees of this course have an existing working knowledge of Microsoft Office, Microsoft Excel and Microsoft Outlook. However, this course assumes no prior knowledge of Microsoft Power Platform.
Be familiar with the main features of Microsoft Power Platform, including PowerApps, Microsoft Flow, PowerBI and Dynamics 365.
Understand how each component of the Microsoft Power Platform contributes to a holistic business solution.
Understand the concept of Model driven apps and Common Data Services (CDS).
Construct a custom Model using the Common Data Services (CDS).
Create a Model driven custom business app with PowerApps.
Create a Model driven custom App in Dynamics 365.
Construct a business process in a Microsoft Flow.
Connect Microsoft Flow to Dynamics 365 and PowerApps.
Using Microsoft Flow Templates and Services.
Building Microsoft Flow Conditions.
Build a PowerBI Report and Dashboard.
Surface PowerBI Dashboards inside a Dynamics 365 App.
Integrate PowerBI with PowerApps.
Integrate PowerApps and Dynamics 365.
Module 1: Introduction
This module provides the attendee with an introduction to the Microsoft Power Platform.
Lab 1: Setting up your lab environment
Lab 2: Power Platform Orientation
Module 2: PowerApps and Common Data Services
This module presents the concept of Common Data Services and the Power Platform. We examine how to create a custom Model-driven App that connects to data via CDS using tools in PowerApps.
Lab 1: Creating the Model
Lab 2: Create a custom PowerApp
Module 3: Dynamics 365 and Common Data Services
This module steps through the process to create a custom app in Dynamics 365. You will learn how to use the App Designer to construct a task specific app and connect to a custom Model using Common Data Services. You will also learn how to publish a security enabled app.
Lab 1: Create a custom App in Dynamics 365
Module 4: Connect and automate with Microsoft Flow
In this module we will learn how to use Microsoft Flow with apps created in PowerApps and Dynamics 365 to automate business process. Microsoft Flow Connectors, Templates and Services will also be considered.
Lab 1: Connect PowerApps and Microsoft Flow
Lab 2: Connect Dynamics 365 and Microsoft Flow
Module 5: Gain insights with PowerBI
In this module we will learn how to create Reports and Dashboards in Microsoft PowerBI. You will also learn how to connect PowerBI to a Model in Common Data Services.
Lab 1: Create a PowerBI Report
Module 6: Build a PowerApp
This module looks at the process to create an end-to-end business solution using the Microsoft Power Platform. We look at the integration points that exist between Common Data Services, PowerApps, Dynamics 365, Microsoft Flow and PowerBI to create an holistic solution for your business.
Lab 1: Event Management Solution
Before attending this course, students must have:
A working knowledge of Microsoft Office, Microsoft Excel and Microsoft Outlook. However, this course assumes no prior knowledge of Microsoft PowerBI.