Share this Course

HR Analytics in Excel Masterclass

Provides practical, hands-on approaches to connect HR policies and practices to business performance.
Course Fee SGD1,795

Course Trainer

Dr. Fermin Diez has more than 35 years of experience in human resources, which includes consulting, corporate and academic roles in 40 countries in all continents.

As a consultant he has advised major multinationals, large local companies and public sector organisations at the Board and C-Suite levels. He has also managed the P&L in several geographical locations and businesses. As an HR leader, he has been Regional Head of HR for two large MNCs in AsiaPac and in Latin America.

He is currently Deputy CEO and Group Head of Human Resources for Singapore’s National Council for Social Service. He is also an Adjunct Professor at Singapore Management University and at Nanyang Technological University and is co-author of three books: ‘Human Capital and Global Business Strategy’, ‘The Remuneration Handbook: International Edition’ and ‘Fundamentals of HR Analytics’. Fermin has also previously taught Business Policy and Strategic Planning. He has been teaching WorldatWork course for over 20 years in the US, Puerto Rico, Australia, the UK, Malaysia, India, Singapore, Indonesia and Hong Kong.

He has served on the Board of the Jurong Health Systems, where he also was a member of the HR Committee. He was also a member of the HR Committee at the National University Health System Group. He has also served in the Singapore Management University Business School Advisory Board, Taylor’s Education Group Advisory Board, the Children’s Cancer Foundation Board and the Board of Directors of World@Work, where he is currently on the Global Advisory Council. Fermin is also a member of the Board of Directors of the Institute of HR Professionals, where he Chairs the Assessments and Insights Committee and is the Dean of HR Education. He is also a Fellow of the Singapore Institute of Directors.

Fermin obtained his PhD from Singapore Management University, his MBA from the Wharton School, University of Pennsylvania and his undergraduate degree in Psychology from the University of Michigan.

Who Should Attend

Any HR Professional who wishes to go beyond the descriptive statistics and reports, and begin to link HR Policies to Business Outcomes. Particularly welcome are those HR Professionals that understand that they need to “get better at HR Analytics”, but find the current course offerings too heavy on techniques and tools like advanced statistics and programming language, and wish to have a more practical approach to day-to-day application to common HR issues.

Testimonial

5 star rating
5 star rating
5 star rating
5 star rating
5 star rating
“Both trainers were very well-versed with the topics they were teaching, and were able to provide real life insights and examples as well. Tools and discussions were useful and applicable in a work of HR professional. Overall, an enjoyable training session!”
5 star rating
5 star rating
5 star rating
5 star rating
5 star rating
“Dr Fermin’s suggestions are very useful and the practical element in the whole workshop is high (not only theory).”

Course Introduction

HR today must provide data-driven insights on implementing and executing strategy through people. The HR Analytics in Excel Masterclass provides practical, hands-on approaches to connect HR policies and practices to business performance, using excel as the main tool to carry out the analyses and visualization.

We introduce a framework for Data-analytical thinking; become familiar with available tools to complement Excel; discuss data collection, clean-up, and warehousing; practice building descriptive and predictive models; and get hands-on experience in applications for workforce planning, recruitment, compensation, training, career planning and turnover. By the end of the module, participants will be able to put HR analytics skills and excel to good use.

Learning Objectives

By the end of this 2-day module, participants will:

  • Understand and use a data-driven approach, skills and tools to link HR policies and programs to business results.
  • Apply data-analytic thinking, data management and modelling.
  • Learn about various popular tools available, such as Workday, Tableau, PowerBI, etc. However, we will rely on excel, as it is an accessible tool for all participants, and widely used in practice.
  • In tandem, participants will understand how data is to be collected, prepared for analysis, and stored so it can be used with the various tools.
  • Use a data-driven approach to address questions on workforce planning, recruiting, training, career planning, pay and turnover rates.

Session Topics

A Framework for Data-analytic Thinking

In this section, we will cover the principles of data-analytic thinking, including hypotheses building, visualization and storytelling.

Tools for Data-driven People Decision Making

The objective of this section is to have a look at available popular and easy-to-use tools for HR Analytics.

Data Collection, Clean-Up, and Warehousing

This section is about understanding data and how to use it. We will discuss structured (internal) data, big data (external), and how to ensure the validity, reliability, and generalizability of data for consistency and clarity. We will also talk about storing of data so it can be consolidated and accessed.

Data-driven People Decision Making Modelling

We will cover three main ideas in this section:
● Graphs tell stories
● Developing and testing hypotheses and models
● Data analytical thinking

Practical Applications

Turnover

This is where most Data-driven People Decision Making programs are focused in practice. We will look at a simple, yet powerful, way to address this issue.

Training and Development

Attracting staff is an essential task of HR. The objective of this section is to examine what it takes to ‘hire’ successful employees, in terms of quality, longevity and fit.

Employee Engagement

This section will consider the important, but elusive, concept of the ROI of training linked to business outcomes.

Recruiting

Link of employee engagement to business outcomes.

Pay Plans

Pay is the traditional “data-driven” area of HR. We will address the impact of pay programs on outcomes and look at a seldom-appreciated area of Rewards: Benefits Administration.

Career Planning

To illustrate the importance of setting career tracks and how analytics can be used to support this important HR process.

HR Policies Vs. Profit

To wrap up the module, this section will bring to light the links between HR policies and company profitability

NOTE: Participants will be provided with slides for all lectures, and the excel spreadsheets with the data for all exercises.

Suggested books and Readings

Fundamentals of HR Analytics: Diez, Bussin & Lee, 2019, Emerald Publishing. If you are interested in this book, you can purchase it through the following either link:

Amazon Google Play

Other Recommended Readings

Business Analytics, 2nd Ed; Evans, 2017, Pearson (BA).
Retooling HR; Boudreau, 2010, HBR Press (RHR).
Human Capital Analytics; Pease, Byerly & Fitz-enz, 2013, Wiley (HCA).
The Power of People; Guenole, Ferrar & Feinzig, 2017, Pearson (POP).
Making Human Capital Analytics Work; Phillips & Phillips, 2015, McGraw-Hill (MHCAW).
Data Science for Business; Provost & Fawcett, 2013, O’Reilly (DSB).
Statistical Analysis: Microsoft Excel; 2013 (SA).

Course Outline

Lecture: Basic Finance and Statistics concepts needed for HR Analytics
Lecture: Principles of data analytic thinking

Discussion: Where does data come from?
Exercise: Researching for available benchmarks

Discussion: Creating and testing hypotheses
Exercise: Each graph tells a story

Case: Analysing turnover in an Indian semiconductor company
Discussion: How to improve the turnover predictive model?

Discussion: Why do we do training?
Exercise: Calculating ROI of training

Discussion: Importance of accuracy in forecasting people needs
Exercise: Forecasting people needs in a retail company

Discussion: How to develop a good hiring profile Exercise:
Which sourcing channels yield the best recruiting outcomes?
Discussion: What do we pay for?
Exercise: ROI of a sales compensation program

Discussion: Career Planning as probabilities
Exercise: Developing a career lattice
Discussion: Linking Employee Engagement Data to Business Data

Discussion: How does HR demonstrate that it adds value?
Exercise: If you had a million dollars to improve HR, how would you spend it?

Frequently Asked Questions

Have questions or need help? Please feel free to get In touch with us 🙂


enquiry@hrd-future.com


(65) 6980 7730

  • Any recent version of excel
  • Will require at least the Analytic Toolpak (in excel, should be found under Insert > Add ins > Get add-ins and then add the analytics toolpak. You may also want to add the Solver add-in

Certificate of Attendance Upon completion of the course, you will receive a Certificate of Attendance bearing the signatures of the Course Organizer and Facilitator.

To ensure that you gain maximum benefit from this event, a detailed questionnaire will be sent to you to establish exactly what your course needs are. The completed forms will be analysed by the course facilitator. As a result, the course is delivered at an appropriate level and that relevant issues will be addressed.

You can register online by filling the registration form on our website. Alternatively, you can also register by email or phone.

To register by e-mail, please send the delegates name, job title, email address, company name and telephone number to enquiry@hrd-future.com or alternatively you can email the scanned copy of the completed registration form.

For more information, please call +65 69807730

All our public events are conducted in English, unless otherwise stated. English subtitle are available for some of the online courses.

The registration fee includes admission to the events, exam and cert for certification courses.

For in-person course, a comprehensive set of documentation material in both printed and digital format or only printed format for some of the course distributed at the venue, lunches and 2 refreshment breaks for in-person classes. Hotel accommodation and travel costs are not included in the registration fee; however, we do have corporate rates with the hotel venue. Email to enquiry@hrd-future.com for more information.

There is no deadline for registration. However, for some courses, sometimes we do limit the number of delegates to ensure optimum course interaction. We advise you to register as early as possible in order to avoid disappointment and to allow adequate time for our administration process. for in-person class, if you need to register on the day itself (walk-in registration), then kindly contact our customer service department at +65 69807730. If time restricts, you can go directly to the event venue, and approach our officer in charge over there. Our personnel will assist you with subject to seat availability.

Full payment must be received within seven (7) working days upon receipt of invoice or before the event date, whichever is earlier.  A LOU with company stamp is requested for those organizations that cannot make payment on time.

Payment Mode

(1) BANK TRANSFER (USD/SGD only)

  • Account Name: HRD Future Pte Ltd
  • Account Number: 695-207639-001
  • Beneficiary Bank: Oversea-Chinese Banking Corporation Limited
  • Beneficiary Bank Address: 65 Chulia Street OCBC Centre Singapore 049513
  • Swift Code: OCBCSGSG

For other currencies, we may provide you a different bank account depends on currencies. Email to enquiry@hrd-future.com for more information.

(2) CHEQUE

Please make all cheques payable to: HRD Future Pte. Ltd. (Appliable in Singapore Company only)     

(3) CREDIT CARD

We are using Stripe as the credit card payment gateway. Additional credit card charges per transaction are applied. Please contact our team for more details.

Can I change the name/details of the delegate(s) after registration?

Yes, a name can be changed at no additional cost. Please email enquiry@hrd-future.com providing the details of the delegate(s) you wish to replace and the details of the replacement(s). This email should include:

  • Full names, titles and positions in company
  • Company name
  • Direct telephone (for any urgent purpose)
  • Delegate’s email address (for us to send the Pre-Course Reading Material and Questionnaire)

I have registered for an event but I can no longer attend, what is your cancellation policy?

Cancellation policy can always be found in the Terms & Conditions section of your registration form. Basically, cancellations can be made if it is submitted more than 30 days prior to the event.

For cancellations received less than 30 days prior to the event, you have several options:

  • You can send a replacement as we do substitution free of charge
  • If no one from your organisation can attend, formal written request for withdrawal is required and an acknowledgement sent out. If the request is done before a month of the commencement date, a credit voucher is issued to the organization to be used within 12 months of the date of issuance.

Can I get a copy of the delegate list prior to the event?

We do not disclose delegate list prior to the event taking place. A list of participants will be available at the event only.

Can I get a copy of the course materials prior to the event for self-study?

Yes for some of the courses. However since we always update course materials closer to the event date to ensure all data is most updated, we are only able to provide course materials approximately one week before the event dates. A full payment is requested in order to receive the course material in advance.

What is the dress code for the event?

Most of our delegates who attend our courses prefer to wear business/ smart casual clothing. No shorts please. You can also bring optional formal clothing for your personal dinner or networking functions.

Who should I inform about my dietary requirements?

We will email you the event details letter approximately two weeks before the day of the events. You can highlight any special dietary requirements by reply the email.

Share this Course