Date & Time:

May 14 - 23, 2025
Wednesdays & Fridays | 3:00pm - 6:00pm

Pricing

CPHR Members –$1,400 + tax
*You will be prompted to enter your CPHR SK member id

Non-Members -$1,800 + tax

Continuing Professional Development (CPD):

This course is eligible for 12 CPD Hours

Program Description

Data is integral to HR. In fact, data analytics is often cited as one of the fastest-growing in-demand skills within HR. Data Analytics for HR - 101 is an introduction into how you can better collect, clean, analyze, and visualize data using Excel and Tableau to make better data-driven decisions in your role.

In conjunction with CPHR, and aligned to the CPHR Competency Framework, this 12-hour course (plus 3 hours of support work outside of classes) explores HR-specific cases that cover recruiting, attrition, employee engagement, and much more. * All participants will receive a certificate upon completion of this course.

DAY 1 Data Analysis Foundations

Learn the basics of data analysis, primarily Excel foundations and the analytics process. The main topics covered will be:

• Data Analysis Process and Asking Questions
• Analyzing Data and Excel Foundations
• Descriptive Statistics, Qualitative vs. Quantitative Analysis

DAY 2 Data Collection & Cleaning

Learn the necessary skills for cleaning and analyzing a data set. The main topics covered will be:

• Data collection and combining data sets
• Excel Techniques for Data Analysis
• Data-driven decision-making

DAY 3 Planning & Forecasting

By identifying patterns to solve business questions, defining what data should be collected and analyzed, and performing linear regression, this session builds the skills needed for effective workforce planning and forecasting. The main topics covered will be:

• Introduction to Tableau
• Utilize Tableau to explore and visualize data and a dataset
• Linear Regression

DAY 4 Data Visualization and Dashboards

Visualize your findings and prepare insightful Tableau dashboards. The main topics covered will be:

• Data visualization best practices & concepts
• Dashboard Planning
• Build dashboards using Tableau

This webinar is hosted by Lighthouse Labs. Registration, attendance and cancellations will be processed directly by Lighthouse Labs.