Employee Metrics Dashboard is a data-driven solution designed to streamline employee performance management using SQL, Metabase, and Streamlit. It provides actionable insights through interactive dashboards and analytics.
Efficient employee performance management is essential for healthcare facilities to maintain service quality and optimize resources. The Employee Metrics Dashboard was developed to equip clinic managers with real-time insights into staff performance while simplifying the process of setting and managing performance goals.
This project addresses key challenges such as:
🔍 Monitoring employee performance through various metrics
📅 Setting and tracking target hours on a weekly, monthly, and yearly basis
📊 Enhancing data visualization and analysis for better decision-making
An interactive dashboard for tracking employee performance with key features:
- 📍 Real-time performance monitoring by location, manager, and staff
- 📈 Aggregated metrics (actual vs. target hours)
- 🎛️ Interactive filters for customized analysis
A tool to efficiently set performance targets with:
- 📅 Cloning target hours from the previous year
- 🎯 Adjustable daily target hours (4–7 per employee)
- 📤 Exporting targets for seamless dashboard integration
✅ Metabase – Dashboard & data visualization
✅ Streamlit – Target generator tool
✅ PostgreSQL – Database storage
✅ Python – Data processing & automation
- 👨💻 Huan LV – Project Lead
- 🛠 Anthony Nguyen & Divyanshu Fialok – Target Generator Development / Bug Fixes
- 📊 Dawn Dang & Andy Nguyen – Dashboard Development / Design
📖 For setup and usage, visit the Documentation folder.