IT and Computing > HR analytics Dashboard using Power BI

HR analytics Dashboard using Power BI

Course Objectives

User has an intermediate knowledge of Microsoft Excel and Database concept

Target Audience

HR Administrators
HR Executives
HR Managers

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.

Course Modules

Module 1: Introduction to HR Analytics

Overview of HR Analytics
Definition and importance
Key metrics and KPIs in HR
Introduction to Power BI
What is Power BI?
Key features and benefits

Module 2: Getting Started with Power BI

Power BI Interface and Navigation
Understanding the workspace
Key components: Reports, Dashboards, Datasets
Connecting to Data Sources
Importing data from various sources (Excel, CSV, Text)
Data transformation and cleaning

Module 3: Data Modeling and Relationships

Creating Data Models
Understanding tables and relationships
Creating and managing relationships
Introduction to Data Analysis Expressions (DAX)
Common DAX functions for HR analytics

Module 4: Building HR Analytics Dashboards

Designing Effective Dashboards
Best practices for dashboard design
Choosing the right visuals for HR data
Creating Visualizations
Bar charts, line charts, pie charts, and more
Using slicers and filters for interactive dashboards

Module 5: Advanced Analytics and Custom Visuals

Time intelligence functions
Calculated columns and measures
Custom Visuals and Power BI Marketplace

Module 6: Sharing and Collaboration

Publishing and Sharing Dashboards
Publishing to Power BI Service
Sharing dashboards
Collaboration Features
Power BI workspaces

Module 7: Case Studies and Hands-On Projects

Employee Overview
Employee Leaves Tracking
Employee Transactions
Recruitment Analysis
Payroll Analysis
Learning Development Analysis

Get To Know The Trainer

Trainer Lim

Lim has been working in the IT industry for the past 20 years. He leads, plans and supports a functionally organized, technically oriented team and environment with a wide variety of technical activities and service operations.He is good in developing and implementing IT initiatives for regional service operation activities and actively participates in global projects to align corporate/regional direction and IT standard according to ITIL operational framework and software development.

VIEW PROFILE

Trainer CK

4.5

CK has been involved in Microsoft Office Consulting for more than 15 years with the intention of helping friends and working adults to reach their full capability which in return will increase their work productivity. Throughout his many years of working experience using Microsoft Office Applications, he participated with various projects involving Engineering Data Analysis, A Complete System for Employees such as Leave Application, Petty Cash Claim, Arranging Schedule and so on with Programming using VBA Programming.

VIEW PROFILE

Trainer P.L

4.5

She is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.

VIEW PROFILE

View more trainers