arrow_back
Module 1: Introduction & Setup
Overview of HR Training KPI dashboards.
Installing & setting up Power BI Desktop.
Understanding the sample HR Training KPI data file.
Module 2: Quick Data Import
Direct copy-paste of semi-structured Excel data into Power BI.
Why direct copy is chosen over structured connections.
Handling irregularities in HR training data.
Module 3: Data Transformation in Power Query
Changing data types (date, text, numeric).
Adding new calculated columns.
Removing unnecessary columns/rows.
Renaming fields for clarity.
Module 4: KPI Creation
Defining key HR training KPIs (training hours, completion rates, cost per employee, etc.).
Creating new measures from existing columns.
Best practices for KPI naming & formatting.
Module 5: Dashboard Design & Layout
Selecting visuals for KPI display.
Adding slicers/filters for interactivity.
Importing background images for a professional look.
Using themes & colors for HR-friendly dashboards.
Module 6: Final Touches & Publishing
Reviewing and validating dashboard calculations.
Enhancing usability for end users.
Exporting and sharing the HR KPI dashboard.
Self-Check Project
Create a working dashboard on the problem statement given by your instructor.