Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byJuliet Rodrigues

Last updated 5/2026

English

What you'll learn

Understand Power BI's role in data-driven HR decision-making
Install, configure and navigate Power BI Desktop with confidence
Clean and transform messy HR data using Power Query Editor
Build data models by creating relationships between HR tables
Learn how to use Text Boxes, Shapes, Images, maps, and other visuals.
How to turn data into insight and data into interactive visualizations to tell a story
Learn Dashboard-in-a-day at your own pace at home, office or from anywhere
Hands on course will prepare you to start your data analytics career from scratch
Create charts using visuals like column, line, pie, combo, Scatter, Treemap, Funnel, Gauges and KPIs and many more

Course content

9 sections • 105 lectures • 7h 58m total length

Introduction5:32
This module establishes the strategic case for Power BI in HR. Learners begin with a clear understanding of what Power BI is and how its features — including real-time data integration, AI and machine learning visuals, and automated reporting — directly address the data challenges HR professionals face every day. The Module introduces the key HR metrics Power BI can track: recruitment funnel efficiency, employee turnover and retention, performance KPIs, and compensation equity.
HR Key Metrics6:02

Introduction to Power Query Editor3:25
Data Transformation in Power Query Editor2:23
Remove Top Row in Power Query Editor1:31
Move The Second Row to First Row as Header2:21
Renaming the Column Heading1:28
Remove Duplicates0:38
Deleting Columns1:22
Replace Values2:21
Replace Null Values1:52
Remove Special Characters1:37
Remove Duplicates1:20
Trim Spaces and Capitalized2:06
Merged Two Columns2:37
Transform Null Not Assigned Values2:07
Remove Decimals0:56
Conditional Format Salary3:39
Creating Age and Age Slab Columns3:51
Calculating Tenure in Organization3:15
Changing Data Type7:16
Combine Two Tables2:14
Append Queries7:02
Merge Queries7:58

Introduction to Visuals2:24
Creating Clustered Column10:15
Creating and Formatting Line Chart6:11
Creating and Formatting Stacked Column4:39
Creating and Formatting Stacked Bar5:27
Creating 100 Stacked Bar Chart6:15
Creating and Formatting Area Chart4:44
Creating and Formatting Stacked Area Chart5:41
Creating and Formatting 100 Stacked Area Chart0:55
Creating and Formatting Line and Stacked Area Chart9:13
Introduction to Pie and Donut Chart1:12
Creating and Formatting Pie Chart6:38
Creating and Formatting Donut Chart3:57
Creating and Formatting Clustered Bar Chart5:01
Creating and Formatting Table Visual9:21
Creating and Formatting Matrix or Heat Maps4:31
Creating and Formatting Tree Map3:40
Creating and Formatting Visual Card or KPI Card3:03
Creating and Formatting Slicers2:41

Introduction to Data Modeling and Relationship1:39
What is Data Medeling2:06
Understanding Fact Table1:02
Compare Fact and Dimension Table1:03
What is Schema1:34
What is Star Schema4:14
Understanding Primary Key1:24
Understanding Foreign Key1:27
Connecting Dataset or Sheets1:19
Examples of Fact, Dimension Table and Primary and Foreign Key8:28
Understanding Snow Flakes7:29
Difference Between Snow and Star Flakes1:17
Understanding Galaxy Schema2:46
What is Relationship Model1:51
3 Different Methods in Relationship Model0:25
Method 1 - Automatic Detection4:23
Method 2 - Drag and Drop2:40
Method 3 - Manage Relationship Dialog Box2:56
Anatomy of Relationship5:08
Understand Cardinality2:29
Cardinality - One to Many4:02
Cardinality - Many to One1:49
Cardinality - One to One2:52
Cardinality - Many to Many2:00
Identify Cardinality2:12

Introduction - DAX1:35
Need of DAX in HR Dashboards5:43
3 types of DAX0:26
Type 1 - Calculated Columns3:00
Type 2 - DAX Measures5:45
Type 3 - Calculated Tables3:38
Differ Between DAX Measures, Calculated Columns and Calculated Tables3:45
DAX Syntax Basics2:25
DAX Measures for HR1:38
DAX Measure to Calculated Total Employees3:17
Total Active Employees DAX Measure3:10
Total Inactive Employee DAX Measure1:26
Distinct Department Count DAX Measure2:35
Distinct Count Manager or HOD DAX Measure2:51
Total Payroll6:21
Average Mean Salary2:35
Demography Male and Female Measure4:17
Min and Max Salary DAX Measure5:55
Average Salary By Department Measure6:36
Calculate Total Tenure Measure4:01
Tenure In Months Dax Measure1:43

Requirements

No prior Power BI experience required — the course starts from absolute zero
A Windows PC or laptop (Power BI Desktop is a free, Windows-only application)
Basic familiarity with Excel is helpful but not required
HR experience or an interest in people analytics is an advantage

Description

Full Course Description

Module 1: Power BI for HR

Learn why HR needs Power BI — track recruitment, attrition, performance & compensation with real-time, automated dashboards. No tech skills needed.

Module 2: Installing Power BI

Step-by-step guide to downloading, installing & launching Power BI Desktop. Covers system requirements & first-time setup for HR professionals.

Module 3: Interface of Power BI

Navigate Power BI's Left, Right & Top panels. Master Report, Table, Model & DAX views to build, format & manage interactive HR dashboards confidently.

Module 4: Uploading Data in Power BI

Connect HR data from Excel, SQL & HRMS platforms. Clean duplicates, fix missing values & build relationships between Employee, Payroll & Attendance tables.

Module 5: Data Transformation & Power Query

Clean messy HR data — remove duplicates, fix nulls, build salary slabs, age bands & tenure buckets. Merge payroll tables & prep perfect data for dashboards.

Module 6: Data Modelling & Relationships

Connect HR tables accurately using One-to-Many, One-to-One & Many-to-Many relationships. Master cardinality, cross-filter direction & active vs inactive relationships.

Module 7: Advanced DAX for HR Analytics

Write 20 essential HR DAX measures — headcount, attrition rate, average salary, tenure, gender diversity & time intelligence. Built exclusively for HR data.

Module 8: Core Power BI Visuals & HR Use Cases

Master 16 Power BI visuals — column, line, donut, funnel, scatter, waterfall & decomposition tree — all mapped to real HR reporting scenarios and dashboards.

Module 9: Employee Master Dashboard

Build a full HR Analytics Dashboard for PharmaCorp — 8 KPI cards, 10 visuals, DAX measures & a Predictive Attrition Risk Model scoring every employee High, Medium or Low.

Insights and Recommendations

Extract 15 HR insights & 10 strategic recommendations from your dashboard. Build a Priority Action Matrix & present findings confidently to senior HR leadership.

Who this course is for:

HR Fresher / Trainees
HR Analytics
HR Manager or HRBP
HR Head, CHRO

What you'll learn

Explore related topics

Course content

Module 1 - Introduction2 lectures • 12min

Module 2 - Download and install Power Bi1 lecture • 1min

Module 3 - Uploading Dataset in Power Bi1 lecture • 3min

Module 4 - Navigating through Power Bi panels4 lectures • 26min

Module 5 - Data Transformation & Query in Power BI22 lectures • 1hr 3min

Module 6 - Core 16 Power BI Visuals & HR Use Cases19 lectures • 1hr 36min

Data Modeling and Relationships in Power BI25 lectures • 1hr 9min

20 DAX for HR Analytics21 lectures • 1hr 13min

Building Employee Master Dashboard from Scratch10 lectures • 2hr 16min

Requirements

Description

Who this course is for: