Main content start
Change.每天多學一點 改變.可大可小

Accounting & Finance FinTech and Financial Analytics

Executive Certificate in Interpretation and Visualization of Business Big Data
行政人員證書《商業大數據視覺化及資訊演繹》

Course Code
EP129A
Application Code
2270-EP129A
Study mode
Part-time
Start Date
18 Feb 2025 (Tue)
Next intake(s)
Jun 2025
Duration
1 month to 2 months
Language
English
Course Fee
Course Fee: $9300 per programme
(*course fees are subject to change without prior notice)
Deadline on 04 Feb 2025 (Tue)
Enquiries
2867 8331 / 2867 8424
2861 0278
Apply Now

Today and Upcoming Events

22
Jan 2025
(Wed)

How can You Design a Dynamic Management Report to Boost your Report Productivity by 100X? (22 Jan 2025)

If you are asked to create the following Excel reports for your management: 1.      Monthly Sales Summary by Product Categories 2.      Monthly Profit Summary by Product Categories 3.      Monthly Sales Summary by Products 4.      Monthly Profit Summary by Products 5.      Monthly Customer Sales Summary 6.      Top 10 Customers by Sales Report 7.      Top 30 Products by Sales Report 8.      Top 10 Cities by Profit Report 9.      Top 5 Countries by Sales Report 10.  Top 3 Profit Summary by Product Sub-Categories How many reports will you design? Most people would develop 10 reports for their management, based on the instruction. If you want to boost your work productivity, you would think about doing it once with only one dynamic management report to cover all of the above, and even more! You may never have thought about doing this if don’t have the concept of dynamic management report design.  Here it is, a webinar for you to explore a new Excel automation that can improve your report productivity by 100X, at least. If you are interested in knowing a bit about the design, please don’t hesitate to register for the coming talk with the following link. Mr Danny Chan, the speaker, lecturer and data consultant, will present to you the solution with a live demo. Language: Cantonese (Supplemented with English) Sample Screens:

Accept new applications for Feb 25 intake! Don't miss the chance. Come and join us! There are practical classes in the computer laboratory. The programme uses Tableau to introduce data wrangling, data modelling, and data visualization. Our professional lecturer will illustrate various business, sales, and marketing analyses. Also, storytelling and the selection of data and chart for business presentations will be discussed. Welcome to your online application!

Highlights

This programme aims to provide students with the basic concepts and knowledge about Big Data and to develop their skills in interpreting Big Data. It provides a practical approach for the students to apply statistical methods to analyze data and to equip them with techniques to perform data visualization for business and financial Big Data.
 

ECIVBBD

You will learn the following techniques with Tableau Desktop:
·       Design of Management Dashboard
·       Top N / Bottom N Analysis
·       Visual Exception Highlighting
·       Sales Forecasting and Trend Analysis
·       Actual and Target Comparison with Bullet Charts
·       Market Basket Analysis
·       New Customer Analysis
·       Scatter Plot of Sales and Profit
·       Pareto Distribution of Sales
·       Moving Average Analysis and Bollinger Band applicable to stock price and sales volatility
·       Financial Analysis with YTD, QTD, MTD, Rolling Sum, Compound Growth Percentage
·       Rank Analysis with Bump Chart
·       Tree Map, Motion Chart, Bubble Chart, Box-and-Whisker Chart and their Business Applications
·       Storytelling with Views for Presentation
·       Sharing Views with Tableau Public

You will be able to learn each of the above techniques with a hands-on practical approach and no programming skill is assumed. Also, the programme will give you a brand new idea of interpreting business in a top-down manner and collecting correlations visually without looking into huge volume of data.

Programme Details

On completion of the programme, students should be able to:
- Explain Big Data concepts and explore the challenges and opportunities in business applications
- Interpret business and financial data and perform analysis using statistical methods
- Apply computer software to visualize the Big Data
- Analyze the Big Data from business and financial perspectives

Application Code 2270-EP129A Apply Online Now
Apply Online Now

Days / Time
  • Tue, Fri, 7:00pm - 10:00pm
Duration
  • 30 hours per module
  • 5 hours per session
Venue
  • Hong Kong Island Campus
  • Kowloon East Campus
  • Kowloon West Campus

Modules

Course Content

(1) Introduction to Big Data and Data Wrangling

(a)  Concepts of big data and the domain of data technologies

(b)  Introduction to data preparation, data visualization and visual analytics
- Data cleansing
- Data transformation
- Data consolidation
- Data automation
- Report automation and dashboard design
(c)  Comparison between common Business Intelligence (BI) tools

 

(2) Concept of Dashboard Design

(a)  Factors of a good dashboard design
(b) Strength of Tableau as a visual analytics tool
(c) Dashboard design for dynamic analysis
(d) Chart design with motion

 

(3) Data Visualization and Interpretation

(a)  Practice with Tableau
- Introduction to Tableau (versions, components, licenses and pricing)
​- Design of management dashboard
​- Top N / bottom N analysis
​- Visual exception highlighting
​- Sales forecasting and trend analysis
​- Actual and target comparison with bullet charts
​- Market basket analysis
​- New customer analysis
- Scatter plot of sales and profit
- Pareto distribution of sales
- Moving Average with YTD, MTD, rolling sum, compound growth percentage
- Rank analysis with bump chart
- Motion chart, bubble chart, Box-and-Whisker chart and their business use
(c) Business applications
- Expense control dashboard
- Income statement dashboard with breakdown and trend analytics
- Payroll analytics dashboard
- Stock price analytics dashboard

Assessment method: in-class exercises + group presentation

The Executive Certificate will be conferred to candidates who pass in continuous assessment and final assessment as well as achieved at least 70% attendance of the programme.

 

Teacher

1) Mr. Chung
Mr. Chung is a specialist in Machine Learning, Statistical Analysis and Data Science. He received his Bachelor and Master Degree in Mathematics from the University of Toronto. He had been a Mathematics and Statistics lecturer in HKUSPACE Community College for more than six years. Since 2013, he became interested and has been doing research in Data Science and Machine Learning. Coming from an academic background, and then working as a machine learning engineer and data scientist, Mr. Chung likes to discuss Data Science and Machine Learning from both theoretical and practical perspectives.

2) Mr. W. C. Chan
Mr. W. C. Chan, a passionate and highly committed data science and computer professional, Mr Chan sees the importance of lifelong learning and keeps himself abreast of the latest data technologies. He is highly proficient in the areas of visual analytics, business intelligence (BI) solutions, statistical analysis, data science, machine learning and cloud-based computing.
Mr Chan graduated from the Mathematics Department in CUHK. He is a seasoned data analytics professional with a strong background in IT, Retail and Supply Chain Industries. He obtained three master’s degrees from three universities, namely Risk Management Science from CUHK, Quantitative Analysis for Business from the City University of HK and Industrial Logistics Systems from Hong Kong Polytechnic University.
In 2021, Mr Chan accredited the title of Tableau Certified Associate Consultant. He is also a principal consultant for a data technology consulting services company, specialized in implementing BI solutions and report data automation.

Class Details

Timetable

Feb 2025 intake

Lecture Date Time
1 18 Feb 25 (Tue) 19:00 - 22:00
2 21 Feb 25 (Fri) 19:00 - 22:00
3 25 Feb 25 (Tue) 19:00 - 22:00
4 28 Feb 25 (Fri) 19:00 - 22:00
5 4 Mar 25 (Tue) 19:00 - 22:00
6 7 Mar 25 (Fri) 19:00 - 22:00
7 11 Mar 25 (Tue) 19:00 - 22:00
8 14 Mar 25 (Fri) 19:00 - 22:00
9 18 Mar 25 (Tue) 19:00 - 22:00
10 21 Mar 25 (Fri) 19:00 - 22:00

Remarks :
-Tentative timetable is subject to change, and course commencement is subject to sufficient enrollment numbers
-
To ensure that students’ academic progress is not affected, the School may substitute face-to-face classes with online teaching if face-to-face classes cannot be held.

Fee

Application Fee

HK$150 (student only needs to pay one time application fee for all EC in Big Data Series)

Course Fee
  • Course Fee: $9300 per programme
    (*course fees are subject to change without prior notice)

Entry Requirements

Applicants shall hold:
-A bachelor’s degree awarded by a recognized University or equivalent; or
-An Associate Degree/ a Higher Diploma or equivalent, and have at least 2 years of relevant working experience.

Applicants with statistical background are preferred. Those with other qualification and substantial senior level work experience will be considered on individual merit.

**Please upload copy of HKID and proof of qualification while applying online. 

Apply

Online Application Apply Now

Application Form Download Application Form

Enrolment Method
Payment Method
1. Cash, EPS, WeChat Pay Or Alipay

Course fees can be paid by cash, EPS, WeChat Pay or Alipay at any HKU SPACE Enrolment Centres.

2. Cheque Or Bank draft

Course fees can also be paid by crossed cheque or bank draft made payable to “HKU SPACE”. Please specify the programme title(s) for application and applicant’s name. You may either:

  • bring the completed form(s), together with the appropriate course or application fees in the form of a cheque, and any required supporting documents to any of the HKU SPACE enrolment centres;
  • or mail the above documents to any of the HKU SPACE Enrolment Centres, specifying “Course Application” on the envelope. HKU SPACE will not be responsible for any loss of personal information and payment sent by mail.
3. VISA/Mastercard

Applicants may also pay the course fee by VISA or Mastercard, including the “HKU SPACE Mastercard”, at any HKU SPACE enrolment centres. Holders of the HKU SPACE Mastercard can enjoy a 10-month interest-free instalment period for courses with a tuition fee worth a minimum of HK$2,000; however, the course applicant must also be the cardholder himself/herself. For enquiries, please contact our staff at any enrolment centres.

4. Online Payment

Online application / enrolment is offered for most open admission courses (enrolled on first come, first served basis) and selected award-bearing programmes. Application fees and course fees of these programmes/courses can be settled by using "PPS by Internet" (not available via mobile phones), VISA or Mastercard. In addition to the aforesaid online payment channels, new and continuing students of award-bearing programmes with available online service, they may also pay their course fees by Online WeChat Pay, Online Alipay or Faster Payment System (FPS). Please refer to Enrolment Methods - Online Enrolment  for details.

Notes

  • If the programme/course is starting within five working days, application by post is not recommended to avoid any delays. Applicants are advised to enrol in person at HKU SPACE Enrolment Centres and avoid making cheque payment under this circumstance.

  • Fees paid are not refundable except under very exceptional circumstances (e.g. course cancellation due to insufficient enrolment), subject to the School’s discretion. In exceptional cases where a refund is approved, fees paid by cash, EPS, WeChat Pay, Alipay, cheque, FPS or PPS by Internet will be reimbursed by a cheque, and fees paid by credit card will be reimbursed to the credit card account used for payment. 

  • In addition to the published fees, there may be additional costs associated with individual programmes. Please refer to the relevant course brochures or direct any enquiries to the relevant programme team for details.
  • Fees and places on courses cannot be transferrable from one applicant to another. Once accepted onto a course, the student may not change to another course without approval from HKU SPACE. A processing fee of HK$120 will be levied on each approved transfer.
  • HKU SPACE will not be responsible for any loss of payment, receipt, or personal information sent by mail.
  • For payment certification, please submit a completed form, a sufficiently stamped and self-addressed envelope, and a crossed cheque for HK$30 per copy made payable to “HKU SPACE” to any of our enrolment centres.