Toggle navigation
Main content start

What's Happening Events

< Back to all upcoming events
03
May 2023
(Wed)

Automate business data transformation and consolidation for dashboard design (Demo Use Case: Staff Payroll Analytics) (3 May 2023)

Event of
Biz Win2Thrive Lunch Talk Series
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
03May 2023 (Wed)13:00 - 13:45
Venue
Kowloon West Campus
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
Automate business data transformation and consolidation for dashboard design (Demo Use Case: Staff Payroll Analytics)

Data Analytics is composed of Data Preparation and Data Visualization with Automation.

During this talk, the speaker is going to show you how to automatically consolidate individual monthly staff salary files into a single one before importing it to a Tableau dashboard workbook for the following multi-dimensional payroll analytics:

  1. Payroll Analysis by Departments, Teams, and Positions for all kinds of salary components
  2. Composition Analysis of payroll.
  3. Cross-Departmental payroll comparison
  4. Exceptional Salary (Outlier) Analysis
  5. Demographic Analysis on Payroll and Headcounts

Please register for the online talk and you will find it worthy for improving your understanding of data file consolidation and visual analytics.

The following are some of the sample dashboard screens for your preview:

a

aaaaa

Language: Cantonese (Supplemented with English)