Microsoft Power Platform 1-Week Intensive Training Course

The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow.

  • Power BI offers true Self-Service BI, enabling business users to interact with corporate information and to extract the reports and intel they need.
  • Microsoft Flow enables organizations to develop zero-code, customized business applications easily and rapidly. Users can choose from a wide variety of automation templates or create flows from scratch.
  • Microsoft PowerApps is a technology which enables both developers and business users to build line of business (LOB) applications, with little or no coding, which can connect to a wide range of data sources.

This one-week, intensive course provides a thorough introduction to the Microsoft Power Platform and is aimed at general business users. Delegates will learn how to use the Power Platform to gain insights from their data and to use these insights to automate their business processes.
We run this scheduled Power BI training course at our London training centre every month. We can also deliver onsite Power BI training direct to your offices, anywhere in the UK.

Power Platform 1-Week Intensive Course:
Next London Dates

5-9 August 2019
7-11 October 2019
25-29 November 2019

Power BI Training

Course Outline

Power BI

Getting started

The key components of Power BI; What is Power BI Desktop; The Power BI service; Power BI free vs Power BI Pro; Power BI vs Excel add-ins; Dashboards, reports and datasets

Connecting to software services

Understanding content packs for services; Google Analytics content pack; Salesforce content pack; Microsoft Dynamics CRM content pack

Getting data into Power BI

Connecting to data sources in the Power BI service; Connecting to data sources in Power BI Desktop; Importing excel workbooks; Importing Access databases; Connecting to SQL Server

Cleaning up and transforming data

Using the Query Editor; Creating a query; Understanding query steps; Automatically generated steps; Removing query steps; Modifying query steps; Renaming columns; Reordering and removing columns; Changing data types; The close & apply command

Data modelling

Working in data view; Working in relationship view; Auto-detection of table relationships; Creating table relationships manually; Setting cardinality; Cross filter direction

Using DAX

Creating Calculated columns; Creating measures; Understanding row context; Understanding filter context; The SUMX function; The CALCULATE function; The ALL function; The FILTER function; Using time intelligence functions

Creating reports

Working in report view; Creating tables and key metrics; Working with matrixes; Filtering data with slicers

Creating visualizations

Creating column and bar charts; Creating line and area charts; Creating scatter charts; Treemap visualizations; Using charts as slicers; Using maps with geographical data; Using custom visuals in your reports

Publishing content

Publishing Power BI Desktop reports; Printing and exporting dashboards and reports; Creating Groups in the Power BI service; Creating content Packs; Assigning groups to content packs; Sharing dashboards with your organization; Publishing reports to the web; Embedding a report in a web page

Creating Power BI Mobile Content

Optimising visuals for small viewports; Creating a phone version of a dashboard; Creating phone-optimised reports

Consuming and customizing content

Browsing group content; Using content packs; Creating read-only versions; Using Quick Insights in Power BI; Creating dashboards from your reports; Querying with natural language; Creating custom Q & A suggestions

Refreshing content

Setting up a personal gateway; Customizing dataset refresh settings; Scheduling a refresh frequency; Setting up enterprise gateways; Managing enterprise gateways; Adding and removing data sources, Creating live connections to data

Microsoft Flow

Introduction

What is Microsoft Flow?
Types of flow
Understanding connectors
Understanding triggers
Understanding actions
Testing a flow

Using Flow Templates

Using and editing templates
Copy files to OneDrive for Business when they’re added to OneDrive
Save Office 365 email attachments to OneDrive for Business
Submit Form Response to SharePoint List

Using the Flow Mobile App

The activity feed
Editing a flow
Using button flows
Adding a button flow from your mobile

Button Flows

What are button flows?
Create a button flow from the Flow portal
Create a button flow from your mobile device
Get a push notification when you get an email
Receive a push notification from flow

Approval Flows

How Flow approvals work
Adding an approval action
Specifying who approves
Adding conditions
Add an approval status action
Creating Recurring Flows

Recurrence

Having a flow run repeatedly
Running a flow at a specified time
Running a flow after a specified time

Control Structures

Adding a condition
Combining logical conditions
Using expressions in conditions
Using Do Until
Building flows with parallel steps

Connecting to On-Premises Data

Installing an on-premises data gateway
Configuring a gateway
Connecting to an on-premises SQL Server database
Connecting to a local file system
Sharing a gateway with other users

Power BI Integration

Responding to Power BI data alerts
Add rows to a dataset
Transform data using Power Query

PowerApps

Getting Started

What is Microsoft PowerApps?
PowerApp subscriptions
PowerApps data connectors
Records and tables
Canvas apps vs model-driven apps
Using the PowerApps Desktop Editor

Data Sources

Connecting to Excel tables
Connecting to SharePoint lists
Connecting to SQL Server
Connecting to on-premises data
Installing and configuring a data gateway

Working with Galleries

Customizing gallery layout
Customizing gallery layout
Specifying sort and search columns
Displaying a scroll bar

Forms and Cards

Edit form and display form controls
Showing and hiding forms
Adding and manipulating cards
Using pre-defined cards
Reordering cards
Unlocking cards
Modifying the Display Name property
Modifying the Data Field property
Setting the Update property
Setting the Required property

Working with Other Controls

Understanding controls and properties
Labels and text inputs
Drop downs, combo boxes and list boxes
Column charts and pie charts
The Add picture control
The Date picker control

PowerApps Formulas

Control properties and formulas
Values, operators and functions
Manipulating user input
Using formulas for conditional formatting
Using formulas to perform actions

Sharing Apps

Publishing an app
Sharing with individuals
Sharing with security groups
Granting co-worker permission

Power BI Integration

Overview of Power BI integration
Sharing and security
Using the Power BI tile control
Using the PowerApps custom visual
Embedding an app in a Power BI dashboard tile