Toggle navigation
Main content start

What's Happening Events

< Back to all upcoming events
22
Jan 2025
(Wed)

How can You Design a Dynamic Management Report to Boost your Report Productivity by 100X? (22 Jan 2025)

Subject
FinTech and Financial Analytics
Print
Date & time
22Jan 2025 (Wed)13:00 - 13:45
Fee
Free
Speaker
  • Mr Danny W. C. Chan (Practitioner in Financial Risk Management, IT and Data Science)

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.

REGISTER (ONLINE ATTENDANCE)
Enquiry
2867 8331 / 2867 8424 (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 can You Design a Dynamic Management Report to Boost your Report Productivity by 100X? (22 Jan 2025)

If you are asked to create the following Excel reports for your management:

1.      Monthly Sales Summary by Product Categories

2.      Monthly Profit Summary by Product Categories

3.      Monthly Sales Summary by Products

4.      Monthly Profit Summary by Products

5.      Monthly Customer Sales Summary

6.      Top 10 Customers by Sales Report

7.      Top 30 Products by Sales Report

8.      Top 10 Cities by Profit Report

9.      Top 5 Countries by Sales Report

10.  Top 3 Profit Summary by Product Sub-Categories

How many reports will you design?

Most people would develop 10 reports for their management, based on the instruction.

If you want to boost your work productivity, you would think about doing it once with only one dynamic management report to cover all of the above, and even more!

You may never have thought about doing this if don’t have the concept of dynamic management report design. 

Here it is, a webinar for you to explore a new Excel automation that can improve your report productivity by 100X, at least.

If you are interested in knowing a bit about the design, please don’t hesitate to register for the coming talk with the following link.

Mr Danny Chan, the speaker, lecturer and data consultant, will present to you the solution with a live demo.

Language: Cantonese (Supplemented with English)

Sample Screens: