Course outline for MS Power Pack

Course outline for MS Power Pack

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.

Expected Outcome

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

Course Outline

1. Adding and working with controls
2. Working with container control
3. Understanding control colors and opacity
4. Dynamically changing control properties at run-time
5. Grouping controls
6. Power Apps Simple vs Complex controls
7. If and Contextual variables in Power Apps
8. Text Label and Text Input
9. Adding some actions to Text input
10. HTML text and Rich Text Editor
11. Working with Image and Video controls
12. Working with Buttons, Shapes and Icons
13. Checkbox, Toggle and Date Picker are the easiest to work with
14. Dropdown, List and Radio
15. Simple controls review
16. Connecting Power Apps to Microsoft Excel on SharePoint/OneDrive
17. Using Collect, Patch and Remove with Microsoft Excel files
18. Display form and Edit form
19. How to use "Edit form"
20. SharePoint and Power Apps - Hosting Power apps inside SharePoint
21. Preparing SharePoint site for our demo
22. Customizing SharePoint forms using Power Apps
23. Converting a text field to Lookup in SharePoint using Power Apps
24. Using SharePoint as data source for Power Apps
25. Explore Connectors
26. Basic Transformations
27. String and Numeric tools
28. Index & Conditional Columns
29. Grouping & Aggregating Data
30. Pivoting & Unpivoting
31. Modifying, Merging & Appending Queries
32. Connecting to Folders
33. Normalization
34. Data ("Fact") Tables vs. Lookup ("Dimension") Tables
35. Creating Relationships
36. Schemas and comparisons
37. Active vs. Inactive Relationships
38. Relationship Cardinality
39. Connecting Multiple Data Tables
40. Filtering & Cross-Filtering
41. Hiding Fields from the Power BI Report View
42. DAx Intro
43. Calculated Columns vs. Measures
44. Row Context vs. Filter Context in Power BI
45. Syntax for DAX
46. Common Power BI Functions
47. Basic Date & Time Formulas