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 & Data

  • 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 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 The Full Curriculum

    First Name*

    Email Address*

    Company Name*

    Title*

    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.

Instructors

These data professionals bring years of experience and passion for mentorship into our classroom.

  • coding bootcamp Instructor
    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.
  • coding bootcamp Instructor
    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.

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

Apr 28 - May 07

Jul 21 - Jul 30

Oct 06 - Oct 15

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