Travel expenses are charged where applicable.
Custom Built-in Apps (Lists)
Advanced Meta-Data Management
List and Library Views
Web Page Editing
Workflows
Sharing
Office 365 Additional Service Integration
This course will provide an introduction to the Microsoft Power Platform. You will learn about the value and capabilities of PowerApps. Understand how the Common Data Service allows you to delve into powerful, scalable data solutions in the cloud. Learn how to leverage Power Automate to improve business efficiency and productivity. Gain an appreciation of how organizations can use Power BI to easily clean, display, and understand data to ensure better informed decisions.
There are no prerequisites for this course
Module 1: Introduction to Power Platform
Learn about the components of Power Platform, ways to connect data, and how organizations can leverage this technology to
Lessons
After completing this module, students will be able to:
Module 2: Get Started with Power Apps
Learn about the value and capabilities of PowerApps, and ways other organizations have leverage this technology to build simple applications for their business.
Lessons
Lab : How to Build a Basic Canvas App 2
After completing this module, students will be able to:
Module 3: Introduction to Common Data Service
The Common Data Service allows you to delve into powerful, scalable data solutions in the cloud. Learn what makes the Common Data Service tick and how it can work with the Power Platform to create unique and efficient business solutions.
Lessons
Lab : Data Modeling
After completing this module, students will be able to:
Module 4: Get Started with Power Automate
Learn how users can leverage Power Automate to improve business efficiency and productivity.
Lessons
Lab : Build a Simple Flow
After completing this module, students will be able to:
Module 5: Get Started with Power BI
Learn how organizations can use Power BI to easily clean, display, and understand data to ensure better informed decisions.
Lessons
Lab : Build a Power BI Report
After completing this module, students will be able to:
Power Apps is a core part of the Office 365 suite and provides a platform for creating online forms, desktop and mobile apps that connect to your business data. This course is an introduction to PowerApps focusing on the creation and distribution of canvas Apps.
This course can be used to gain the pre-requisite knowledge required for course QAMPAPPS – Mastering Power Apps, which is a more technical in-depth look at creating Power Apps
Anybody who wishes to create an online business app.
The following prerequisites are recommended before attending:
Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.
After attending this course, delegates will be able to:
Overview of Power Apps
This module introduces Power Apps, what you can do with Power Apps and how Power Apps fits with the rest of the Power Platform. It also contains and exercise that will prepare the student environment for working with and creating Power Apps.
The Power Apps Studio
This module starts with an explanation on how to launch and use the Power Apps studio for creating, editing and running apps. There is also a section on the other ways that apps can be run by users. The module will also look at how apps can be saved, published and shared with other users as well as investigating the versioning system of Power Apps. The three main ways of creating apps are introduced and there is an exercise where students will create, save and publish an app from a template.
Screens, controls and navigation
In this module students will examine the core building blocks of Power Apps, namely Screens and Controls. As part of this the naming of these objects and a discussion on naming conventions will be covered. This module will also look at setting properties including the use of relative and linked properties. There will also be an examination of the properties that can be used to invoke change.
Variables and functions
The module will introduce students to the use of functions in Power Apps and will focus on commonly used functions including Navigate, Text and Value as well as exploring how multiple functions can be used together. Variables and the functions used to manipulate them are also introduced. There is an exercise to bring together all the skills introduced so far in the course.
Working with data – galleries
In this module, students will be introduced to data and tables including data sources and records. The main ways of displaying multiple records are introduced, namely the table and gallery controls. The use of searching and the sum function within data tables is also introduced and there is an exercise to practice theses skills.
Working with data – forms
The final module of this course looks at using forms to view and edit individual records from the data sources. The module also introduces data cards, the sub-components of forms and shows their importance when creating apps. Finally, the functions used with forms to create and update records are introduced. This module has two exercises, the first to cement learning from the module, the second to investigate publishing and versions which was not possible earlier in the course due to lack of data.
Power BI provides a variety of methods for using reports and dashboards within which data can be viewed and analysed visually.
This course covers the use of existing Power BI Desktop or Power BI reports and dashboards. It will identify core features, terminology and processes applicable when using reports or dashboards. Its principal aim is to provide the skills to enable a delegate to work with the reports and dashboards effectively.
Please note – this course does not cover creating reports or dashboards.
Anyone whose role requires them to use existing Power BI Reports or Dashboards to consume the contents. Roles can include management at all levels, team leaders or anyone who needs to commission the production of reports or dashboards.
It is assumed that attendees on the course are familiar with charts.
Attendees who wish to learn how to create Power BI Reports should attend the QA course Microsoft Power BI Desktop QAPBIDT3.
Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.
Delegates will learn:
Module 1: Getting Started with Power BI
Module 2: Understanding what you are looking at
Module 3: Using a Report in Power BI
Module 4: Working with Dashboards
QA reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.