Creating an HR Analytics Dashboard in Power BI: A Step-by-Step Guide

            Introduction

Welcome to this step-by-step guide on building an HR Analytics Dashboard in Power BI. In this tutorial, we’ll walk through the entire process of designing an interactive dashboard that visualizes key HR metrics such as job satisfaction, attrition rates, and employee demographics.

If you haven’t already, check out the first part of this video (linked in the description) where we covered the initial setup, KPIs, and basic charts. This blog post continues from where we left off, focusing on refining the dashboard with heat maps, bar charts, donut charts, and interactive filters.

---

Step 1: Designing the Job Satisfaction Heat Map

Our first task is to visualize job satisfaction ratings across different job roles using a heat map.

How to Build the Heat Map:

1. Select a Matrix Chart

   • Go to the Visualizations pane and choose the Matrix chart.

   • Place it on the dashboard canvas and adjust its size.

2. Configure Rows, Columns, and Values

   • Rows: Drag Job Role into the Rows field.

   • Columns: Drag Job Satisfaction (rating from 1 to 4, where 4 is the highest).

   • Values: Use Sum of Employee Count to display the number of employees in each category.

3. Formatting the Heat Map

   • Title: Rename it to "Job Satisfaction by Role" and center-align it.

   • Font: Use Segoe UI Semi-Bold for readability.

   • Background: Apply a dark background with 75% transparency.

   • Grid Lines: Enable horizontal and vertical grid lines in dark gray for better readability.

   • Color Scheme: Customize the heat map colors:

     • Lowest value (1): Light blue (#F4F4C3)

     • Highest value (4): Dark green (#3D8207)

4. Final Adjustments

   • Adjust column width to eliminate scroll bars.

   • Disable row subtotals and keep only column subtotals for a cleaner look.

---

Step 2: Creating the Field-Wise Attrition Bar Chart

Next, we’ll visualize attrition rates by education field using a bar chart.

How to Build the Bar Chart:

1. Select a Bar Chart

   • From the Visualizations pane, choose the Clustered Bar Chart.

2. Configure Axes

   • Y-Axis: Drag Education Field.

   • X-Axis: Use Attrition Count (or rate, depending on data).

3. Formatting the Bar Chart

   • Title: Rename it to "Attrition by Education Field".

   • Bar Color: Use a custom color (#8E8EF9 for better contrast).

   • Data Labels: Enable and set to white for visibility.

   • Axis Titles:

     • Y-Axis: Semi-bold, dark gray.

     • X-Axis: Disable (since data labels are visible).

4. Resizing

   • Set width to 345px and height to 235px for optimal fit.

---

Step 3: Designing Donut Charts for Age-Based Attrition

We’ll now create donut charts to show attrition rates by gender across different age groups.

How to Build the Donut Charts:

1. Select a Donut Chart

   • Place it on the canvas and resize it to fit multiple charts.

2. Configure Data Fields

   • Legend: Drag Gender.

   • Values: Use Attrition Count.

   • Details: Drag Age Band (to filter by age group).

3. Filtering Each Donut Chart

   • Apply a filter for each age group (e.g., Under 25, 25-34, etc.).

   • Repeat for all five age bands.

4. Formatting the Donut Charts

   • Title: Label each chart by age group (e.g., "Under 25").

   • Rotation: Adjust slice rotation (e.g., 30°–90°) to prevent label overlap.

   • Colors:

     • Female: Light purple (#F4F4C3).

     • Male: Dark blue (#091E0).

   • Background: Match the dashboard theme (75% transparency).

5. Adding KPIs for Each Age Group

   • Insert a card visual next to each donut chart showing total attrition count.

   • Filter each card by the corresponding age band.

---

Step 4: Adding Interactive Filters

To make the dashboard dynamic, we’ll add slicers and configure cross-filtering.

How to Add a Slicer:

1. Insert a Slicer

   • Choose Education Field as the slicer.

   • Set it to horizontal layout for compact display.

2. Formatting the Slicer

   • Disable the slicer header.

   • Apply a dark background with semi-bold white text.

Configuring Cross-Filtering:

• For Pie/Donut Charts:

  • Go to Format > Edit Interactions.

  • Set to Filter (not Highlight) to ensure data updates dynamically.

• For Bar/Heat Maps:

  • Enable filtering when clicking other visuals.

  • Block unwanted interactions where necessary.

---

Step 5: Final Dashboard Touches

1. Dashboard Title

   • Add a text box with "HR Analytics Dashboard" in bold white text.

   • Use a dark background (#1A1A1A) for contrast.

2. Alignment & Spacing

   • Ensure all visuals are evenly spaced.

   • Adjust widths to maintain consistency (e.g., 179px for donut charts).

3. Testing Interactivity

   • Click on different filters/slicers to ensure all visuals update correctly.

---

Conclusion

Congratulations! You’ve successfully built an interactive HR Analytics Dashboard in Power BI. This dashboard provides insights into:
✔ Job satisfaction trends
✔ Attrition rates by education and age
✔ Gender-based attrition patterns

By following these steps, you’ve learned how to:

• Design heat maps, bar charts, and donut charts.

• Apply consistent formatting for a professional look.

• Implement interactive filters for dynamic analysis.

For more Power BI tutorials, like, subscribe, and share this guide! 🚀

Happy analyzing! 📊

New chat