FA-0467Software DevelopmentDevOps, Cloud & InfrastructureData & AnalyticsAutomation, RPA & Power Platform

Course outline for MS Power Pack

Introduction

Why this course

This course is a five-day course designed to cover MS Power apps and work with Share point and gradually move into Power BI. This training module starts from the basics of the Power Platform and takes you to building fully functional apps that interact with external data sources.

The course is extremely hands-on and will be conducted via projects and real data sourced primarily from Kaggle.

Learning outcomes

The learners by the end of this course, may be expected to:

Understand the usage of MS POwer Apps
How to add functionality to the apps that are built using PowerApps
How to connect PowerApps to external sources
How to customize SharePoint forms using Power Apps
How to perform additional functionalities to SharePoint forms
One Drive integration
Learn about the Power BI editor and environment.
Explore Connectors
Basic Transformations
String and Numeric tools
Index & Conditional Columns
Grouping & Aggregating Data
Filtering & Cross-Filtering
Hiding Fields from the Power BI Report View
DAx Intro
Calculated Columns vs. Measures
Row Context vs. Filter Context in Power BI
Syntax for DAX
Common Power BI Functions
Basic Date & Time Formulas

Note: The above is just a guideline and must not in any way be construed as a guarantee either implied or expressed in any way. The actual outcome de[ends largely on the participants’ intellect and commitment.

Prerequisites

MS Live account
MS Windows System
Dual Screen
Internet Connection
Basic understand of filing systems
BAsic understanding of Internet operations (upload / download / access shared resources)
Internet Connection
Ability to communicate in English and understand technical terms

Training outline

47 modules

01Adding and working with controls0 topics

02Working with container control0 topics

03Understanding control colors and opacity0 topics

04Dynamically changing control properties at run-time0 topics

05Grouping controls0 topics

06Power Apps Simple vs Complex controls0 topics

07If and Contextual variables in Power Apps0 topics

08Text Label and Text Input0 topics

09Adding some actions to Text input0 topics

10HTML text and Rich Text Editor0 topics

11Working with Image and Video controls0 topics

12Working with Buttons, Shapes and Icons0 topics

13Checkbox, Toggle and Date Picker are the easiest to work with0 topics

14Dropdown, List and Radio0 topics

15Simple controls review0 topics

16Connecting Power Apps to Microsoft Excel on SharePoint/OneDrive0 topics

17Using Collect, Patch and Remove with Microsoft Excel files0 topics

18Display form and Edit form0 topics

19How to use "Edit form" 0 topics

20SharePoint and Power Apps - Hosting Power apps inside SharePoint0 topics

21Preparing SharePoint site for our demo0 topics

22Customizing SharePoint forms using Power Apps0 topics

23Converting a text field to Lookup in SharePoint using Power Apps0 topics

24Using SharePoint as data source for Power Apps0 topics

25Explore Connectors0 topics

26Basic Transformations0 topics

27String and Numeric tools0 topics

28Index & Conditional Columns0 topics

29Grouping & Aggregating Data0 topics

30Pivoting & Unpivoting0 topics

31Modifying, Merging & Appending Queries0 topics

32Connecting to Folders0 topics

33Normalization0 topics

34Data ("Fact") Tables vs. Lookup ("Dimension") Tables0 topics

35Creating Relationships0 topics

36Schemas and comparisons0 topics

37Active vs. Inactive Relationships0 topics

38Relationship Cardinality0 topics

39Connecting Multiple Data Tables0 topics

40Filtering & Cross-Filtering0 topics

41Hiding Fields from the Power BI Report View0 topics

42DAx Intro0 topics

43Calculated Columns vs. Measures0 topics

44Row Context vs. Filter Context in Power BI0 topics

45Syntax for DAX0 topics

46Common Power BI Functions0 topics

47Basic Date & Time Formulas0 topics

A programme built around your team.

Share your training goals and requirements.