OVERVIEW
12 Hours over
4 Days
CPHR Credit*
Rolling Start Dates
HRPA Credit
HR Cases & Data
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.
* CPHR Nova Scotia, CPHR Saskatchewan, CPHR Alberta, CPHR Manitoba, CPHR New Brunswick and CPHR BC & Yukon members will be given one (1) credit of Continuing Professional Development (CPD) for every hour of participation. Up to 12 CPD credits available for course completion.
WHAT YOU WILL DO
DAY 01
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 02
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 03
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 04
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