Our priority is the safety of our community. All programs at Lighthouse Labs are available remotely. Learn more.

DATA ANALYTICS FOR HR - 101

Learn how to turn your people data into meaningful results. Grow your HR career.

In partnership with:

COVID-19: LEARN FROM HOME 🔻

LEARN FROM HOME 🔻

For six years, we’ve delivered hands-on education to growth-minded professionals, equipping them with the tech-driven skills for the future of work. Now, we're taking our programs fully online to ensure the safety of our community and prepare our learners for the increasingly remote workforce.

See the Online Experience

Course Overview

  • Total Hours

    12 Hours over
    4 Days

  • Start Date

    Rolling Start Dates

  • HR Cases & Data

    Hr Cases

  • CPHR Credit*

    Cphr Credit

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 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 LEARN

  • 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
  • Download Curriculum

    First Name*

    Email Address*

    City*


    Download Curriculum

How we Teach.

How We Teach
  • 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.

MESSAGE FROM CPHR BC & YUKON AND OUR GRADS

PAYMENT & DATES

CPHR Members

$ 1,400 Register Now

General Public in North America

$ 1,800 Register Now

Start Dates

Dec 01 - Dec 10

Format**

Wed & Fri 4:00:00 PM EST

* All CPHR members are eligible for the discount. Only members from Nova Scotia, New Brunswick, Saskatchewan, Alberta, Manitoba, and BC & Yukon will receive CPD.
* Prices are in Canadian dollar (CAD). Plus any applicable taxes. CPHR member discount cannot be combined with other discounts or scholarships.
** Times based on your current timezone ()

Useful Articles

The Rise of Data Analytics in HR

The Rise of Data Analytics in HR

Learn More

Everyday Uses of Data

Everyday Uses of Data

Learn More

The Growing Impact of Data

The Growing Impact of Data

Learn More

How Big Data is Fuelling the Future of Workforce

How Big Data Is Fuelling The Future of Workforce

Learn More