HR Analytics Dashboard

This project demonstrates the application of Power Query and DAX Query to analyze employee information, create new measures and columns, and build a dynamic dashboard using Power BI. The main objective is to extract valuable insights from this data, enabling data-driven decisions to optimize HR strategies, boost employee satisfaction, and minimize attrition.

Tools Used

• Power BI
• Power Query
• Dax Query
• Data modeling

Cleaning and Analyzing Data using Power Query

• Open Excel and connect to your employee information.
• Use Power Query to clean and transform the data
• Apply all necessary cleaning steps, such as removing duplicates, renaming columns, and changing data types
• Load and Apply the cleaned data into Power BI

Exploring and Manipulate Some Data Using DAX Query

• Leveraging DAX Query, we can effectively manipulate and analyze our data, extracting valuable insights for visualization and decision-making in HR.
• By creating custom measures using DAX functions, such as COUNT, SUM, CALCULATE, we enhance the quality of our data for improved Power BI dashboards, facilitating the identification of areas for HR strategy improvement and KPI enhancement.

Power BI Dashboard Visualization

• Design the dashboard layout
• Create a measure table to aggregate and display the data using Dax functions
• Use Visulizations for charts and slicers for filter dashboard
• Now, Add Title HR Dashboard
• Add Education column as Slicer and add some informative KPI.
• Add Card chart, Pie chart, Donut chart, Matrix chart, Bar chart, Column Chart etc

Power BI Dashboard

This is an interactive Power BI Dashboard , you can interact with this dashboard from https://www.novypro.com/project/hr-analytics-dashboard-power-bi-24