Two HR Professionals Sitting At A Desk Talking

A course built with HR professionals in mind.

You have access to an employee’s data from recruitment, onboarding, ongoing training, performance reviews, coaching interactions, promotions and lateral moves, from when an employee joins a company, to when they leave. You have the data, but do you know what to do with it? We have the answers.

Data Analytics for HR - 101 will teach you how to make better informed data-driven decisions in your career. By using Microsoft Excel, the universal language for spreadsheets, and Tableau, a data visualization software, you'll be able to confidently leverage data in your day-to-day. Built in conjunction with CPHR British Columbia and Yukon, this 12-hour course is aligned to the CPHR Competency Framework.

"HR has always had data. But it’s the way teams interpret and extract insights from that data that separates legacy and modern HR teams." - Fast Co.

Dates and cost

Data Analytics for HR - 101 kicks off on Nov. 25.

Classes are three hours in length, and at 4-7 p.m. ET. on Nov. 25, and Nov. 27, Dec. 2, and Dec. 4. Classes are streamed in real-time, with mentor support on-demand during class time, and after hours via Slack.

The cost is:

  • $1,400 for CPHR BC and Yukon members.
  • $1,800 for the general public.

Registration closes on Nov. 20, 2020.

What Does The Course Cover?

Being ‘data literate’ allows HR professionals to benchmark against industry standards, diagnose problems, and come up with actionable solutions.

Data Analytics for HR 101 Curriculum Package

Data Analytics For HR - 101 walks you through an introduction to data analysis, data collection, data cleaning and organization, and visualization.

These pillars of learning will build your foundation to continue to learn and use the skills and tools in your day-to-day role in HR.

Specific data analysis topics include:

  • Analytics process
  • Descriptive statistics
  • Excel techniques (ie. VLOOKUPS & Pivot Tables)
  • Combining multi datasets
  • Data cleaning techniques & best practices
  • Tableau (dashboards, linear regression, quarterly HR reports)

And specific HR topics include:

  • Employee engagement
  • Employee attrition
  • Workforce planning
  • Forecasting
  • Building a quarterly HR performance deck

Who's The Course For?

HR Professional Sitting at A Desk Talking To A Colleague

No experience is required for this data analytics course.

Regardless of your career path, data analytics permeates to all facets of the workforce making it one of the most valuable and in-demand skills in Canada. In fact, Randstad lists Microsoft Excel as one of its eight most valuable skills to learn within the HR field.

"People analytics is a foundational capability of modern HR." - Fast Co.

If you're in any of the following specialties, this course would add value to your day-to-day, and help you streamline working with messy datasets:

  • Talent Acquisition Specialist
  • Director of HR
  • HR Business Partner
  • Talent Acquisition Coordinator
  • Payroll Coordinator
  • Compensation and Benefits Manager
  • Employment, Recruitment and Placement Specialist
  • HRIS Analysts
  • HR Generalist
  • HR Consultant

Is There A Certificate?

All participants will receive a certificate upon completion of this course.

“The advent of the big data era means that analyzing large, messy, unstructured data is going to increasingly form part of everyone’s work.” — Harvard Business Review

For CPHR BC & Yukon members, one (1) credit of Continuing Professional Development (CPD) for every hour of participation will be awarded. This 12-hour course offers 12 CPD credits for course completion.

How Do I Enroll?

Head to our registration page, and you'll be prompted to pay a deposit to reserve your seat in the course. Then, pay the remaining balance before the course begins.