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

    27-31 January 2020
    30 Mar – 3 April 2020
    15-19 June 2020

    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

    On-site Microsoft PowerApps and Flow Training

    The fee for running in-house Microsoft PowerApps and Flow courses in Colchester is £795, per day.
    The cost for running customized Microsoft PowerApps and Flow courses in Luton is £795, per day.
    Our fee for delivering customized Microsoft PowerApps and Flow training in Tyneside is £895, per day.
    The charge for running customized Microsoft PowerApps and Flow training in Liverpool is £895, per day.
    Our price for delivering on-site Microsoft PowerApps and Flow courses in Medway Towns is £895, per day.
    The fee for running customized Microsoft PowerApps and Flow training in Doncaster is £895, per day.
    The fee for running customized Microsoft PowerApps and Flow training in Exeter is £895, per day.
    Our charge for delivering on-site Microsoft PowerApps and Flow courses in Farnborough/Aldershot is £895, per day.
    The charge for running customized Microsoft PowerApps and Flow training in Greater Manchester is £895, per day.
    Our charge for delivering Microsoft PowerApps and Flow courses in Chesterfield is £895, per day.
    Our price for supplying on-site Microsoft PowerApps and Flow courses in Reading is £795, per day.
    Our price for delivering on-site Microsoft PowerApps and Flow courses in Blackpool is £895, per day.
    Our fee for delivering in-house Microsoft PowerApps and Flow courses in High Wycombe is £895, per day.
    The charge for running Microsoft PowerApps and Flow courses in Chelmsford is £895, per day.
    The fee for running on-site Microsoft PowerApps and Flow training in Edinburgh is £995, per day.
    Our price for delivering in-house Microsoft PowerApps and Flow courses in Oxford is £895, per day.
    Our price for running on-site Microsoft PowerApps and Flow training in The West Midlands is £795, per day.
    The fee for running on-site Microsoft PowerApps and Flow training in Telford is £795, per day.
    The cost of supplying on-site Microsoft PowerApps and Flow courses in Accrington/Rossendale is £895, per day.
    Our charge for supplying Microsoft PowerApps and Flow courses in Sunderland is £895, per day.
    Our price for supplying in-house Microsoft PowerApps and Flow courses in Derby is £795, per day.
    Our price for delivering customized Microsoft PowerApps and Flow courses in Basingstoke is £895, per day.
    Our price for delivering customized Microsoft PowerApps and Flow courses in Eastbourne is £895, per day.
    Our fee for delivering on-site Microsoft PowerApps and Flow training in Northampton is £895, per day.
    The fee for running customized Microsoft PowerApps and Flow training in Ireland is £995, per day.
    The charge for running in-house Microsoft PowerApps and Flow courses in Preston is £895, per day.
    Our price for running Microsoft PowerApps and Flow courses in Sheffield is £895, per day.
    Our price for running customized Microsoft PowerApps and Flow training in Plymouth is £895, per day.
    Our price for supplying in-house Microsoft PowerApps and Flow courses in Slough is £895, per day.
    Our charge for supplying on-site Microsoft PowerApps and Flow training in Newport is £895, per day.
    The fee for running customized Microsoft PowerApps and Flow courses in Torquay is £895, per day.
    Our price for delivering customized Microsoft PowerApps and Flow courses in Burnley is £895, per day.
    Our fee for delivering customized Microsoft PowerApps and Flow courses in Ipswich is £895, per day.
    The fee for running on-site Microsoft PowerApps and Flow training in West Yorkshire is £795, per day.
    Our price for supplying Microsoft PowerApps and Flow courses in Dundee is £995, per day.
    Our fee for delivering customized Microsoft PowerApps and Flow courses in Cardiff is £895, per day.
    Our fee for delivering Microsoft PowerApps and Flow courses in Bristol is £895, per day.
    The fee for running customized Microsoft PowerApps and Flow training in Norwich is £795, per day.
    Our charge for supplying on-site Microsoft PowerApps and Flow courses in Birkenhead is £895, per day.
    Our charge for delivering customized Microsoft PowerApps and Flow courses in Coventry is £795, per day.
    Our fee for delivering on-site Microsoft PowerApps and Flow courses in Warrington is £895, per day.
    Our price for delivering in-house Microsoft PowerApps and Flow courses in Mansfield is £895, per day.
    The fee for running on-site Microsoft PowerApps and Flow courses in Greater Glasgow is £995, per day.
    The charge for running customized Microsoft PowerApps and Flow courses in Lincoln is £795, per day.
    Our charge for delivering customized Microsoft PowerApps and Flow training in Wigan is £895, per day.
    The cost for running in-house Microsoft PowerApps and Flow courses in Poole is £895, per day.
    The fee for running on-site Microsoft PowerApps and Flow courses in Worcester is £895, per day.
    The charge for running customized Microsoft PowerApps and Flow courses in Stoke-on-Trent is £795, per day.
    Our charge for supplying on-site Microsoft PowerApps and Flow courses in Maidstone is £895, per day.
    Our price for running customized Microsoft PowerApps and Flow training in Nottingham is £795, per day.
    Our price for supplying Microsoft PowerApps and Flow courses in Basildon is £895, per day.
    The cost for running customized Microsoft PowerApps and Flow courses in Hastings is £895, per day.
    Our charge for delivering customized Microsoft PowerApps and Flow courses in Swindon is £895, per day.
    Our price for delivering customized Microsoft PowerApps and Flow training in Brighton and Hove is £895, per day.
    The cost of supplying Microsoft PowerApps and Flow courses in Cheltenham is £895, per day.
    Our price for running on-site Microsoft PowerApps and Flow courses in Teesside is £895, per day.
    Our price for supplying customized Microsoft PowerApps and Flow training in Cambridge is £795, per day.
    The charge for running customized Microsoft PowerApps and Flow courses in Thanet is £895, per day.
    The charge for running customized Microsoft PowerApps and Flow courses in Birmingham is £795, per day.
    The cost of supplying on-site Microsoft PowerApps and Flow courses in Grimsby is £895, per day.
    The cost of supplying on-site Microsoft PowerApps and Flow courses in Burton-upon-Trent is £895, per day.
    Our price for supplying on-site Microsoft PowerApps and Flow courses in Greater London is £895, per day.
    The cost of supplying customized Microsoft PowerApps and Flow courses in Crawley is £895, per day.
    The fee for running in-house Microsoft PowerApps and Flow courses in York is £895, per day.
    Our charge for supplying customized Microsoft PowerApps and Flow training in Leicester is £795, per day.
    Our fee for delivering customized Microsoft PowerApps and Flow training in Southend-on-Sea is £895, per day.
    The cost of supplying in-house Microsoft PowerApps and Flow courses in South Hampshire is £895, per day.
    The cost for running customized Microsoft PowerApps and Flow training in Bedford is £895, per day.
    Our fee for delivering Microsoft PowerApps and Flow courses in Barnsley is £895, per day.
    Our price for delivering in-house Microsoft PowerApps and Flow courses in Blackburn is £895, per day.
    Our price for running Microsoft PowerApps and Flow courses in Gloucester is £895, per day.
    Our charge for supplying customized Microsoft PowerApps and Flow training in Bournemouth is £895, per day.
    Our price for supplying customized Microsoft PowerApps and Flow training in Aberdeen is £995, per day.
    The fee for running on-site Microsoft PowerApps and Flow courses in Peterborough is £795, per day.
    Our price for running customized Microsoft PowerApps and Flow courses in Milton Keynes is £795, per day.
    The cost for running customized Microsoft PowerApps and Flow courses in Kingston upon Hull is £895, per day.
    Our price for running Microsoft PowerApps and Flow courses in Swansea is £895, per day.
    Our charge for supplying on-site Microsoft PowerApps and Flow training in Belfast is £995, per day.