Power Platform Course Outlines
What is Power Platform?
Power Platform is a suite of tools that greatly extend the capabilities of Microsoft 365. The idea is simple, make it as straightforward as possible to automate tasks, build custom applications, and report on data.
Power Platform primarily consists of
- Power Automate, a work automation system
- Power Apps, build apps that run almost anywhere
- Power BI, create interactive reports that keep you up to date with key information.
Full Day or Custom Durations
All the Power Platform courses are listed in their full-day form. Each course takes one day to complete. It is possible to break each of these down into a series of sessions of half-day or less. Why not get in touch to talk about customised sessions and session durations?
Power Automate Courses
- What is Power Automate?
- What is a Flow?
- Introduction to the Power Automate UI
- Connectors – what can Power Automate Works with
- Exploring the Template Library
- Understanding the different types of flow
- Creating Flows from a template
- How to test Flows
- Creating Flows from scratch
- Using essential flow concepts such as
- Triggers
- Actions
- Conditions
- Expressions
- Loops
- Working with parts of Microsoft 365 including
- Forms
- To Do
- OneDrive
- SharePoint
- Teams
- Introduction to the Approvals System.
- Creating and testing an approval workflow
- Creating Parallel Branches in Power Automate
- Using parallel branches to manage errors
- Introduction to HTML Tables
- How to create a table
- Using CSS to format a HTML table
- Using HTML Tables
- Making use of JSON
- JSON Explained
- How to understand JSON Content
- Using Parse JSON to create usable dyanmic content fields
- Using Adaptive Cards
- Adaptive Cards Explained
- Using Adaptive Card Templates
- Creating Adaptive and using Cards in the Power Automate Editor
- Introduction to the Adaptive Card Designer
- Designing and using Adaptive Cards
Office Scripts are an Excel feature enabling automation of Excel tasks. This automation included the ability for Excel tasks to be triggered by Power Automate. Or for Office Scripts to pass information to Power Automate. This introductory course gets you started with Office Scripts and Power Automate.
- What are Office Scripts?
- Where can I find Office Scripts?
- Whare are Office Scripts used for?
- How to record an Office Script.
- Using an Office Script
- The default file save location for office scripts.
- Using SharePoint to share a script with your team.
- Accessing the editor
- Using the Code editor to amend an existing script.
- Create a script from scratch.
- Referencing a Worksheet.
- Referencing cells and ranges.
- Using variables to store information.
- What is a function?
- Creating a function?
- Formatting a range
- Formatting a table.
- Creating calculations in Office Scripts.
- Running an Office Script from Power Automate
Power Apps Courses
- What are Power Apps
- Where can we deploy Power Apps to.
- Introduction to the Power Apps Studio and UI.
- Using a Power Apps Three Screen Template
- Connecting to data
- Understanding Power Apps Data Limits
- Amending the Template
- Publishing the App
- Power Apps version management and publising App versions
- Sharing Power Apps
- Assigning Users
- Assigning Co-Owners
- Using a General Power App Template
- Creating an App from the Template
- How to explore and use any underlying data tables.
- Creating a Power App from scratch and using Power App components such as
- Screens
- Galleries
- Forms
- Icons
- Buttons
- Images
- Filtering Data in a Power App
- Working with Model Driven Apps
- Introduction to Model Driven apps
- Creating a working environment
- Creating a Model Driven App Using Teams
- Creating a Model Driven App using a Dataverse Table
- Understanding Power Apps variables
- Using Global Variables
- Using Context Variables
- Using Collections
- Going Beyond Forms
- Managing Data Display without using a Form
- Using Power App Expressions to save data
- Working with Power Automate
- Creating Power Automate Flows for use with Power Apps
- How to trigger a Power Automate Flow from a Power App
- Returning data to a Power App from a Flow
Power BI Courses
- Overview of the Power BI Desktop App
- Building a basic report
- How to Import Data
- Creating your first interactive visualisations
- Introduction to report formattingin Power BI desktop
- The data model explained
- Creating relationships
- Best Practice in creating tables
- How to publish data to the Power BI Online Service
- Overview of the online services capabilities
- How online dashboards work
- Introduction to Power BI Workspaces
- Introduction to key report components including
- Charts
- Maps
- Sliders
- Filters
- Essential DAX – introduction to basic DAX functions including
- Computed Columns
- Measures
- Additional Report Writing skills including
- Importing Data from Files and a Database
- Understading Conditional Formating
- Creating and using Computed Columns
- Creating and usng Measures
- How to Group Data
- Using Conditional Columns
- Adding graphics and buttons to reports
- Exporting report data as CSV Files
- Creating Interactive PowerPoint Presentations
- Improving data modelling skills
- Working with relationships
- Creating tables from existing data
- Using SQL queries when connecting to a database
- Exploring additional DAX Expression
- Creating and Using Data Hierarchies
- Understanding Power BI Variables
- What is a variable
- Creating Variables
- Introduction to using variables in expressions
- Using AI Visualisations including
- Key Influencers
- Smart Narrative
- Decomposition Tree
- Creating a Data Set to access via Onelake Data hub
- Creating a Parameter Table and using Parameters
- Exploring Table functions
- Using Role-based security
- What is the DAX Query View?
- Why use DAX Query?
- Creating a simple DAX query to list data.
- Creating measures in DAX Query.
- Filtering Data in DAX Query
- Summarising Data in DAX Query
- Ordering Query Results
Note this is a short course typically run as a half day
Booking one of these courses
Booking is straightforward. Contact us by email, phone or this form and we’ll start the process of quoting you and organising course dates.