Microsoft Power Apps

Data Analytics

COURSE OVERVIEW


Students will be taught how to design, test, and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their businesses.



Duration: 2 days / 16 hours

Delivery Method: Classroom-based, Virtual Instructor Led Training


AFTER COMPLETING THIS COURSE, STUDENTS WILL BE ABLE TO:

·      Understand when to use PowerApps

·      Describe the components of PowerApps and their correct use

·      Create PowerApps from existing data sources

·      Brand PowerApps

·      Customize PowerApps 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 PowerApps with other Office 365 systems – including Teams and SharePoint Online

·      Administer and Maintain PowerApps


COURSE OUTLINE


MODULE 1 - AN INTRODUCTION TO POWERAPPS

·      What is PowerApps?

·      The benefits of apps

·      How to get PowerApps

·      Canvas Apps and Model-Driven Apps

·      License Options and Costs

·      Discover PowerApps with Templates

 

MODULE 2 - GETTING STARTED WITH POWERAPPS

·      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

 

MODULE 3 - BRANDING AND MEDIA

·      Less is more

·      Duplicate Screens

·      Fonts

·      Screen Colours and Matching Colours

·      Screen Backgrounds

·      Buttons and Icons

·      Hide on Timer

·      Size and Alignment by reference

·      Show and Hide on Timer

 

MOUDLE 4 - POWERAPPS CONTROLS

·      Text Controls for Data Entry and Display

·      Controls – Drop downs, combo box, date picker, radio button and more

·      Forms – Add and edit data in underlying data sources quickly

·      Charts – present information in pie, line, and bar charts

 

MODULE 5 - DATA SOURCES AND LOGIC

·      Data Storage and Services

·      How do I decide which database to use?

·      Connect to on-premises data - Gateway

·      What is Delegation?

·      Specific Data Examples

·      Displaying Data


MODULE 6 - MODEL-DRIVEN APPS

·      What is a model-driven app?

·      Where will my data be stored?

·      How do create a model-driven app

·      Canvas vs model-driven summary

 

MODULE 7 - POWERAPP INTEGRATION

·      Embed PowerApps in Teams

·      Embed PowerApps in SharePoint Online

·      Start a Flow from a PowerApp

 

MODULE 8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS

·      Identify which users have been using PowerApps

·      Reuse an app in another location (move from testing or development to production)

·      Review app usage

·      Prevent a user from using PowerApps

·      Manage environments


REGISTER NOW

Learning Experience Survey

Learning Experience Survey

Learning Experience Survey