Our Microsoft Power Platform Training consists of three modules: Power BI, PowerApps, and Power Automate.
- 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 Power Automate 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.
If you have several staff members that need to complete this training, we can arrange a private instructor-led online training course tailored to the requirements of your organisation. Each person is given remote access to a computer in our training centre and provided with lots of opportunities to practice all of the techniques being taught remotely. This means that your staff can attend a course either in the office or from home.
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 Power Automate
Introduction
What is Microsoft Power Automate?
Types of flow
Understanding connectors
Understanding triggers
Understanding actions
Testing a flow
Using Power Automate 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 Power Automate 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 Power Automate 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 Power Automate 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
On-site Microsoft PowerApps and Power Automate Training
N.B. For the moment, we have replaced on-site training with private online courses.
The fee for running in-house Microsoft PowerApps and Power Automate courses in Colchester is £795, per day.
The cost for running customized Microsoft PowerApps and Power Automate courses in Luton is £795, per day.
Our fee for delivering customized Microsoft PowerApps and Power Automate training in Tyneside is £895, per day.
The charge for running customized Microsoft PowerApps and Power Automate training in Liverpool is £895, per day.
Our price for delivering on-site Microsoft PowerApps and Power Automate courses in Medway Towns is £895, per day.
The fee for running customized Microsoft PowerApps and Power Automate training in Doncaster is £895, per day.
The fee for running customized Microsoft PowerApps and Power Automate training in Exeter is £895, per day.
Our charge for delivering on-site Microsoft PowerApps and Power Automate courses in Farnborough/Aldershot is £895, per day.
The charge for running customized Microsoft PowerApps and Power Automate training in Greater Manchester is £895, per day.
Our charge for delivering Microsoft PowerApps and Power Automate courses in Chesterfield is £895, per day.
Our price for supplying on-site Microsoft PowerApps and Power Automate courses in Reading is £795, per day.
Our price for delivering on-site Microsoft PowerApps and Power Automate courses in Blackpool is £895, per day.
Our fee for delivering in-house Microsoft PowerApps and Power Automate courses in High Wycombe is £895, per day.
The charge for running Microsoft PowerApps and Power Automate courses in Chelmsford is £895, per day.
The fee for running on-site Microsoft PowerApps and Power Automate training in Edinburgh is £995, per day.
Our price for delivering in-house Microsoft PowerApps and Power Automate courses in Oxford is £895, per day.
Our price for running on-site Microsoft PowerApps and Power Automate training in The West Midlands is £795, per day.
The fee for running on-site Microsoft PowerApps and Power Automate training in Telford is £795, per day.
The cost of supplying on-site Microsoft PowerApps and Power Automate courses in Accrington/Rossendale is £895, per day.
Our charge for supplying Microsoft PowerApps and Power Automate courses in Sunderland is £895, per day.
Our price for supplying in-house Microsoft PowerApps and Power Automate courses in Derby is £795, per day.
Our price for delivering customized Microsoft PowerApps and Power Automate courses in Basingstoke is £895, per day.
Our price for delivering customized Microsoft PowerApps and Power Automate courses in Eastbourne is £895, per day.
Our fee for delivering on-site Microsoft PowerApps and Power Automate training in Northampton is £895, per day.
The fee for running customized Microsoft PowerApps and Power Automate training in Ireland is £995, per day.
The charge for running in-house Microsoft PowerApps and Power Automate courses in Preston is £895, per day.
Our price for running Microsoft PowerApps and Power Automate courses in Sheffield is £895, per day.
Our price for running customized Microsoft PowerApps and Power Automate training in Plymouth is £895, per day.
Our price for supplying in-house Microsoft PowerApps and Power Automate courses in Slough is £895, per day.
Our charge for supplying on-site Microsoft PowerApps and Power Automate training in Newport is £895, per day.
The fee for running customized Microsoft PowerApps and Power Automate courses in Torquay is £895, per day.
Our price for delivering customized Microsoft PowerApps and Power Automate courses in Burnley is £895, per day.
Our fee for delivering customized Microsoft PowerApps and Power Automate courses in Ipswich is £895, per day.
The fee for running on-site Microsoft PowerApps and Power Automate training in West Yorkshire is £795, per day.
Our price for supplying Microsoft PowerApps and Power Automate courses in Dundee is £995, per day.
Our fee for delivering customized Microsoft PowerApps and Power Automate courses in Cardiff is £895, per day.
Our fee for delivering Microsoft PowerApps and Power Automate courses in Bristol is £895, per day.
The fee for running customized Microsoft PowerApps and Power Automate training in Norwich is £795, per day.
Our charge for supplying on-site Microsoft PowerApps and Power Automate courses in Birkenhead is £895, per day.
Our charge for delivering customized Microsoft PowerApps and Power Automate courses in Coventry is £795, per day.
Our fee for delivering on-site Microsoft PowerApps and Power Automate courses in Warrington is £895, per day.
Our price for delivering in-house Microsoft PowerApps and Power Automate courses in Mansfield is £895, per day.
The fee for running on-site Microsoft PowerApps and Power Automate courses in Greater Glasgow is £995, per day.
The charge for running customized Microsoft PowerApps and Power Automate courses in Lincoln is £795, per day.
Our charge for delivering customized Microsoft PowerApps and Power Automate training in Wigan is £895, per day.
The cost for running in-house Microsoft PowerApps and Power Automate courses in Poole is £895, per day.
The fee for running on-site Microsoft PowerApps and Power Automate courses in Worcester is £895, per day.
The charge for running customized Microsoft PowerApps and Power Automate courses in Stoke-on-Trent is £795, per day.
Our charge for supplying on-site Microsoft PowerApps and Power Automate courses in Maidstone is £895, per day.
Our price for running customized Microsoft PowerApps and Power Automate training in Nottingham is £795, per day.
Our price for supplying Microsoft PowerApps and Power Automate courses in Basildon is £895, per day.
The cost for running customized Microsoft PowerApps and Power Automate courses in Hastings is £895, per day.
Our charge for delivering customized Microsoft PowerApps and Power Automate courses in Swindon is £895, per day.
Our price for delivering customized Microsoft PowerApps and Power Automate training in Brighton and Hove is £895, per day.
The cost of supplying Microsoft PowerApps and Power Automate courses in Cheltenham is £895, per day.
Our price for running on-site Microsoft PowerApps and Power Automate courses in Teesside is £895, per day.
Our price for supplying customized Microsoft PowerApps and Power Automate training in Cambridge is £795, per day.
The charge for running customized Microsoft PowerApps and Power Automate courses in Thanet is £895, per day.
The charge for running customized Microsoft PowerApps and Power Automate courses in Birmingham is £795, per day.
The cost of supplying on-site Microsoft PowerApps and Power Automate courses in Grimsby is £895, per day.
The cost of supplying on-site Microsoft PowerApps and Power Automate courses in Burton-upon-Trent is £895, per day.
Our price for supplying on-site Microsoft PowerApps and Power Automate courses in Greater London is £895, per day.
The cost of supplying customized Microsoft PowerApps and Power Automate courses in Crawley is £895, per day.
The fee for running in-house Microsoft PowerApps and Power Automate courses in York is £895, per day.
Our charge for supplying customized Microsoft PowerApps and Power Automate training in Leicester is £795, per day.
Our fee for delivering customized Microsoft PowerApps and Power Automate training in Southend-on-Sea is £895, per day.
The cost of supplying in-house Microsoft PowerApps and Power Automate courses in South Hampshire is £895, per day.
The cost for running customized Microsoft PowerApps and Power Automate training in Bedford is £895, per day.
Our fee for delivering Microsoft PowerApps and Power Automate courses in Barnsley is £895, per day.
Our price for delivering in-house Microsoft PowerApps and Power Automate courses in Blackburn is £895, per day.
Our price for running Microsoft PowerApps and Power Automate courses in Gloucester is £895, per day.
Our charge for supplying customized Microsoft PowerApps and Power Automate training in Bournemouth is £895, per day.
Our price for supplying customized Microsoft PowerApps and Power Automate training in Aberdeen is £995, per day.
The fee for running on-site Microsoft PowerApps and Power Automate courses in Peterborough is £795, per day.
Our price for running customized Microsoft PowerApps and Power Automate courses in Milton Keynes is £795, per day.
The cost for running customized Microsoft PowerApps and Power Automate courses in Kingston upon Hull is £895, per day.
Our price for running Microsoft PowerApps and Power Automate courses in Swansea is £895, per day.
Our charge for supplying on-site Microsoft PowerApps and Power Automate training in Belfast is £995, per day.