07 5630 6555 Support
TTS Logo
1300 667 577       Support
Length
2 Days
Price
$2,200
Audience
End User \ Power Users
This Revision
A
Technology
Microsoft Power Platform
Delivery Method
Instructor Led Classroom
On Demand
NA
Language
English

This course provides students with hands-on experience and an in depth understanding of the Microsoft Power Platform.

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.

Audience profile

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.

At course completion

After completing this course, you will be able to:

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

Lessons 

  • Overview
  • The components of the Power Platform
  • Common Data Services
  • The power of PowerApps
  • Model driven Apps
  • Canvas Apps
  • Integration with Microsoft Flow
  • Gaining insights with PowerBI
  • Where to get Help
  • Further reading and resources

Lab 1: Setting up your lab environment

  • Explore the Lab environment

Lab 2: Power Platform Orientation 

  • Explore the Power Platform
  • Explore PowerApps
  • Explore Flow
  • Explore PowerBI

 

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.

Lessons 

  • Overview
  • Creating a custom Model
  • PowerApps Tools
  • Security considerations
  • Connecting to CDS
  • Creating a custom App
  • Publishing your App

Lab 1: Creating the Model

  • Create a custom Model using Common Data Services (CDS)

Lab 2: Create a custom PowerApp

  • Create a custom app using the PowerApps Tools
  • Publish your custom App

 

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.

Lessons 

  • Overview
  • Model driven apps in Dynamics 365
  • The Unified Client Interface
  • The App Designer
  • The Site Map Designer
  • Dynamics 365 Solutions
  • Security considerations
  • Making customizations
  • Create a custom Dynamics 365 App
  • Publishing your Dynamics 365 App

Lab 1: Create a custom App in Dynamics 365

  • Model customizations
  • Using the App Designer
  • Using the Site Map Designer
  • Publishing your App
  • Enabling security

 

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.

Lessons

  • Overview
  • PowerApps and Microsoft Flow
  • Dynamics 365 and Microsoft Flow
  • Microsoft Flow Templates
  • Microsoft Flow Services
  • Best Practice considerations
  • Security considerations 

Lab 1: Connect PowerApps and Microsoft Flow 

  • Create a Microsoft Flow workflow in PowerApps

Lab 2: Connect Dynamics 365 and Microsoft Flow

  • Create a Microsoft Flow workflow in Dynamics 365

 

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.

Lessons

  • Overview
  • Connecting PowerBI and Common Data Services
  • Creating a Report in the PowerBI Service
  • Creating a Dashboard in the PowerBI Service
  • Sharing your Dashboard
  • Security considerations

Lab 1: Create a PowerBI Report

  • Connect PowerBI to a CDS Model
  • Create a PowerBI Report
  • Share a PowerBI Dashboard

 

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.

Lessons

  • Overview
  • Power Platform integration scenarios
  • Integrating PowerApps and Dynamics 365
  • Integrating PowerBI and Dynamics 365
  • The Microsoft Flow Connectors
  • Custom Integration scenarios

Lab 1: Event Management Solution

  • Build a custom Event Management PowerApp

 

Prerequisites

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.