People Analytics Course

About This Class

In today’s data-driven world, HR Managers need to be able to effectively use data to make informed decisions and drive innovation. This People Analytics Course is a comprehensive and industry-relevant training course that equips HR Managers with the skills and knowledge they need to succeed in this new era of business. Drive data-driven decision-making and transform your business with people data analytics skill.

Critical points to be addressed during the course:
Definition, description and overarching goal of People Analytics
Identify and analyse the problem to be solved and the insights needed from the data
Refine the problem to be solved into actionable and measurable subsections
Explore the best practices of data gathering and data cleanup
Focus on visualizing and presenting the data to drive efficient decision-making
Strong focus on practical application during the entire course
Foster a culture of interrogating the data, questioning the results, and critical engagement with the outcomes

Local Fee

R 17,999

International Fee

$ 1,300

DAY 1 (Excel-based)

▪ Cleaning of data

▪ Information functions and Text functions

▪ Data validation and protection

▪ Logical functions (including nested IF statements)

▪ Maths functions (including SUMIF and SUBTOTAL)

▪ Date and time functions

▪ Useful tools and shortcuts

▪ Formula auditing and evaluating formulas

DAY 2 (Excel-based)

▪ Table Tools and Pivot Tables

▪ Dynamic Input Ranges

▪ Timelines and Slicers

▪ Functions in Array Calculations

▪ Lookup Functions

▪ Dynamic Array Functions

▪ Array Text Functions (such as TEXTJOIN, TEXTSPLIT, etc.)

DAY 3 (Power BI)

▪ Business Intelligence Workflow

▪ Business Intelligence Reports

▪ Cleaning and Manipulation of Raw Data

▪ Analysis of Data from Different Data Sources

▪ Establish Relationships between Data

▪ Interactive Dashboards

▪ Graphs and Data Visualisation

▪ Best Practice Tips for Power BI

The focus is on time-savers and other techniques which will improve the quality of your models. Each delegate must bring their own laptop.

Who should attend

▪ HR Professionals seeking to enhance their skills

▪ Mid-level Managers transitioning into HR roles

▪ Senior HR Managers aiming for executive positions

▪ Executives tasked with managing HR departments or HR function

▪ Any HR Consultant looking to update their knowledge base

Expert Trainer

The trainer for this course is a Chartered Accountant (SA), Associate Chartered Management Accountant, Chartered Global Management Accountant, with strong academic and industry experience. She holds a Master’s degree in Management Accounting and has more than nine years of lecturing experience at the University of Pretoria and North-West University respectively, for which she has received distinctive teaching awards.

As a lecturer, she specialised in Management Accounting, Costing, Financial Management and Business Strategy to students of various levels. This is besides providing business simulations, supervising research projects and external moderation and reviewing of other universities’ exam papers and study guides.

She has been delivering training to both government institutions and private sector companies in similar subject areas, including Microsoft Excel, financial and business skills training, as well as consultation in fields related to financial modelling in Excel, optimising power tools in Excel and Power BI.

Recommended Courses

Supply Chain Analytics

This 3 day course will equip finance/supply chain managers and analysts in a variety of industries with the skills to make data-driven decisions.

Advanced Data Analytics Course

In today’s data-driven world, managers need to be able to effectively use data to make informed decisions and drive innovation.

Marketing Analytics Course

This 3 day course will equip marketing managers and analysts in a variety of industries with the skills to make data-driven decisions.