• You are here:
  • Home »

Microsoft Power Platform 1-Week Intensive Training Course

    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.

    Private Online Training Courses

    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.