Video course · 7 chapters · 36 min · certificate
Build an HR Training Dashboard in Power BI from Scratch
Sudhir's step-by-step build of an HR training and learning tracker dashboard in Power BI: preparing employee and training data, Power Query clean-up, relationships, DAX measures and KPI cards, department and top-course charts, tables with sparklines, a trend line, slicers and a reset bookmark.
What you'll learn
- Prepare HR training data for Power BI
- Clean data types in Power Query
- Model relationships between employee and training tables
- Write DAX measures for totals, completion rate and averages
- Build cards, charts, tables and sparklines
- Add slicers, filters and a reset bookmark
Chapters
7 chapters · 35:44-
2:22
01Data Members
Dataset overview and preparation
Four tables.
-
2:21
02Power Query Members
Import data and Power Query
Load and fix types.
-
1:34
03Model Members
Data modeling and relationships
Connect the tables.
-
8:59
04DAX Members
Dashboard layout and DAX measures
KPI cards.
-
7:11
05Charts Members
Department charts and donut
Compare and rank.
-
7:32
06Detail Members
Tables and line chart
Drill into people.
-
5:45
07Interactivity Members
Slicers, filters and bookmarks
Filter and reset.
Jobs this course suits
Our AI checked this course against 500 jobs; these get the most out of it. Each job links to its learning path.