Certificate in Project-based Data Automation (Webinar)
Member discount is available exclusively if you log in as a member (Join us Now!)
When logged in, individual members should enrol themselves only, as non-members are not entitled to your member’s discount.
This programme provides a practical training on data automation without programming code. The purpose is to equip all participants with the skills and techniques to clean up data before transforming and consolidating them into nice data sets for subsequent analytic uses.
Key Takeaways
- Understand AI functions in Excel
- Practice how to do data cleansing and transformation with automation
- Practice how to consolidate dozens of Excel workbooks under a group of folders with automation
- Understand how the well-prepared data can be used for subsequent management dashboard development
Session 1: Learn and Practice Data Automation
AI Functions of Excel
Automate Excel column update without writing Excel formulas
No VBA programming skill required
Generally applicable
Introduction to Data Automation
Demonstrate how to automate data format transformation
Data Transformation with Automation
Cover more than 20 techniques of data transformation with practice
Session 2: A Common Use Case of Sales File Consolidation
Automate to combine 100 data sets into one single table in a short period of time
Facilitate preparation of management reports with one single table
No VBA programming, no Excel formulas, no copy-and-paste, no add-in software
Session 3: Demonstrate Use Cases for Data Automation and BI Analytics
Payroll consolidation
Automating restaurant POS management analytics
Consolidating staff training records and analytics
Staff recruitment analytics with data automation
Session 4: Student Presentation
Staff response records collected from an opinion survey (trainer-provided data set / student-prepared data set)
To qualify the course certificate, full programme participants are required to fulfil ALL requirements below:
- Attend all sessions; AND
- A pass mark in the presentation (17 January 2023, 09:30 – 13:00)
Dates： | 9, 11 & 17 January 2023 (Mon, Wed & Tue) |
Time： | 09:30 – 17:30 / 09:30 – 13:00 |
Language： | Cantonese (with English materials) |
Fee： Webinar： | Early bird offer (Valid till 9 December 2022) Regular Price Member – HK$5,400 Click here for other payment methods apart from credit card Login details will be sent before the commencement date of each session
|
Speaker
Mr Danny Chan
A seasoned data analytics professional with a strong professional background in the IT, retail and supply chain industries. He is highly proficient particularly in the areas of data science, data warehousing design, business intelligence (BI) solutions, statistical analysis, machine learning and cloud-based computing.