FutureSkills for Non-Tech: Business Intelligence & Analytics - HKPC Academy
FutureSkills for Non-Tech: Business Intelligence & Analytics
HKPC Building 78 Tat Chee Avenue Kowloon
Ms LEE 2788-5754 Ms YU 2788-5029
 Enquiry    Print  

Programme Highlights

  • A customised workshop for non-technical executives to understand simple numeric and data analysis.
  • Use of simple data analytics tools (e.g. excel, R etc.) to generate insights for improving business results.

Learning Outcomes

By taking this course, you will be able to

  • Create dashboard and visualization by using Business Intelligence tools
  • Use simple Excel VBA script for numeric data cleansing and calculation
  • Use simple R data science scripts for more complicated data analysis tasks
  • Understand the essential overview and terminology in using and deploying AI
    and Machine Learning

Course Fee – RTTP Approved

HK$4,800/ HK$4,320*
*Group discount for 2 or more, Membership discount: 10% discount off the original listed price

For RTTP applicants: HK$1,600# (Original price: HK$4,800)
#Maximum saving, with the final grant subjects to approval.

This course is an approved Reindustrialisation and Technology Training Programme (RTTP) with up to 2/3 course fee reimbursement upon successful applications. For details: https://rttp.vtc.edu.hk.


27 – 28 May 2021 (Thu & Fri)


09:30 – 17:00


Total 12 lecture hours


(supplemented by English and with English handouts)

Award of Certificate

A Certificate of Attendance will be awarded to participants who have attended 75% or above of the course.

Course Structure

 Day 1 (6 hours)
 1. Introduction to Artificial Intelligence
 A. Emerging Trends in AI and Big Data
B. Trends and History
C. Predictive Analytics in Smart City
D. Applications in Business Analytics
E. Applications in Document Image Analytics
 2. Applications of Deep Learning
 A. Applications in commercial sectors
B. Applications in Government
 3. Basic Excels VBA Scripts for Analysis (on Commercial Data)
 A. Common Numeric Functions in Excels
B. User-Defined Data Processing in VBA Scripts
C. Writing a simple Macro Functions
 4. Data visualization in BI
 A. Introduction to Business Intelligence
B. Creating a simple Dashboard in BI
C. Import Data into BI
D. Showing Charts in BI
 Day 2 (6 hours)
 5. Basic R Scripts for Analysis (on Commercial Data)
 A. Installation for R
B. Basic Numeric Data Import from Files
C. Basic Numeric Data Export to Files
D. Data Tables Manipulation
E. Data Rows Slicing and Merging
F. Data Column Replacing
 6. Simple Analytic Trend Prediction using AI function in R
 A. Basic Machine Learning Concepts
B. Simple Trend Prediction with Regression in R
C. More Trend Prediction Data Handling
 7. Put Everything Together: Business Intelligence + R Analytics
 A. Display Visualization from R or AI functions
B. Examples and Exercises
 8. Case Studies in Commercial Cases with BI & Analytics
 A. Project Considerations, Concern and Security
B. Applications in more commercial cases
C. Tips on Deployment of BI and Analytics


Alan LEE has held senior management role in technology group, overseeing the corporate strategy, product development and production management for more than 14 years. With strong IT background, he possesses practical project experience on sophisticated analytics and large-scale global technology project management.

He also has rich training experience in the design and delivery of digital transformation training including AI, Big Data, Blockchain, etc.

Download Full Course Detail ▼