Download Training Directory (2021) Download Now

Mar 2021

HR Analytics: Understanding People Issues with Data (Live Stream)

Course Information

Start Date10 Mar 2021, Wednesday
End Date11 Mar 2021, Thursday
Time9.30am to 4.30pm
VenueOnline via Zoom
Fee$990 (excluding GST)
ContactRoshini | 6720 3333 | training.aventis@gmail.com
Register Now
Get Group Quote
LIVE Stream


“Analytics” has been a very hot buzzword in recent years; and has led many organizations and professionals to invest heavily in the topic. But not many have it figured out; in fact, many continue to struggle to see returns on their investments. HR, being late to the game are facing similar challenges, but can benefit from learning from their lessons.

This 2-day workshop is designed to provide a broad yet comprehensive overview of HR Analytics by introducing you to the analytics value chain; from defining the HR problem to processing data, conducting analysis, making sense from the data and finally building a compelling HR narrative for decision making. You will not only be introduced to key concepts but also get their hands dirty with HR Data through realistic HR case simulation.

This workshop is targeted at HR practitioners who are keen to find out more about HR analytics and to try their hands at applying HR analytics in their areas of work. The workshop will be delivered through lectures, case studies, videos and interactive hands-on exercises that span across many HR applications. You will be able to experience how HR Analytics can help organizations objectively and quantifiably understand your people issues through data and create value in the process.

Course Highlights
  • Appreciate the HR Analytics value chain, and how it can be applied to help organizations objectively and quantifiably understand people issues through data
  • Transform data into powerful insights into six simple steps and take away a structured analysis framework for action
  • Appreciate fundamental technical skills in data management, data preparation and transformation to facilitate analysis
  • Conduct descriptive analyses to inform and explain the state of the workforce and HR practices
  • Appreciate key concepts in statistics as a foundation for conducting analysis
  • Exposure to the various statistical techniques applicable to understand people issues
  • Build a concise, coherent, and compelling HR narrative to support decision making
  • Experience applying the above through a realistic HR case in a facilitated capstone exercise
Target Audience
  • HR professionals and practitioners who are keen to find out more about HR analytics
  • HR professionals and practitioners who are keen to experience what it takes to succeed with HR analytics and/or create value with HR data
  • HR leaders looking to unlock the potential in their HR data and build sustainable analytics capabilities
  • HR business partners looking to build analytics skills play a more strategic role in their organization
  • All other professionals with a keen interest in developing data analytics skills in the HR domain

Participants are required to bring their own laptops with MS Excel and Powerpoint (version 2013 or later) to participate in the data and capstone exercise. Prior data, analytics or statistics training is helpful, but not necessary.

Course Outline

1. What is Analytics and what it takes to create a sustainable value chain

  • This segment seeks to define what analytics is and isn’t, why it matters in today world and what it takes to build sustainable value.
  • Delegates will also be introduced to the analytics value chain

Translating data to insights and insights into decisions

  • This segment provides an overview of the six-step approach to conducting analytics. Delegates will see how the analytics process really works and seeks to dispel several myths about the process

Data Management: Preparation and Transformation

  • This segment focuses on one of the precursors to any data analytics activities – data preparation. This is largely a hands-on session with multiple computer-aided exercises on a wide range of HR-related problems. Attendees will get to prepare sizable data sets for data analytics, which include
    • Merging multiple data tables
    • Understanding the use of system vs calculated data fields
    • This will include the use and application of several key functions and tools within MS Excel

Data Visualization

  • Once the data is prepared and transformed, it needs to be ready for analytics. One very effective way to capitalize on data is through reports; more specifically interactive reports where users can see metrics and trends relevant to their areas.
  • This is a computer-aided session to build the key skills to design and build interactive dashboards and infographics with MS Excel
    • Principles of data visualization
    • Design and build interactive data visualizations
  • Demo: Data visualization tools (e.g. Tableau, PowerBI)
  • Class exercise: Building interactive HR Dashboards with MS Excel
Data Expert: Michael Lee

Michael Lee is an associate of FYT Consulting Pte Ltd. An IT professional by training with more than 25 years of consulting & practical experience across many functions (sales, client management, business operations & customer service) throughout various roles (Vendor, Systems Integrator, Distributor and Enduser) in both the public & private sector.

Prior to joining FYT Consulting, Michael has done consultancy and process re-engineering for several SMEs. He has also conducted numerous training sessions on Virtual Teaming for international banks and corporations. In addition, he has made many speaking engagements in Customer & Partner events, as well as in major international Sales Conferences.

Michael has managed the Asia Pacific Sales Operations for Linksys, a division of Cisco Systems. His portfolio included the day-to-day operations within the Asia Pacific. He was also running the China sales for almost a year. Prior to that, Michael led the Asia Pacific Sales Operations for Cisco System and the Business Operations for Customer Service in Asia Pacific & Japan in Cisco. In addition, he headed a global Metrics & Business Intelligence team comprising members from the Asia Pacific, Europe and the Americas. Before joining Cisco, Michael worked for Peoplesoft, AT&T GIS, SAP and National Computer Systems (SCO). Michael holds a Bachelor’s degree in Computer Science & Mathematics as well as an MBA from the National University of Singapore

Data Expert: Joanna Tan

A seasoned leader in Human Resource Business Partnering with more than 25 years of diverse industry, Joanna has experience with reputable multinational and local corporations such as Sage Software, Hasbro, Apple, IBM, Rockwell Automation and Wing Tai Holdings. She has proven success in managing and rolling out major organization change initiatives involving various key stakeholders especially with the sales and marketing teams in driving revenue and margin optimization using business metrics and intelligence.

Joanna currently consults and leads engagements to help FYT clients build HR analytics capabilities across many sectors and regions, including technology, government, pharmaceutical, sales & finance across the Asia Pacific Region. She also has a strong background in talent management and development, organization design, change management as well as employee engagement. Joanna holds a Bachelor’s Degree in Arts with National University of Singapore and a Graduate Diploma in Business Administration with Singapore Institute of Management. In addition, she is accredited in Advanced Certificate in Training and Assessment (ACTA v5).


“If you are planning to become an HR data-driven organisation, this is the course to be inspired. Full marks for the trainer!” – Head of HR Services, Boehringer Ingelheim

“An extremely knowledgeable and hands-on trainer who gave deep insights from his wealth of experience.” – Regional HR Director, Emery Oleochemicals Malaysia

“This course was well-structured and delivered by an effective trainer. Thumbs up!” – HR Director, SingTel