UNiSOFT Education Center

Certificate in Tableau Data Analysis and Visualization

大數據時代超吸睛視覺化工具與技術 Tableau 資料視覺化分析證書課程

課程簡介

Tableau 是 SaleForces 旗下的 BI 軟件工具，世界500強企業裡面96%是Tableau的客戶。Tableau 提供客戶最容易上手的視覺化分析平台，透過簡單易用的介面進行資料整理與計算，快速產製各類視覺化的儀表板，進一步可透過 Tableau Server 或 Tableau Online 發佈到網路上，有效的與企業內外分享協作，促成以資料做決策的企業文化轉型。強勁的功能讓它快速的布建到各行各業的各單位中，迅速取代傳統 Excel 及 BI 工具，成為各大企業的報表開發與決策支援平台。

課程目標

Data Model

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

Transformation

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

Relationships

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

Visualization

如何創建多姿多彩及美觀的圖表

Calculated Field

如何利用 Calculated Field 創造新的欄位作資料分析

Calculation

如何理解 Table Calculation 和 LOD Calculation

Analysis

如何運用分析工具預測及分類資料

Sharing

如何分享報告成果給其他人分享

課程相關資料

課程對象針對企業客戶而設
上課模式面授上課或者即時網上教學
上課安排客戶可到本校上課或要求導師上門授課
上課收費每班最多20人，每班收費$12,800
課程時數6小時
使用軟件Excel 2010, 2013, 2016. 2019, Office 365 均可
入學要求需懂 Excel 基本功能，方能事半功倍

課程內容

The Tableau application suite
Installing Tableau Desktop
Understanding the Workspace interface
Input the Data from different data sources
Understanding how to create the relatinships
Understanding Live and Extract connections
Editing the model's metadata and datatypes

Understanding Worksheet and Dashboard
Creating Charts using Show Me
Understanding Rows, Columns and Mark Pane
Encoding extra information with Color, Size, Text, Details and Tips Shelf
Understanding Dimension and Measures
Adding hierarchies for organizing fields
Convert Dimension to Measure or Measure to Dimension
Create and Show the Filter to filter data

Creating Data Visualizations
Creating and encoding the Bar Chart
Formatting the Bar chart
Creating the Stacked Bar Chart and Side by Side Chart
Creating the Line Chart and Area Chart
Creating the Pie Chart and Tree Map
Creating the Text Table and Heat Map
Use the Dual Axis and Sync Axis to create combo charts
Use the Scatter chart to find the cluster
Use the Line chart to find the trend and forecast
Use the Bullet chart to compare actuals and targets
Use the Box and Whisker to find the key statistics
Use the Gantt chart to keep track of the process
Use the Bump chart to compare the ranking

Creating the Calculated Field
Split, extract and combine text to create new field
Use dateadd(), datediff(), dateparse(), datepart() to handle date field
Use if then else or case when to make decision
Use iif() or ifnull to check condition
Use the new fields to create charts
Use the Parameter to peform What-If Analysis

Understanding different types of calculation
Use the Quick Table Calculation
Use the Table Calculation to find running total
Use the Table Calculation to find moving average
Edit the Table Calculation to change calculation order
Understanding the Level of Details (LOD)
Apply the LOD calculation using fixed dimension
Apply the LOD calculation using include dimension
Apply the LOD calculation using exclude dimension

Overview of the Tableau analytics pane
Add Constant, Average, and Medium with Quartiles
Add different types of Trend lines
Add the forecast lines to forcast data
Use the Cluster analysis in scatter chart

Create the Dashboard
Applying the filter of each chart
Controlling the layout of the dashboard
Understanding Tableau online and Tableau server
Understanding Tableau public
Publishing data sources on the server
Publishing visualization on the server

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 Tableau Data Analysis and Visualization

課程簡介

課程目標

Data Model

Transformation

Relationships

Visualization

Calculated Field

Calculation

Analysis

Sharing

課程相關資料

課程內容

Introduction to Tableau

Adding Data Sources in Tableau

Creating Data Visualizations

Calculated Fields and Parameters

Table Calculations and Level of Detail Calculations

Trends, Forecasts and Clusters

Creating the Dashboard and Sharing with Others

Instructor

Dannis Mok

相關專業認證

相關教學經驗

企業客戶

Dannis Mok

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

Our Clients

Enrollment Form for Tableau

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