Skip to content Skip to footer
0 items - $0 0
Hong Kong Institute of Human Resource Management
0 items - $0 0
Hong Kong Institute of Human Resource Management
Close
Advanced Power BI - for HR Professionals
Advanced Power BI - for HR Professionals - Image 2
Advanced Power BI - for HR Professionals - Image 3

Advanced Power BI – for HR Professionals

Start
2026-10-08
End
2026-10-08
Time
09:30 - 17:00

$3,445

Venue: Infocan computer training room, 8/F, Yen Sheng Centre, 64 Hoi Yuen Road, Kwun Tong

Language: Cantonese (with materials in English)

CPD Hours: 6.5

Pricing:

 

  Price Early Bird Offer

[Only if enrolment & payment are received by 4 September 2026]
Member HK$2,400 HK$2,200
New Member  (Inclusive of new membership joining fee) HK$3,645

 

 HK$3,445

 

 

*HKIHRM e-voucher is NOT applicable to the early bird offer or other discount offer.

*The new member bundle provides access to our premium training course at the exclusive member rate, combined with a full one-year Affiliate Membership.

Categories: , ,

Click here for flyer

This workshop will focus on advanced data transform advanced data transform and and DAX functions DAX functions to to perform calculation and data marsh. In addition, you can use Calculated Column perform calculation and data marsh. In addition, you can use Calculated Column and Measures to and Measures to perform advanced analytic analysis in common use cases. perform advanced analytic analysis in common use cases.

Enrol now to enhance your HR value in the data-driven world!

Upon completion of this course, participants will be able to:

  • Use Power Query to combine text/Excel files in folder
  • Extract keys, use date/time locale, and unpivot data
  • Handle multiple relationship and parent/child hierarchies
  • Describe evaluation contexts for calculation
  • Use advanced expressions to perform aggregating and comparing data over time
  • Design data model and calculation in different use case scenarios

Combine Source Data in Power Query

  • Append or Merge Queries
  • Write M in the Query Editor
  • Load Multiple Excel files by Functions

Advanced Data Transform Data

  • Extract key by Split Column
  • Convert Date & Time Column
  • Unpivot Cross Tab Table

Advanced PowerPivot Data Modelling

  • Manipulate Tables and column
  • Create a Time Table
  • Use advanced relationships
  • Understand hierarchies
  • Use parent/child hierarchies

DAX Functions

  • Recap filter context and CALCULATE function
  • Recap Calculated Columns and Calculated Measures
  • Use DATE, STATISTICAL, VALUES, LOGICAL and INFORMATION, and TEXT Functions

Understand evaluation contexts and CALCULATE

  • Filter a single column
  • Filter with complex conditions
  • Use TIME INTELLIGENCE functions
  • Use OPENINGBALANCE and CLOSINGBALANCE functions
  • Use inactive relationship

Power BI Analytic cases for HR

  • Create Calculated Measures
  • Performance Management trends
  • Compensation & Benefits variances
  • Training metrics

Enhanced User Experience

  • Configuring Drill Through
  • Configuring conditional formatting
  • Using Bookmarks and Parameters
  • HR professional
  • Helpdesk support
  • Business user

Mr Paul Wu

Paul is a Microsoft Certified Trainer with over 10 years of training experience on Power BI and Microsoft Office Applications for all levels of users in various industries.

___________________________________________________________________________

Paul’s technical knowledge, professional and patient personalities, together with the excellent interpersonal and communication skills has made him stand out among the trainers. This wealth of experience allows him to easily identify areas where most clients encountered while learning the topics. Similarly, he is also able to precisely troubleshoot problems and specifically address the client’s needs.

Paul has extensive ACCA and Power BI training experience in a wide range of industries including banking, accountancy firms, mass transportation organization, luxury retail brands etc.

Qualification

•    Royal Melbourne Institute of Technology University
      >  Bachelor of Business Administration
•    City Polytechnic of Hong Kong
      >   Higher Diploma in Information Systems
•    Jointly Diploma of The Hong Kong Polytechnic University and The Hong Kong Management Association
      >  Diploma in Management Studies
•    Microsoft Certified Trainer (MCT)
•    Microsoft Certified Solutions Associate
•    Microsoft Certified IT Professional
•    Microsoft Certified Technology Specialist
•    Cisco Certified Network Associate

Professional Experience    

•    Experience in conducting partner training in IT industries, and deliver customize IT training and seminar for large-scale organizations.
•    Speaker for different Microsoft Events e.g. Microsoft Tech Summit.
•    With advanced knowledge in Power BI and Microsoft Office Applications.
•    Deliver training fluently in medium of both Chinese and English.

Competencies  

•    Power BI
•    Microsoft Project
•    Microsoft Office Access
•    Microsoft Office Excel
•    Microsoft Office PowerPoint
•    Microsoft Office Word
•    Microsoft Windows
•    Microsoft Office Outlook
•    IBM Lotus Notes

Enquiry:

Mr Jacky Chan

Tel: (852) 2837 3830

Email: learning@hkihrm.org

You may also like

E-mail*
Set Your Password*
Confirm Your Password*
** Your password must be minimum of 8 characters in length and use at least three of the following: uppercase letters, lowercase letters, numbers, and symbols.** eg. A12345^ /// Ab1234
  • I understand and agree that the personal data provided above will be used by the Institute for direct marketing activities and notification according Privacy Policy until further notice.
  • Your registered email address will serve as your login ID.
?
Join as member
to enjoy exclusive discount
 

訂閱HKIHRM最新資訊 Subscribe HKIHRM's Latest Update

【開放給非會員】登記電郵以獲取學會最新消息及公告。   想收取所有會員資訊？請立即入會！ 【Open for Non Members】Sign up for our email updates to get the latest news and announcements.   Seeking ALL information? Apply membership now!

*必填 indicates required
info@hkihrm.org

I understand and agree that the personal data provided above will be used by the Institute for direct marketing activities and notification according Privacy Policy until further notice.

我已明白並同意上述個人資料將由學會根據《私隱政策聲明》用作直接營銷活動及通訊之用，直至另行通知。

我已閲讀並同意以上條款。 I have read and agree to the above Terms. *

彰顯您的專業資格：香港人力資源管理學會資深會員 – F.I.H.R.M.(HK)

F.I.H.R.M.(HK) 標誌著您作為香港人力資源管理學會的資深會員，此乃香港人力資源專業知識的權威基準。

此資格代表您對業內高標準、道德實踐及持續發展的承諾。

展示方式：
自豪地展示您的成就。請在所有專業資料中統一標明 F.I.H.R.M.(HK) 會籍。範例參考：

  1. 名片
    您的姓名, F.I.H.R.M.(HK)
  2. LinkedIn 標題
    人力資源領導者 | 香港人力資源管理學會資深會員 (F.I.H.R.M.(HK)) | 專注於人才策略與組織發展
  3. 履歷 / 個人簡介
    「作為香港人力資源管理學會資深會員 (F.I.H.R.M.(HK))，我致力推動人力資源實踐的專業標準。」/

    「持有香港人力資源管理學會資深會員資格 (F.I.H.R.M.(HK))，此為香港人力資源領域之權威專業認證，標誌著對行業最高標準之認可與承諾。」

立即更新個人資料，讓 F.I.H.R.M.(HK) 資格成為您專業能力的最佳證明。

Showcase Your Designation: Fellow Member – F.I.H.R.M.(HK)

The designation F.I.H.R.M.(HK) marks you as a Fellow Member of the Hong Kong Institute of Human Resource Management, the definitive benchmark of HR expertise in Hong Kong.

This designation signifies a commitment to high standards, ethical practice, and continuous development in the field.

Where to Display It:

Be proud of your achievement! Incorporate F.I.H.R.M.(HK) consistently across your professional profile. Sample is as below.

  1. Business Cards

Your Name, F.I.H.R.M.(HK)


  • LinkedIn Headline

HR Leader | Professional Member of the Hong Kong Institute of Human Resource Management (F.I.H.R.M.(HK)) | Specialising in Talent Strategy & Organisational Development

 

  1. Resume/Bio
    “As a Fellow Member of the Hong Kong Institute of Human Resource Management (F.I.H.R.M.(HK)), I am committed to upholding the professional standards of HR practice.” / 

 

“Holder of the F.I.H.R.M.(HK) designation, which denotes recognised expertise and a formal commitment to continuous professional development within the Hong Kong HR sector.”

Update your profile today and let your F.I.H.R.M.(HK) designation speak for your professionalism.

彰顯您的專業資格：香港人力資源管理學會專業會員 – M.I.H.R.M.(HK)

M.I.H.R.M.(HK) 標誌著您作為香港人力資源管理學會的專業會員，此乃香港人力資源專業知識的權威基準。

此資格代表您對業內高標準、道德實踐及持續發展的承諾。

展示方式：
自豪地展示您的成就。請在所有專業資料中統一標明 M.I.H.R.M.(HK) 會籍。範例參考：

  1. 名片
    您的姓名, M.I.H.R.M.(HK)
  2. LinkedIn 標題
    人力資源領導者 | 香港人力資源管理學會專業會員 (M.I.H.R.M.(HK)) | 專注於人才策略與組織發展
  3. 履歷 / 個人簡介
    「作為香港人力資源管理學會專業會員 (M.I.H.R.M.(HK))，我致力推動人力資源實踐的專業標準。」/

    「持有香港人力資源管理學會專業會員資格 (M.I.H.R.M.(HK))，此為香港人力資源領域之權威專業認證，標誌著對行業最高標準之認可與承諾。」

立即更新個人資料，讓 M.I.H.R.M.(HK) 資格成為您專業能力的最佳證明。

Showcase Your Designation: Professional Member – M.I.H.R.M.(HK)

HKIHRM Members’ Privilege – Asia Council Membership of The Conference Board (TCB)

The designation M.I.H.R.M.(HK) marks you as a Professional Member of the Hong Kong Institute of Human Resource Management, the definitive benchmark of HR expertise in Hong Kong.

This designation signifies a commitment to high standards, ethical practice, and continuous development in the field.

Where to Display It:

Be proud of your achievement! Incorporate M.I.H.R.M.(HK) consistently across your professional profile. Sample is as below.

  1. Business Cards

Your Name, M.I.H.R.M.(HK)

 

  • LinkedIn Headline

HR Leader | Professional Member of the Hong Kong Institute of Human Resource Management (M.I.H.R.M.(HK)) | Specialising in Talent Strategy & Organisational Development

  1. Resume/Bio
    “As a Professional Member of the Hong Kong Institute of Human Resource Management (M.I.H.R.M.(HK)), I am committed to upholding the professional standards of HR practice.” / 

“Holder of the M.I.H.R.M.(HK) designation, which denotes recognised expertise and a formal commitment to continuous professional development within the Hong Kong HR sector.”

Update your profile today and let your M.I.H.R.M.(HK) designation speak for your professionalism.

需要幫助？想加入我們？有問題想查詢？

我們隨時為您服務！請留言給我們，我們的團隊會盡快回覆您。

      Pesonal Information

      Training Information

      Need assistance? Interested in joining us? Or just have a question?

      We’re here to help! Reach out via message, and our team will respond as quickly as possible.

        Asia Council Membership

        HKIHRM Members’ Privilege – Asia Council Membership of The Conference Board (TCB)

        As a HKIHRM Fellow and Professional Member, you are entitled to a 20% discount for joining the Asia Council Membership of TCB, an international think tank that delivers trusted insights for what’s ahead.

        TCB of Asia Council package offers a peer network, a portfolio of thought leadership, and access to experts to help address your job challenges and strengthen your team and organisation’s performance. By bringing together select senior executives from the world’s leading companies, the Council engages you in an immersive, solutions-focused conversation.

        The Asia Council Membership includes:

        • Two to three in-person meetings a year
        • Private Council website
        • Council bench-marking surveys and dedicated support from your Council team

        Eligibility:

        • Active HKIHRM Fellow and Professional Members
        • Individual basis
        • The application is subject to TCB’s vetting and approval

        Discounted Offer (1st year of membership only)

        • Year 1: USD 9,000 (USD 7,200)

        Application & Enquiry:
        Mr Brendan Moran
        Email: Brendan.moran@conference-board.org Tel: +65 6645 4696

        Reciprocal Membership

        Mutual Recognition of Professional Membership between HKIHRM and Canada-based CPHR British Colombia & Yukon

        HKIHRM has established mutual recognition of Professional Membership with the Chartered Professionals in Human Resources of British Columbia and Yukon CPHR British Colombia & Yukon since 2015. This understanding is based on a recognition of ‘substantial equivalency’ of the F.I.H.R.M.(HK) or M.I.H.R.M.(HK) designation to those of the CPHRTM designation, a CPHR British Colombia & Yukon’s Chartered Professional in Human Resources designation. HKIHRM Fellow Members and Professional Members are eligible to obtain the CPHRTM designation from CPHR British Colombia & Yukon.

        • To become a Professional Member M.I.H.R.M.(HK) of HKIHRM, please click HERE  for more information. Application form can be downloaded HERE .
        • To become a CPHRTM member of CPHR British Colombia & Yukon, please click HERE for more information. Application form can be downloaded HERE.

        Enquiry:

        HKIHRM: +(852) 2837 3814, membership@hkihrm.org 

        CPHR British Colombia & Yukon: Please send your application directly to cphr@cphrbc.ca, https://cphrbc.ca/cphr/i-am-a-cphr/cphr-mutual-recognition/

        Terms and Conditions

        1. Membership fee is charged for members joining between 1 April and 31 March for one-year or two-year subscription. (and subject to meeting mandatory CPD requirement for Professional-route-based Membership  only for renewed Fellow, Professional and Associate Members)
        2. Entrance and annual subscription fees are subject to review by the Institute without prior notice.
        3. HKIHRM will notify members to renew their membership via mail and email every year in March. Members can settle renewal fee by different payment methods marked in the invoice and enjoy the discount rate if the renewal fee is settled before the early bird period. E-vouchers will be provided if the renewal fee is settled.
        4. The upgraded membership fee is charged for members joining between 1 April and 31 March for one year or two years subscription (Same as selected membership renewal period).
        5. Member must have a valid membership and meet the upgrade requirements in order to apply for a membership upgrade. For assistance with the application process, please contact Member Services Team.
        6. Those aged 60 or above AND on permanent retirement may notify HKIHRM by email to enjoy 50% discount on the individual membership fee.
        7. Members can apply for membership reinstatement after their membership has been suspended since the introduction of new membership scheme on 1 April 2010 by:
          • paying a reinstatement fee (all the outstanding annual membership fee since his / her suspension); and
          • providing CPD records for the year(s) showing you have met the CPD requirement since you have ceased to be a member (if applicable)
        8. HKIHRM shall has absolute discretion in respect of each application to decide conclusively whether he / she has fulfilled the conditions applicable to his / her case or not. The decision of the HKIHRM is final and shall not be subject to any appeal. Membership fee is non-cancellable and non-refundable.


        If you have any enquiry on membership, please contact
        Member Services Team (2837 3814 / 2837 3813) or email at membership@hkihrm.org.