FutureSkills for Non-Tech: Business Intelligence & Analytics - HKPC Academy
FutureSkills for Non-Tech: Business Intelligence & Analytics
10012721-09
HKPC Building 78 Tat Chee Avenue Kowloon
2022-11-03
Ms CHEUNG 2788-5013 | Ms YU 2788-5029

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.

Date

03 – 04 November 2022 (Thu & Fri)

Time

09:30 – 17:00

Duration

Total 12 lecture hours

Medium

Cantonese
(supplemented by English and with English handouts)

Certificate of Achievement

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

Trainer

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 ▼