FutureSkills for Non-Tech: Business Intelligence & Analytics - 生产力学院
FutureSkills for Non-Tech: Business Intelligence & Analytics
10011448-01
香港九龙达之路78号
2021-05-27
李小姐 2788-5754 余小姐 2788-5029
angellee@hkpc.org

[只提供英文内容]

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

27 – 28 May 2021 (Thu & Fri)

Time

09:30 – 17:00

Duration

Total 12 lecture hours

Medium

Cantonese
(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

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 ▼