📊 Power BI HR Employee Analytics Dashboard

🏷️ Project Title

Employee Performance and Cost Insights Dashboard

🧠 Overview

This Power BI dashboard provides interactive visual insights into the employee management — tracking performance, efficiency, and analytics.
It complements the Excel VBA Search Automation System, transforming operational data into strategic business intelligence.

🎯 Objectives

Visualize performance trends and demographic distribution.
Track departmental performance metrics and leadership metrics.
Automate data updates from Excel (linked with VBA system).

🧩 Dataset Description

The dataset used contains columns such as:

Column Name	Description
employee_id	employee_name
city	Ndepartment
Category	Position
Quantity	Number of items available
Unit Price	Cost per item
Supplier	Vendor providing the product
Reorder Level	Threshold for restocking alerts
Date Added	Date the item entered the system

📈 Dashboard Pages & Features

1️⃣ Overview Page

employee_id, employee_name, and demographic breakdown.
9000 rows of data entries.

2️⃣ performance & Insights

Visualize performance by categories type.
Detect high-performing vs low-performing categories.

⚙️ Tools & Technologies

Microsoft Power BI
Excel (as data source)
Power Query
DAX Expressions

🧭 How to Use

Download Inventory_Dashboard.pbix.
Open it using Power BI Desktop.
Update the Excel data source path to your local file.
Click Refresh to pull new data from the VBA system.
Interact using slicers, charts, and filters.

🖼️ Embedding Screenshots & Demos

Dashboard Overview
Dashboard Overview 2

Excel VBA Inventory Automation System

👨‍💻 Author

Badawi Aminu Muhammed
Data Analyst | M & E specialist
📧 cigma.generalsolutions@gmail.com
🔗 LinkedIn

📜 License

This project is released for portfolio purposes.