|
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.
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 Remote classes use live-stream technology to encourage collaboration. Our instructors and mentors provide personalized help for all your questions to allow you to work through the activities.
Hands-on People Analytics Activities
Collect, clean, analyze and visualize data for:
- 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 | Members | $1,400 | | Non-Members | $1,800 |
To learn more, click here. 
|
Print Page
