Hong Kong Productivity Council Academy

FutureSkills for Non-Tech: Business Intelligence & Analytics

Enquire Now

Course Information

  • 27 May 2021 (Thu) - 28 May 2021 (Fri) 9:30 AM - 5:00 PM
Registration period
23 Mar 2021 (Tue) - 20 May 2021 (Thu)
HKD 4,800
(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.)
Course Level
Study Mode
12 Hour(s)
HKPC Building 78 Tat Chee Avenue Kowloon

Course Overview

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

What you'll learn

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

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed