Course Details
Topic 1 Describe the business value of the Microsoft Power Platform
- Explore Microsoft Power Platform
- Describe the business value of the Power Platform
- Explore connectors and Microsoft Dataverse
- Use Artificial Intelligence to increase productivity
- Explore the business value of the Power Fx
- Describe how Power Platform works with Microsoft 365 apps and services
- Explore how Power Platform works with Microsoft Teams
- Describe how Power Platform works with Microsoft Dynamics 365 apps
- Explore how Microsoft Power Platform apps work together
- Describe how Power Platform solutions consume Microsoft Azure services
Topic 2 Identify foundational components of Microsoft Power Platform
- Describe Power Platform administration
- Describe Power Platform security and governance
- Explore Microsoft Dataverse
- Examine Power Platform connectors
- Exercise - Build a basic Dataverse data model
Topic 3 Create and manage environments in Dataverse
- Environments in Microsoft Dataverse
- Developer environments
- Create and manage an environment
- Create an instance of a Microsoft Dataverse database
- Add users and roles within an environment
- Manage settings in an environment
- Environment operations
Topic 4 Create tables in Dataverse
- Introduction to Microsoft Dataverse
- Table characteristics
- Dataverse logic and security
- Dataverse auditing
- Dual-write vs. virtual tables
Topic 5 Create and manage columns within a table in Dataverse
- Define columns in Microsoft Dataverse
- Column types in Microsoft Dataverse
- Add a column to a table
- Primary name column
- Restrictions that apply to columns in a table
- Create an auto numbering column
- Create an alternate key
Topic 6 Working with choices in Dataverse
- Define choice column
- Choice columns
- Standard choices column
Topic 7 Create a relationship between tables in Dataverse
- Relate one or more tables - Introduction
- Relationship types that are available in Microsoft Dataverse
- Create a one-to-many relationship between tables
- Create a many-to-many relationship between tables
- Edit or delete relationships
Topic 8 Create and define calculation or rollup columns in Dataverse
- Introduction to roll up columns
- Create a rollup column
- Introduction to calculated columns
- Create a calculation column
- Introduction to Power Fx formula columns
Topic 9 Load/export data and create data views in Dataverse
- View data in a table
- Create or edit views of data in a table
- Dataverse data import options
- Load data into a table
- Dataverse data export options
- Export
- Add, update, or delete data in a table by using Excel
- Import data using Power Query
Topic 10 Get started with security roles in Dataverse
- Introduction to environment roles
- Understand environment roles
- Adding or disabling an environment user
- Understand security concepts in Dataverse
- Understand user security roles and security role defaults
- Check the roles that a user belongs to
- Configure Dataverse teams for security
- Configure Dataverse group teams for security
Topic 11 Use administration options for Dataverse
- Introduction to Microsoft Power Platform Admin Center portal
- Use Microsoft Power Platform Admin Center portal
- Tenant storage capacity
- Advanced Customization options in Power Apps Portal
- Dataverse Search
- Auditing
- Duplicate detection
- Bulk delete
- Long term data retention
Topic 12 How to build your first model-driven app with Dataverse
- Introduction to Dataverse
- Introduction to model-driven apps
- Model-driven apps, powered by Microsoft Dataverse
- Explore sample apps
Topic 13 Get started with model-driven apps in Power Apps
- Introducing model-driven apps
- Components of model-driven apps
- Design model-driven apps
- Incorporate business process flows
Topic 14 Configure forms, charts, and dashboards in model-driven apps
- Forms overview
- Form elements
- Configure multiple forms
- Use specialized form components
- Configure views overview
- Configure grids
- Create and edit views
- Configure charts overview
- Dashboards overview
- Use interactive streams and tiles
Topic 15 Use specialized components in a model-driven form
- Create business process flows
- Embed a canvas app in a model-driven form
- Add a timeline in a model-driven form
- Create a report in a model-driven form
Topic 16 Customize the command bar
- Create or edit modern commands
- Work with classic commands
- Use Power Fx
Topic 17 Get started with Power Apps canvas apps
- Introduction to Power Apps
- Start Power Apps
- Power Apps data sources
- Use Power Apps with Power Automate and Power BI
- Designing a Power Apps app
Topic 18 Customize a canvas app in Power Apps
- Improve your app by making basic customizations
- Explore controls and screens in canvas apps
Topic 19 Navigation in a canvas app in Power Apps
- Understanding navigation
- The Navigate and Back functions
- More ways to use the Navigate function
Topic 20 Create formulas to change behaviors in a Power Apps canvas app
- Formulas and functionality
- Understanding true and false
- Understanding control behaviors and actions
- Performing multiple actions in a formula
- Control the display mode through a formula
- Use controls and functions to create a dynamic formula
Topic 21 Connect to other data in a Power Apps canvas app
- Overview of the different data sources
- Work with action-based data sources
- Power Automate is a companion to Power Apps
Topic 22 Introduction to Power Apps cards
- Design Power Apps cards
- Send Power Apps cards
Topic 23 Core components of Power Pages
- Introduction to Power Pages
- Get started with Power Pages
- Core tools and components of Power Pages
- Overview of Power Pages security
- Overview of Power Pages extensibility
Topic 24 Access Dataverse in Power Pages websites
- Use lists to display multiple Dataverse records
- Use forms to interact with Dataverse data
Topic 25 Explore Power Pages design studio
- Get Started with Power Pages
- Work with Power Pages websites
- Introduction to Power Pages design studio
- Work with pages
- Page components
- Site styling and templates
Topic 26 Integrate Power Pages websites with Dataverse
- Basic form configuration
- Multistep form processes
- Set up multistep forms
- Extend lists and forms
Topic 27 Integrate Power Pages with web-based technologies
- Document management with SharePoint in Power Pages
- Integration with Power BI in Power Pages
- Model-driven charts in Power Pages
Topic 28 Explore Power Pages design studio data and security features
- Introduction into Power Pages design studio data and security features
- Data workspace in Power Pages design studio
- Power Pages security features
Topic 29 Set up Power Pages security
- Secure static content
- Table permissions
Topic 30 Authentication and user management in Power Pages
- Power Pages authentication settings
- User registration in Power Pages
- Authentication management for Power Pages users
- Power Pages authentication providers
Topic 31 Best practices for error handling in Power Automate flows
- Configure run after option
- Power Automate analytics
Topic 32 Use Dataverse triggers and actions in Power Automate
- Dataverse triggers
- Query data
- Create, update, delete, and relate actions
Topi 33 Introduction to expressions in Power Automate
- Get started with expressions
- Notes make things easier
- Types of functions
- Write complex expressions
Topic 34 Define and create business rules in Dataverse
- Define business rules - Introduction
- Define the components of a business rule
- Create a business rule
Topic 35 Set up low-code plug-ins
- Low-code plug-ins
- Create a low-code plug-in
- Instant plug-ins
- Automated plug-ins
Topic 36 Use common low-code plug-in scenarios
- Use Power Fx with plug-ins
- Implement data validation
- Data manipulation
- Use connectors in plug-in logic
- Use instant plug-ins from Power Apps
- Use instant plug-ins from Power Automate
Topic 37 Get started building with Power BI
- Use Power BI
- Building blocks of Power BI
- Tour and use the Power BI service
Topic 38 Introduction to solutions for Microsoft Power Platform
- Solution layering
- Solution architecture tools and techniques
Topic 39 Use Microsoft 365 services with model-driven apps and Microsoft Dataverse
- Set up mailboxes
- Server-side sync
- Document management options
- Document management
- Deploy the app for Outlook
- Set up Dynamics 365 App for Outlook
- Integrate with Microsoft Teams
Topic 40 Use Microsoft Word and Excel templates with Dataverse
- Create a dynamic Word template
- Create a dynamic Excel template
Practice Exam
Course Info
Prerequisites
- 1-2 years professional experience developing cloud solutions
- Experience working with Microsoft Azure
- Foundational knowledge of core data concepts and their implementation
HRDF Funding
Please refer to this video https://youtu.be/Kzpd-V1F9Xs
1- HRD Corp Grant Helper
How to submit grant applications for HRD Corp Claimable Courses
2- Employers are required to apply for the grant at least one week before training commences.
Employers must submit their applications with supporting documents, including invoices/quotations, trainer profiles, training schedule and course content.
3- First, Login to Employer’s e-TRIS account -https://etris.hrdcorp.gov.my
Second, Click Application
4- Click Grant on the left side under Applications
5- Click Apply Grant on the left side under Applications
6- Click Apply
7- Choose a Scheme Code and select HRD Corp Claimable Courses: Skim Bantuan Latihan Khas. Then, click Apply
8- Scheme Code represents all types of training that suit the requirements provided by HRD Corp. Below are the list of schemes offered by HRD Corp:
9- Select your Immediate Officer and click Next
10- Select a Training Provider, then click Next
11- Please select a training programme from the list, then key in all the required details and click Next
Select your desired training programme.
Give an explanation on why the participant is required to attend the training. E.g., related to their tasks/ career development, etc.
Explain the background and objective of this training.
Select a relevant focus area. For Employer-Specific Courses, select ‘Not Applicable’.
12- If the training programme is a micro-credential programme, you are required to complete these 3 fields. Save and click Next
Insert MiCAS Application number
13- Based on the nine (9) pillars listed below, HRD Corp Focus Area Courses are closely tied to support government initiatives towards nation building. As such, courses offered through the HRD Corp Focus Areas are designed to provide the workforce with skills required for current and future demands. Details of the focus areas are as follows:
14- Please select a Course Title and Type of Training
15- Select the correct type of training according to the actual type of training, or as mentioned in the training brochure:
16- Please key in the Training Location and click Next
17- Please select the Level of Certification and click Next
18- Please follow the instructions and key in trainee details
19- Click Add Batch, then click Save
20- Click Add Trainee Details
21- Please key in all the required details, then click Add
22- Click Add if there are more participants. Once done, click Save
23- Click Next
24- Please key in the course fees and allowance details, then click Save
25- Estimated cost includes the course fees/external trainer fees, allowances, and consumable training materials. Please comply with the HRD Corp Allowable Cost Matrix.
26- Select Upfront Payment to Training Provider and key in the percentage from 0% to 30%. Then, click Save and Next
27- Complete the declaration form and select a desired officer
28- Add all the required documents, then click Add Attachment. Then, click Save and Submit Application
29- Once the New Grant Application is successfully submitted, the Grant Officer will evaluate the application accordingly. The application may be queried if additional information is required.
The application status will be updated via the employer’s dashboard, email, and the e-TRiS inbox.
Job Roles
- Power Platform Developer
- Software Developer
- Application Developer
- Systems Analyst
- Data Analyst
- Business Intelligence Developer
- IT Consultant
- Solutions Architect
- Database Developer
- CRM Developer
- Cloud Developer
- Full Stack Developer
- Mobile App Developer
- Front End Developer
- Back End Developer
Trainers
Jack Lee : Trainer with a demonstrated history of working in the information technology and manufacturing industry. Skilled in Data Visualization Sales, Management, Data Analytics, and Text Mining. Strong education professional with an Executive Master of Business Administration - MBA from Open University Malaysia. He has obtained PL-300, PL-100 and other Microsoft certifications.