SA101 -Professional Design of a Stock Analytic System

Course Outline:

How to collect historical stock prices in HK
Transform the collected stock price record to an appropriate format for presentation
Present the transformed stock price datasets in a useful layout to facilitate analytics and investors’ review.
Visualize the macro trend of the stock market performance (i.e. whether the stock market is bull or bear)
Identify if a stock market sector performance is improving or not
Select stocks that that recently performance well or worse
Identify stocks that are oversold or overbought
Visualize stock price trend with a candlestick chart, Bollinger Band Chart, etc.

Course Description

Course Objectives:

In the dynamic landscape of financial markets, the ability to extract actionable insights from stock data is paramount. This course offers a comprehensive exploration into the intricacies of designing robust analytic systems tailored specifically for the Hong Kong stock market. Through a fusion of theoretical concepts and practical applications, participants will delve into the realms of data analytics, leveraging the advanced capabilities of Power BI techniques, and implementing efficient data automation processes.

Target Audience:

This course is ideal for professionals and enthusiasts seeking to enhance their proficiency in stock market analytics, particularly focusing on the Hong Kong market. It is suitable for:

Financial analysts
Data analysts
Stock traders
Business intelligence professionals
Anyone interested in leveraging data analytics for stock market insights

Features

Exclusive System: Access a proprietary stock analytic system developed by a renowned Hong Kong-based data analytics specialist - Mr Danny Chan.
Industry Expertise: Learn from a lecturer with extensive experience in Hong Kong's financial sector, providing practical insights and real-world examples.
Tailored Curriculum: Experience a curriculum customized for the Hong Kong stock market, covering data acquisition, Power BI, and data automation.
Hands-On Power BI: Gain practical skills with Power BI through workshops and exercises focused on data visualization and analysis.
Data Automation Focus: Explore the efficiency of data automation for timely insights and rapid decision-making.
Networking Opportunities: Connect with peers for collaboration and idea exchange, enhancing your professional network.
Ongoing Support: Receive personalized guidance and mentorship throughout the course.

Pre-requisites

Basic Understanding of Stock Markets
Basic Computer Literacy
Interest in Data Analytics and Stock Trading

Medium of Instruction

Cantonese, supplemented with English

Required Software

Computer installed with a browser (e.g. Microsoft Edge or Google Chrome)

Date, Time & Duration

Date:

Time: TBC
Duration:

7 hours (1-Day) or
3.5 + 3.5 hours = 7 hours (2-Days)

Course Fee

Course Price: $2,200 HKD
Early Bird Discount: -$200 HKD per student

(7 days before the class starts)

Mode of Instruction

Online: By Zoom (Zoom link will be provided upon successful enrolment)

Data Files & Course Materials

The organizer will provide an URL for downloading the required items before the course commences.

If you’d like more information about this course, get in touch today.

Student's Review

"Danny Sir, I would love to share this with you. I went to a job interview that I really wanted to do. It was a public organization. They tested me on executing an excel file with thousands of rows of data which I had to use Power Query to do it. I was so happy that I have learned power query from you! "