top of page

Microsoft Power Platform Quickstart Skills

IPA-M101

Microsoft Power Platform Quickstart Skills

Showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent, and visual workflows. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workflow logic for your business workflows.


Training Duration: 5 Days


OVERVIEW

This instructor-led adventurous workshop is designed for audiences to be equipped with the necessary knowledge and skills to kickstart their analytical journey with Microsoft Power BI, followed by essential guidance to Power Apps and Power Automate. You will be guided from the stage of connecting data, transforming data, and visualizing your data using Power BI.


The audience will then be brought to a path of designing, testing, and publishing new apps that work with a variety of data sources with Power Apps.

OBJECTIVES

After completing this course, students will be able to:


  • Describe key features of Microsoft Power BI

  • Understand how data are connected to Microsoft Power BI

  • Massage, cleanse, format and transform data

  • Visualizing data using reports and dashboards

  • Understand when to use Power Apps

  • Describe the components of Power Apps and their correct use

  • Create Power Apps from existing data sources

  • Brand Power Apps

  • Customise Power Apps beyond just using the automated wizards

  • Connect to a range of data sources from Excel to Azure SQL

  • Understand the difference between canvas apps and model-driven apps

  • Integrate Power Apps with other Office 365 systems - including Teams and SharePoint Online

  • Administer and Maintain Power Apps

  • Understand when to use Power Automate

  • Describe the components of Power Automate and their correct use

  • How to create and edit Power Automate

  • Benefits of Power Automate

  • Integration with Power Automate

PREREQUISITES

This course is for beginners and users with little or no exposure of basic programming concepts, little or no knowledge of data warehouse schema, an awareness of key business priorities such as revenue, profitability, and financial accounting, and technically familiar with Microsoft Excel.

AUDIENCE

This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps.


The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones.

COURSE MODULES

Module 1: Microsoft Power BI as a Service

  • What is Power BI?

  • The Power BI service and its ecosystem

  • Product and subscription information

  • Familiarizing with Microsoft Power BI app and service


Module 2: Getting to Know Your Data

  • Using Excel as a Power BI data source

  • Using databases as a Power BI data source

  • Understanding the Power BI dataset

  • Importance of table relationships


Module 3: Data Transformations using Power Query

  • Power BI Desktop queries

  • Cleansing data and transformations

  • Consolidation of data through appends and merges


Module 4: Introduction to DAX

  • What is DAX?

  • Calculated columns vs. measures

  • What are quick measures?

  • Performing simple calculations


Module 5: Visualizing Your Data

  • Creating Power BI reports

  • Creating Power BI dashboards

  • Common visuals and their usage

  • Selections and Bookmarks


Module 6: An Introduction to Power Apps

Let's get started with an introduction to Microsoft PowerApps. Traditionally building customised solutions for a business involved using a coding language to build an application from scratch. Typically, these solutions could often only be used within the business, making external use of the application a large hurdle to overcome. With PowerApps we can now not only easily build solutions, but we can also share them with users in our business. Deployment takes seconds and you could by testing your own app on your phone in no time. This module will overview the features of PowerApps, its benefits to a business and the variety of ways you can build and access your apps on different devices.


Lessons

  • What is Power Apps?

  • The benefits of apps

  • How to get Power Apps

  • Canvas Apps and Model-Driven Apps

  • License Options and Costs

  • Discover Power Apps with Templates


Lab : Introduction to Power Apps

  • Try the Cost Estimator App

  • Download and Review App Design

  • Sample App of your choice


After completing this module, students will be able to:

  • Describe when Power Apps should be used

  • Know how to access Power Apps

  • Make design decisions based on Power Apps licenses

  • Understand that there are two type of app

  • Be able to use sample apps


Module 7: Getting Started with Power Apps

To begin our journey through the Power Apps product, we will begin by looking at some of the templates that are available to view and edit. Microsoft's templates are a good starting point to discover what the product is capable off and how it can be achieved. We will also take the chance to have a tour of the editor so that students are familiar with the interface that they will be using over the two-day course. We will then build our first app from a static data source, showing students how to test their changes in the app instantly without the need to publish. We will also discuss how to configure your apps settings and how to access the app once it has been saved and shared.


Lessons

  • Building a new app from a data source

  • Add, edit and remove controls

  • Intro to Formulas

  • Testing an app

  • App Settings

  • Publish and Share Apps

  • Version History and Restore

  • PowerApps Mobile App


Lab : Getting Started

  • Create App from an existing Data Source

  • Publish and Share

  • View an app on your mobile device


After completing this module, students will be able to:

  • Build a useful app using wizards in minutes

  • Make simple changes to existing apps

  • Know how formulas