UNiSOFT Education Center

Certificate in Dataverse and Model Driven Power Apps Development

Learn Dataverse and Model-Driven Apps 打造高效業務解決方案！

課程簡介

Dataverse 是 Microsoft 提供的安全且可擴展的數據平台，專為高效管理業務數據而設計，能存儲結構化與非結構化數據，並輕鬆連接內外部數據源（如 SharePoint、Dynamics 365 和 Excel），同時內建安全控制功能以確保數據隱私與合規性。基於 Dataverse 的 Model-Driven Apps 是一種低代碼應用開發工具，專注於數據驅動的應用設計，無需編碼即可配置表格、表單、業務規則、圖表和儀表板，並自動生成響應式跨平台介面。其強大功能支持構建複雜的數據關係與業務邏輯，並提供靈活的安全角色控制，非常適合用於客戶管理系統 (CRM)、資產跟蹤工具和內部工作流等場景，幫助企業快速實現數位化轉型與業務創新。

課程目標

Dataverse

建立於 Dataverse，提供安全且可擴展的數據平台

Relationship

支援一對多和多對多的關係設置。

Views and Forms

創建視圖 (View) 篩選數據，設計表單 (Form) 用於數據輸入和編輯

Business Rule

使用業務規則實現邏輯與數據驗證，無需編碼。

Charts & Dashboard

建立圖表 (Chart) 和儀表板 (Dashboard)，用於數據可視化與監控

Security Roles

設置安全角色，控制用戶的數據訪問權限。

Interface Design

透過拖放介面，快速構建應用程式

Publish and Secure Your Model Driven App

發布應用，配置權限，並與團隊共享

Demo Video -
Creating a Pivot Table for business data

課程相關資料

課程對象針對企業客戶而設

上課模式面授上課或者即時網上教學

上課安排客戶可到本校上課或要求導師上門授課

上課收費每班最多20人，每班收費$12,800

課程時數6小時

使用軟件Windows 365

入學要求需懂 Excel 基本功能，方能事半功倍

Show More

課程內容

Overview of Dataverse environments.
Types of environments: Default, Sandbox, Production, Trial.
Step-by-step guide to setting up a new environment.
Configuring regions, capacity, and environment-specific settings.
Best practices for managing multiple environments (e.g., Development, Testing, Production).

Understanding the importance of solutions in Dataverse.
Managed vs. unmanaged solutions.
Step-by-step guide to creating a new solution.
Adding components like tables, forms, and views.
Setting up a publisher and using prefixes for custom components.

Difference between standard and custom tables.
Step-by-step process for creating custom tables.
Configuring table settings (ownership, primary keys, etc.).
Practical example: Create a "Customer" table.

Overview of column types (Text, Choice, Lookup, Number, etc.).
Step-by-step guide to adding columns to a table.
Configuring advanced properties like default values and validation.
Practical example: Add "Email" and "Phone Number" columns to the "Customer" table.

Types of relationships: One-to-Many (1:N) and Many-to-Many (N:N).
Step-by-step guide to creating relationships between tables.
Configuring relationship behaviors (cascade rules, referential integrity).
Practical example: Create a one-to-many relationship between "Customer" and "Order" tables.
Practical example: Create a many-to-many relationship between "Products" and "Orders".

Role of views in displaying table data.
Types of views: System views and personal views.
Adding filters, sorting, and search capabilities.
Practical example: Create a "Recent Customers" view.

Types of forms: Main forms, quick view forms, and quick create forms.
Adding and arranging fields, sections, and tabs.
Designing forms for usability and accessibility.
Practical example: Create a "Customer Details" form with logical sections.

What are business rules and their purpose?
Adding logic and validation without code.
Step-by-step guide to creating, activating, and testing rules.
Practical example: Create a rule to ensure "Phone Number" is mandatory when "Email" is empty.

Role of visualizations in Dataverse.
Types of charts: Pie, Bar, Line charts, etc.
Step-by-step creation of charts for data visualization.
Combining views, charts, and Power BI reports into dashboards.
Practical example: Build a dashboard to visualize customer data by region.

Dataverse security model: Security roles, field-level security, and record-level security.
Step-by-step guide to creating and configuring security roles.
Managing users and assigning roles to teams.
Practical example: Create a "Sales Representative" role with limited access to customer data.

Introduction to Model-Driven Apps: Key components and use cases.
Step-by-step guide to building Model-Driven Apps.
Adding pages to display forms, views, and dashboards.
Practical example: Create an app for managing customers and tracking activities.

Customizing the navigation bar: Adding and organizing links to forms, views, and dashboards.
Customizing the command bar: Adding custom buttons and actions.
Using JavaScript or Power FX for advanced configurations.
Practical example: Add a "Send Email" button to the command bar of the "Customer" table.

Steps to publish the Model-Driven App for users.
Managing app access and permissions.
Collaboration features for teams.
Practical example: Share the app with the sales team and gather feedback.

Understanding managed and unmanaged solutions.
Steps to export a solution from the development environment.
Steps to import a solution into the production environment.
Best practices for solution layers and version control.

Instructor

Dannis Mok

who has rich experience in business web and apps system development and have over 20 years of teaching experience. He has great passion in learning and teaching new technologies and his teaching style is clear to point and can explain complex technologies in simple terms. He has delivered various workshops and classes for different corporate, government departments and local universities and is the principal lecturer for NCC Education and University of Greenwich. Besides BSc degree in IT, he also got a MBA, MSc in IT and MSc in Telecommunication degree.

企業客戶

Dannis Mok

導師曾教授以下客戶 - 辦公室軟件或者相關課程

Prince Hotel 香港太子酒店
Marco Polo Hong Kong Hotel 馬哥孛羅香港酒店
Kerry Warehouse 嘉里貨倉
Labor Department 勞工處
Baguio Green Group 碧瑤綠色集團
香港耆康老人福利會
Education Bureau 教育局
Hong Kong Institute of Education 香港教育大學
Hong Kong Housing Authority 香港房屋委員會
Hong Kong ICAC 香港廉政公署
Hang Seng Bank 恒生銀行
Civil Aivation Department 民航處
Darty Asia
UA Finance 亞洲聯合財務有限公司
基督教香港信義會
NCSI Hong Kong Ltd
香港善道會
恆生銀行
聯合國兒童基金會
City University of Hong Kong 香港城市大學
香港明愛
救世軍
City Facilities Management Holdings Ltd
HACEO 香港飛機工程
JLL 仲量聯行
Hong Kong VTC 職業訓練局
Hong Kong IVE 香港專業教育學院
Adidas Hong Kong
Polyplastics
Apex Logistics
Defond 德豐
JAS Worldwide
VTech Hong Kong 偉易達香港
VTech Hong Kong 偉易達香港
YWCA 女青年會
東華三院
iRobot Hong Kong
Bureau Veritas
Boardway 百老滙
StarLite Holdings (星光集團)
Puma Hong Kong
Marriott International 萬豪國際
WheeLock會德豐
香港立信德豪會計師事務所 (BDO)
Kering Group
中華電力有限公司
Wilko Worldwide Limited
華懋集團
機電工程署
無國界醫生
Unilever Hong Kong 聯合利華
獅王 (Lion Corporation)
菱電商事株式会社
Merck & Co 默克藥廠
九龍木球會
香港航空發動機維修服務有限公司
維他奶國際集團
Toyota 豐田汽車
adidas Hong Kong
連續五年 (2017,2018,2019,2020,2021) 為VTC 職業訓練局的員工作培訓
連續八年為勞工處YES的會員作”辦公室軟件”培訓
浸會大學
西門子 Siemens
Fujitsu Hong Kong
Luxasia
Miele
Pacific Coffee
PersolKelly
Schmoll Group
Johnson & Johnson
周大福集團
Tory Burch
南洋商業銀行
新鴻基
迪士尼樂園
一田百貨

Certificate in Dataverse and Model Driven Power Apps Development

課程簡介

課程目標

Dataverse

Relationship

Views and Forms

Business Rule

Charts & Dashboard

Security Roles

Interface Design

Publish and Secure Your Model Driven App

課程相關資料

課程內容

1. Setting Up the Environment

2. Setting Up the Solution and Publisher

3. Creating Tables in Dataverse

4. Adding Columns to the Tables

5. Creating Relationships Between Tables

6. Creating Views for the Tables

7. Creating Forms for the Tables

8. Creating Business Rules for the Tables

9. Creating Charts and Dashboards for the Tables

10. Creating Security Roles and Users

11. Building Model-Driven Apps

12. Updating the Navigation Bar and Command Bar

13. Publishing and Sharing Apps

14. Exporting and Importing Solutions

Instructor

Dannis Mok

相關專業認證

相關教學經驗

企業客戶

Dannis Mok

導師曾教授以下客戶 - 辦公室軟件或者相關課程

Our Clients

Enrollment Form for Dataverse and Power Apps

Please fill in the details

Enrollment details

Your enrollment details are as follows:

Class Code:

First Name:

Last Name:

Email:

DOB:

Mobile:

Other Phone:

Gender:

Chinese Name:

Address:

Enrollment Confirmation

Thank for your enrollment

We have already reserved a seat for you and wee will contact you soon to inform your payment procedures

Enquiry Form

Please fill in the details

Enquiry Confirmation

Thank for your Enquiry

We have received your question and will feedback you soon

Success

Error

Thank for your Enquiry

We have received your question and will feedback you soon