Overview
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 skills.
Critical Points to be Addressed
- 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 critically engaging with the outcomes
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
Note: The focus is on time-saving techniques and methods to enhance the quality of your models. Each delegate is required to bring their laptop.
This Course Will Benefit:
- 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 functions
- Any HR Consultant looking to update their knowledge base
Our values are member centricity, integrity and advocacy.
The Institute of People Management (IPM)