Full Power Platform Training in Middlesbrough

Duration: 5 Days
Course Style: Instructor Led
Technology Vendor: Microsoft

Introduction

This 5 day course, covers all aspects of the power platform, teaching delegates how to produce rich easy to use applications with power apps, automate business processes with Flow, and produce easy to understand powerful reports with Power BI. The course also covers practices for how to integrate them together to create rich highly functional business applications.

Audience

This course is intended for a non-technical audience and does not require any prior knowledge of Power Apps, Flow or Power BI. A good level of computer literacy and a basic knowledge of either databases or excel, will be advantageous.

Learning Outcomes

On course completion delegates will be able to:

• • Understand what the Power Platform is and the function of each part of the Power Platform.
• • Understand the security models for the various parts of the power platform and how to secure them.
• • Create and deploy complex Power Apps.
• • Trigger the start of Flows.
• • Build Flows for your need and integrate with other applications (Outlook, Facebook, SharePoint).
• • Connect Power BI to a wide array of data sources (Excel, SharePoint, SQL and more).
• • Manipulate Data within Power BI.
• • Build and customise rich reports.
• • Create an Application that integrates PowerApps, Flow and Power BI Together.

Course Schedule

This course takes place over 5 days, with each days training building into the next, each of the days will follow a particular topic:

• • Day 1: Introduction to the power platform (and its parts- Power Apps, Flow and Power BI), along with training on securing Power Apps, Flow and Power Bi.
• • Day 2: More in-depth training on the functionality of Power Apps.
• • Day 3: Training on the functionality of Flow, with demonstration of different triggers.
• • Day 4: Specific Focused training on the functionality of Power BI.
• • Day 5: Training on building an application making the most of the strengths of Power Apps, Flow and Power BI.

Course Content

Module 1 – Power Platform Overview

• • What is the Power Platform
• • Understanding the parts of the Power Platform
• • What can the Power Platform be used for
• • Power Platform Licencing

Module 2 – Power Apps Overview

• • What are Power Apps
• • What Power Apps be used for
• • Where do you build Power Apps
• • Where users can access Power Apps
• • Power Apps and permissions

Module 3 – Flow Overview

• • Understanding workflow
• • What is Flow
• • What Flow be used for
• • Where do you build Flows
• • Where do users access Flows
• • Flows and permissions

Module 4 –Power BI Overview

• • What is Power BI
• • What Power BI can be used for
• • Where to access Power BI
• • Power BI and permissions

Module 5 – Creating Power Apps

• • Creating your first Power App
• • Canvass App
• • Model Driven apps
• • Adding control to design surface

Module 6 – Power App Controls (1)

• • Format Controls
• • Validate Controls
• • Data Bind Controls
• • Saving Data
• • Loading Data

Module 7 – Power App Controls (2)

• • Working with the Gallery
• • Json objects
• • Integrating with Flow
• • Advanced Controls
• • Media control

Module 8 –Starting with Flow

• • Creating a Flow
• • Understanding Triggers and Actions

Module 9 –Flow Triggers

• • Flow triggers
• • Flow Manual trigger
• • Flow Dynamic / Automatic Triggers
• • Flow Scheduled Trigger
• • Connect to SQL servers
• • Connect to other sources

Module 10 – Flow Actions (1)

• • Conditions
• • If statements
• • Case Statements
• • Data Threshold

Module 11 – Flow Actions (2)

• • SharePoint Actions
• • Outlook actions
• • Approval Actions

Module 12 – Integrating other apps.

• • Connecting SharePoint to outlook
• • Flow to Facebook
• • Flow to LinkedIn
• • Advanced Flow features

Module 13 – Power BI Data sources

• • Connect to Excel Files
• • Connect to SharePoint lists
• • Connect to Access Databases
• • Updating Document Properties
• • Connect to SQL servers
• • Connect to other sources

Module 14 – Manipulating data

• • Using Json objects
• • Splitting objects
• • Formatting columns
• • Data transformation

Module 15 – Building Reports

• • Using Graphs
• • Using Charts
• • Formatting report
• • Colour Themes

Module 16 – Creating an application using the whole Power Platform

• • Creating a custom form using Power Apps
• • Triggering Flows from Power Apps
• • Using Flow to upload form data to the data source
• • Creating a rich report of form responses from Power BI to use in your Power App

Module 17 – Examples of what you can do next

• • Get an understanding for the systems and tools you can build with the power platform
• • Hands on time with other applications developed in the power platform
• • Time to discuss what the Power Platform can do for your business

Get In Touch

To discuss your Power Platform training needs in Middlesbrough please contact Solutions Developed
+44 (0) 7739870670
mike@solutionsdeveloped.co.uk