CPHR CPD:  12.0

Session Topic

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 British Columbia & Yukon, and aligned to the CPHR Competency Framework, this 12-hour course explores HR-specific cases that cover recruiting, attrition, employee engagement, and much more.

DAY 1 - Data Analysis Foundations
Learn the basics of data analysis including Excel foundations, analytics process, and statistics with HR-related data sets.
Analytics Process
Excel Foundations
Descriptive Statistics

DAY 2 - Data Collection & Cleaning
Dive deeper into data collection with advanced Excel functions such as VLOOKUP and learn how to handle HR data.
Excel techniques (ie. VLOOKUPS & Pivot Tables)
Combining multi datasets
Data cleaning techniques & best practices

DAY 3 - Planning & Forecasting
Get to know Tableau and its dashboard functions. Learn to create linear regression models to identify relationships between variables.
Intro to Tableau
Basic building blocks of Tableau Dashboards
Linear Regression using Tableau

DAY 4 - Data Visualization and Dashboards
Visualize your findings and prepare insightful Tableau dashboards by creating a quarterly HR report. Learn how to turn your findings into a story.
Data visualization best practices & concepts
Build dashboards using Tableau

Interactive Live Online Classes

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

Online Mentorship
What if you have questions during or after each class? That’s where our mentorship comes in. Mentors and instructors are available to answer your questions in real-time, or on Slack.

About the Facilitator

Saadat Qadri, Modern Data Sciences Inc.
Saadat is a co-Founder & Principal at Modern Data Sciences Inc. He is a software engineer turned data engineer, with 8+ years of experience in designing complex data infrastructure systems. His passion includes helping spread data science/engineering education.

Lindy DeCoste, Data Analytics Instructor
Leveraging 10 years of pension data analytics experience as a qualified Actuary, Lindy DeCoste brings a unique skillset and perspective to her role as technical writer and instructor of the Data Analytics for Sales Leadership course.

Pricing

To learn more, click here.