HR Analytics in Power BI

Name: HR Analytics in Power BI
Rating: 3.9 (638 reviews)

Connecting and Visualizing Human Resources Data Using Power BI

Created bySarah Kithaka

Last updated 2/2021

English

What you'll learn

Aggregate and combine Human Resources data in Power BI
Connect transactional data in Power BI
Build relationship between related data sources in power BI
Create comprehensive reports and interactive dashboard with Power BI
Create a wide range of visualization by just dragging and clicking

Course content

4 sections • 8 lectures • 56m total length

Introduction1:29
Learn to connect, import, transform, and visualize HR data in Power BI through practical exercises using sample datasets, building relationships and interactive dashboards with drag-and-drop visualizations.
Introduction to Power BI3:17
Discover how Power BI's suite of business analytics delivers insights and visualization by connecting to data sources, transforming data into a data model, and building shareable HR dashboards.
Quiz

HR Data Structures14:37
Learn how to aggregate and model transactional human resources data from multiple systems in Power BI, using HRIS extracts and absenteeism examples to enable automated analysis and adhoc reporting.
Connecting Transactional Data6:25
Connect transactional data in Power BI for HR analytics by linking HRIS and employee attrition data. Build reports on marital status by department and attrition by marital status.
Structuring and Modelling Human Resource Data10:04
Build an HR data model in Power BI by importing Excel tables, creating date components, categorizing geo data, and establishing relationships across absence, calendar, HRM, and geo datasets.
Quiz

Building Human Resources Dashboard in Power BI16:34
Learn to build an interactive human resources dashboard in Power BI, integrating data sources, defining metrics, and visualizing workforce insights with charts, slicers, and filters.
Power BI Bookmarks and Tooltip3:53
Explore creating and using bookmarks to quickly filter by gender and navigate dashboards, then customize an interactive tooltip to display department and employee counts for deeper insights.
Quiz

Requirements

No prior knowledge on the subject matter is required

Description

If you are new to power BI, this course is for you. The focus of this course is to provide you with simple guide on how to import, connect and visualize Human Resources data in power BI . This course takes a practical perspective so that you can learn and practice at the same time using datasets dummy datasets. The course provides you with the fundamentals you need to work with power BI effectively. You will understand the flow of using power BI, from connecting to various data sources, importing these to power BI, transforming the data and then presenting it effectively. Power BI is a suit of business analytics tools that delivers insights, data processing and data visualization.

Why Power BI?

Power BI gives you real time visibility into your data allowing you to generate greater insights into your Human Resources Key Performance indicators. You build dashboards that are easy to adopt and use.

What you will learn;

Learn how to aggregate and combine Human resources data in power BI
Learn how to Connect transactional data in Power BI
Learn how to build relationships between related data sources in power BI
Learn how create comprehensive reports and interactive dashboards with Power BI
Lean to easily create a wide range of visualization by just dragging and dropping

In this course, dummy datasets have been provided to enable you learn and practice

Who this course is for:

Huma Resource professionals who want to learn how to create reports and interactive dashboard in Power BI

HR Analytics in Power BI

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 5min

Connecting Human Resources Data Using Power BI3 lectures • 31min

Visualizing Human Resource Data in Power BI2 lectures • 20min

Wrap up1 lecture • 1min

Requirements

Description

Who this course is for: