arrow_back
Module 1: Introduction & Setup
An Overview of the Business Requirement
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
Understand the Dashboard KPI's and Analysis
Understand Power-BI Interface and Dashboard Layout
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
Data Transformation in Power Query Editor
Changing data types (date, text, numeric).
Adding new calculated columns.
Removing unnecessary columns/rows.
Renaming fields for clarity.
Module 4: KPI Creation
Import the Data and Begin to Build the Dashboard
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
Create Calculations and Data Validation
Design Bar and Line Chart with KPI's. Understand Filters for Visual Components
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.