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.
- Power BI
- Power Query
- Dax Query
- Data modeling
- 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
- 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.
- 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
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
