The HR Analytics Dashboard is an interactive data analytics solution designed to help HR teams, managers, and decision-makers understand workforce data quickly and effectively.
Instead of working with large spreadsheets or raw datasets, the dashboard transforms employee data into clear metrics and visual insights, all presented in a single, easy-to-read interface.
The dashboard focuses on key HR indicators such as employee count, attrition, performance, income, and tenure, enabling faster and more informed decision-making.
HR departments often deal with complex and high-volume workforce data. This dashboard simplifies analysis by:
- Converting raw employee data into meaningful, actionable insights
- Highlighting potential risk areas, such as high attrition
- Supporting strategic HR and management decisions
- Saving time by presenting all key metrics in one unified view
The dashboard is intentionally designed to be accessible for non-technical users, including managers and executives.
A quick snapshot of overall workforce health, including employee count, attrition rate, average income, and performance.
Visual insights showing how employees are distributed across departments, attrition patterns, and performance ratings.
Trends related to employee income and tenure, supporting analysis of retention and compensation structure.
flowchart LR
D[HR Dataset / Database]
A[Data Processing Layer]
S[Streamlit Dashboard]
U[HR Users & Managers]
D --> A
A --> S
S --> U
The dashboard supports basic HR operations directly from the interface:
- HR staff can add new employee information through the dashboard.
- Existing employee salaries can be updated easily.
All changes are:
- Saved permanently
- Reflected immediately in the dashboard visuals
Employee data is stored in a local database file, ensuring that:
- Data persists after the application is closed
- Newly added employees remain saved
- Salary updates are preserved
Each time the dashboard runs, it loads the most up-to-date version of the data.
This dashboard is suitable for:
- HR teams
- Department managers
- Business stakeholders
- Executives seeking high-level workforce insights
It is built with a strong focus on clarity, speed, and practical usability.
The dashboard follows professional analytics and business design standards:
- One-page layout for clear visibility
- Clean, minimal visuals focused on insights
- Soft background colors with white content sections
- Color palette aligned with Solutions by STC branding
Design principle: clarity over complexity.
The project consists of two main components:
- Jupyter Notebook used for data exploration, cleaning, and analysis.
- Python-based application that displays interactive visualizations and metrics.
- Python
- SQL
- Data analysis and processing
- Local database storage
- Interactive web-based dashboard using Streamlit
All required libraries and their exact versions are listed in the requirements.txt file.
To ensure compatibility and reproducibility, please install dependencies using:
pip install -r requirements.txt- Activate your Python environment
- Navigate to the project directory
- Install required dependencies:
pip install -r requirements.txt
- Run the dashboard:
streamlit run app.py
- Open the dashboard in your browse
http://localhost:8501
The HR Analytics Dashboard transforms employee data into clear and actionable insights. It helps organizations to:
- Understand workforce dynamics more effectively
- Identify potential risks early
- Support informed HR and business decisions
- Access all key HR metrics in one centralized interface