HR Analyst $797 18 hours

6-week online course

By analyzing HR data you will determine the impact of people related policies on your organization’s bottom line. This entry-level course teaches you to conduct data cleaning and analyses using Excel. Using PowerPivot and PowerQuery functionalities in Excel, you’ll learn how to extract, merge, clean and analyze (large) datasets. You’ll also learn how to build custom dashboards and apply strategic personnel planning (SPP) within your organization.

As an HR Analyst, your focus is on the data side of human resources management. By leveraging the power of (HR) data you will provide decision makers with the insights to make better people decisions. This specialization offers a unique opportunity to get a solid understanding of (HR) data and basic data analysis.

Frequently Asked Questions

Pre-approved continuing professional development hours by the following HR associations:

Enroll Now

Learning Objectives

  • Learn to do data cleaning, data analysis, and strategic personnel planning in Excel
  • Learn to work with the Excel extensions PowerPivot and PowerQuery
  • Learn to calculate the ROI of HR activities
  • Learn to apply strategic workforce planning within your organization
  • Learn to aggregate, clean and analyze data (in Excel)
  • Learn to plan different scenarios to anticipate the future
  • Learn to create custom HR dashboards
  • Online Video Lessions

    Access to course materials and online video classes for a 12 month period.

  • HR Datasets

    Use our datasets to familiarize yourself on working with HR data.

  • Q&A Moments

    Use the Q&A Moments to ask questions to your instructor(s).

  • Hands-on Experience

    Tutorials provide hands-on experience with analyzing people data.

  • Community

    Join our exclusive community of practitioners to brainstorm ideas, discuss problems and share results.

  • Certificate of Completion

    After finishing your course you will receive a certificate of completion by email. If your HR association has pre-approved this course for CPD hours, your certificate will include an ID number for your CPD log.