Unisoft Education

你會學到什麼 ?

Python 是一個易學易用的程式語言。在數據處理世界，佔有一個重要的地位。由於Python 擁有大量協助數據處理及繪製數據圖像的輔助程式庫，被數據分析師視為必學的程式語言。如再配合Excel及 Power BI的功能，便能將數據處理能力提升至另一層次，成為大數據處理分析的必學工具。課程零基礎入門，程式初手也能迅速上手。無論你是學生，職員，主管，業務行政人員等，都是必備的技術。自動化開啟檔案，瞬間會入大量資料，選出所需內容整理成 CSV 檔。自動將報表格式化，呈現清楚的內容。把繁瑣工作自動化，效率瞬間提升。讓你追求更高效率，減輕繁瑣的工作負擔。

共有4堂課程錄影，導師會由淺入深教授學員 Python 程式語言。然後利用各種的程式庫處理資料，例如利用 Pandas 處理表格性質的資料，利用 Matplotlib繪圖，並且利用 OpenPyXL和 Excel互動，最後更會學習如何在 PowerBI 使用 Python，完成一些 PowerBI 不能夠勝任的工作。

Tools

認識大數據分析的各種工具

Programming

學習程式設計語言基本語法

Decision Making

利用決策執行程式的不同部分

Iterations

利用迴路執行重複性的動作

Data Structures

靈活運用不同的資料結構儲存資料

Visualization

學習如何繪製不同的資料圖像

Excel Automation

配搭 Excel完成各種資料運作自動化

PowerBI

強化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 (10 hrs)

Environment Setup (Jupyter and VS Code)
Basic Syntax
Variable Types
Basic Operators
Decision Making
Loops (For, While)
Numbers and Strings
Lists and Tuples
Dictionary and Set
Functions and Lambda
List Comprehension

Pandas Series and DataFrames
Pandas Read CSV and JSON
Change Column, Rows and Data Types
Select Rows by Index Position or Labels
Select Columns by Name or Index
Add Column or Rows to DataFrame
Drop Column or Rows From DataFrame
Iterate Over Rows
Apply functions
Join, Merge and Concat DataFrames

Matplotlib Introduction
Matplotlib Plotting
Axis, Title and Label
Plot Parameters (Color, Size and Style)
Figure and Axes/li>
Multiplots
Using Subplots
Histogram and Bin Size Setting
Pie Plot and Scatter Plot
Box Plot and Line Plot

Read Excel file as Pandas DataFrame
Data checking for null, unique value and formatting
Data cleaning for null, spaces, cases and duplicates
Data preprocessing by merging, sorting, grouping and breakdown
Data extraction by location, by label, by condition
Data filtering by conditions (AND,OR,NOT)
Data summary by subtotal and pivot
Data output to excel or to CSV

OpenPyXL Introduction
Read Excel File
Iterating Rows and Columns
Iterating from a range
Create and Add Content to a Workbook
Write a List to Worksheet
Rename, Add and Remove Worksheet
Insert and Delete Rows and Columns
Set the Font, Alignment and Color for the Cells
Add a Bar Chart or a Pie Chart to the Worksheet
Example: Merge data from different invoices in hard disk to an Excel file, no matter how many there are

PowerBI basic concepts and workflow
Configure PowerBI with Python
Get Data using Python Scripts
Update the Python Script
Create the Visual using Python
Transform Data using Python
Introduction of Regular Expression
Regular Expression - Match, Search and Sub function
File System Module - OS vs PathLib
Example 1 - Remove Bad Email Address Rows
Example 2 - Mask out all phone numbers and ID card numbers
Example 3 - Create a new column to count how many words in the feedback column
Example 4 - Call external API to process data (Using Google Geocoding API)
Example 5 - Use OpenPyXL to consolidate Excel invoices distributed in different files and sheets

$1,980

Summer Promotion

學習影片10小時詳盡學習影片，由淺入深教學
面授錄影4堂(10小時) 面授課程錄影
觀看時限12個月
入學要求無需任何程式設計背景，有興趣請便可報讀
課程代碼:BIG202306

Excel Data Analysis

Data Science

Workflow Automation

Other Office Products

職業培訓課程

Excel Data Analysis

Data Science

Workflow Automation

Other Office Products

你會學到什麼 ?

Tools

Programming

Decision Making

Iterations

Data Structures

Visualization

Excel Automation

PowerBI

Entry Requirement

Instructor

Dannis Mok

相關專業認證

相關教學經驗

企業客戶

Dannis Mok

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

Course Content (10 hrs)

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

登入戶口: demopython

登入密碼: demopass

Certificate in Big Data Analysis using Python + PowerBI + Excel

你會學到什麼 ?

Tools

Programming

Decision Making

Iterations

Data Structures

Visualization

Excel Automation

PowerBI

Entry Requirement

Instructor

Dannis Mok

相關專業認證

相關教學經驗

企業客戶

Dannis Mok

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

Course Content (10 hrs)

Getting Started with Python

Getting Started with Pandas

Visualization using Mathplotlib

Excel Data Handling with Python

Excel Automation using OpenPyXL

Working with PowerBI

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

登入戶口: demopython

登入密碼: 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