Unisoft Education

你會學到什麼 ?

PowerBI 能將企業中現有的數據進行有效的整合，快速準確地提供報表並提出決策依據，幫助企業做出明智的業務經營決策。作為一個大數據時代的資訊工作者，掌握Power BI 將對你的工作有決定性的優勢。本課程為一個 Excel 進階課程，專為有志加強 Excel知識的人士而設。學習課程後，學員可利用 Power BI加強 Excel各項分析功能，超越 Excel的資料分析限制

Data Model

如何由不同來源匯入資料至資料模型

Transformation

如何將匯入的資料作不同形式的重組及變形

Relationships

如何為資料表建立不同類型的關係

Visualization

如何利用豐富的圖像去表達資料的內容

Cloud and Mobile

如何上載分析結果至Power BI Service及Power BI Mobile

Filtering

如何運用各種過濾器及格式化工具去篩選資料

Measures

如何利用DAX functions 寫出各種實用的分析公式

Insights

如何利用Power BI雲端服務作自動化資料探索

Entry Requirement

報讀者需懂 Excel 基本功能，方能事半功倍

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
南洋商業銀行
新鴻基
迪士尼樂園
一田百貨

Course Content (6 hrs)

Installing and running PowerBI Desktop
Applying PowerBI Service free account
Installing PowerBI Mobile Apps
Understanding the PowerBI Desktop and Query Editor

Importing Excel data into PowerBI Desktop
Importing Access database into PowerBI Desktop
Importing CSV text files into PowerBI Desktops
Importing data from other data sources

Define data types for different columns
Transform existing columns (text,number,date)
Adding and removing columns or rows
Unpivot data by transposing columns and rows
Modifying query and undoing steps)

Appending multiple queries
Merging queries by different join types
Query from a folder
Understanding M language
Conditional columns and Add Column from Example

Understanding Star schema and Snowflake schema
Building the 1 to many and 1 to 1 relationships between tables
Understanding filter context and its flow direction
Understanding active and inactive relationships
Adding a Date table for time intelligence functions

Buidling various reports by using the visuals
Choosing various visuals for presenting data
Introducing Matrix,Columm,Stack,Bar,Pie,Waterfall,KPI,Gauge,Maps
Grouping and binning data
Applying various filters (Visual,Page,Report,Drillthrough)

Uploading data and reports from PowerBI Desktop
Building a PowerBI dashboard
Preparing data sets for Q&A natural language queries
Sharing dashboard to other PowerBI accounts
Accessing the reports through PowerBI Mobile

Creating calculated columns and measures using DAX functions
Understanding implicit and explicit measures
Using CALCULATE functions to alter the filter context
Using FILTER functions to filter data
Introduction to Time Intelligence functions
Understanding implicit and explicit measures
Using RELATED and RELATEDTABLES functions to relate data
Understanding SUMX,COUNTX,AVERAGEX,MAXX,MINX functions to summarize data
Creating calculated table by using SUMMARIZE functions

$980

Summer Promotion

面授錄影6小時詳盡學習影片，由淺入深教學
觀看時限12個月
課程代碼:PBI202306

Excel Data Analysis

Data Science

Workflow Automation

Other Office Products

職業培訓課程

Excel Data Analysis

Data Science

Workflow Automation

Other Office Products

你會學到什麼 ?

Data Model

Transformation

Relationships

Visualization

Cloud and Mobile

Filtering

Measures

Insights

Entry Requirement

Instructor

Dannis Mok

相關專業認證

相關教學經驗

企業客戶

Dannis Mok

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

Course Content (6 hrs)

請登入網上學習系統觀看更多示範。

登入戶口: demopowerbi

登入密碼: demopass

Certificate in Microsoft Power BI for Business Intelligence Analysis

你會學到什麼 ?

Data Model

Transformation

Relationships

Visualization

Cloud and Mobile

Filtering

Measures

Insights

Entry Requirement

Instructor

Dannis Mok

相關專業認證

相關教學經驗

企業客戶

Dannis Mok

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

Course Content (6 hrs)

Understanding PowerBI

Importing Data to PowerBI

Data Cleansing and Transformation

Advanced Transformation

Design a Data Model

Report and Visualizations

PowerBI Services and Mobile

DAX functions

請登入網上學習系統觀看更多示範。

登入戶口: demopowerbi

登入密碼: demopass

Enrollment Form for MRN202306

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