Toggle navigation
Main content start

What's Happening Events

< Back to all upcoming events
06
Sep 2023
(Wed)

How to Automate a Dynamic Sales Grouping? (6 Sep)

Subject
FinTech and Financial Analytics
Print

Thanks for your participation!

The above event has been completed successfully. Please look forward to the upcoming events.

Want to read more about the event recap?

Date & time
06Sep 2023 (Wed)13:00 - 13:45
Fee
Free
Speaker
  • Mr Danny W. C. Chan

Mr Danny W. C. Chan

Mr. Chan, FRM, has possessed rich experience in financial risk management, information technology and data science and worked as IT Manager over a decade. Being a practitioner in information technology, he is currently a consultant and trainer at Big Data Consultancy Services Company. Also, he is strong in Cloud-based solutions, Big Data Technology, Data Mining and Machine Learning. Moreover, Mr. Chan has obtained a Bachelor Degree in Mathematics from The Chinese University of Hong Kong as well as three Master Degrees in Risk Management Science from The Chinese University of Hong Kong, Quantitative Analysis for Business from City University of Hong Kong and Industrial Logistics Systems from The Hong Kong Polytechnic University.

Enquiry
2867 8331 (finedec@hkuspace.hku.hk)
Relevant Programmes
Postgraduate Diploma in FinTech and Legal Regulations Postgraduate Diploma in Financial Analytics and Algo Trading Postgraduate Diploma in Finance and Data Analytics Certificate for Module (Technical Analysis and Data Analytics for Stock Investment) Certificate for Module (Business Intelligence and Data Automation) Certificate for Module (Business Analytics and Web Scraping) Executive Certificate in Interpretation and Visualization of Business Big Data Big Data and FinTech Executive Workshop Series - Big Data and Data Visualization Big Data and FinTech Executive Workshop Series - Applied AI and Business Analytics
moreRelevant Programmes
How to Automate a Dynamic Sales Grouping?

Supposing that your company sales transactions are scattered in a number of files by months under folders by years, how would you consolidate all of the sales before you answer a number of questions like the following ones:

1.      Which customers buy only a kind (i.e., category) of product items?

2.      Which customers buy exactly two sub-categories of products?

3.      Which cities ship goods in only one kind of shipping mode?

4.      Which products are sold in most countries?

There can be a lot more similar management questions.  How can we answer all of them in one go with automation with Excel?

a

Mr Danny Chan is going to demonstrate his solution with powerful Excel functions.  This technique is called Excel Data Automation (not VBA). You will watch this done in seconds.  Is that awesome? If you are interested in learning this amazing skill, why don’t you register for this webinar with the link below?

Language: Cantonese (Supplemented with English)