Healthcare workforce analytics dashboard for tracking shifts, holiday hours, overtime, and earnings using Python, Pandas, and Streamlit.
๐ CareShift Insights
Healthcare Workforce Analytics Dashboard
๐ Transforming Healthcare Shift Data into Actionable Workforce Insights
An interactive analytics dashboard built to help healthcare organisations monitor working hours, overtime, holidays, and estimated earnings.
๐ Overview
CareShift Insights is an interactive workforce analytics dashboard that converts raw shift records into meaningful visual insights.
The dashboard enables healthcare providers and care workers to better understand workforce performance through real-time analytics and easy-to-read visualisations.
โจ Features
| Feature | Description | |----------|-------------| | ๐ Working Hours Analytics | Track total worked hours | | ๐ด Holiday Management | Monitor annual leave and holiday hours | | โฑ Overtime Analysis | Detect overtime trends and workload | | ๐ท Earnings Estimation | Calculate estimated salary based on worked hours | | ๐ Interactive Dashboard | Dynamic charts and KPI cards | | ๐ Weekly Trends | Analyse workforce activity over time | | ๐ Workforce Summary | High-level operational insights |
๐ Dashboard Workflow
Healthcare Shift Records
โ
โผ
Data Cleaning
โ
โผ
Data Processing
โ
โผ
KPI Calculations
โ
โผ
Interactive Dashboard
โ
โผ
Workforce Insights
๐ Dashboard Components
๐ Weekly Hours Trend
Monitor workload patterns across different weeks.
๐ท Earnings Dashboard
Estimate earnings using:
- Regular Hours
- Holiday Hours
- Overtime
โฑ Overtime Analysis
Identify:
- Extra working hours
- Overtime distribution
- Workload spikes
๐ Workforce KPIs
Display:
- Total Hours Worked
- Holiday Hours
- Overtime Hours
- Estimated Salary
- Average Weekly Hours
๐ป Technology Stack
| Technology | Purpose | |------------|----------| | ๐ Python | Core Programming | | ๐ผ Pandas | Data Processing | | ๐ Streamlit | Dashboard Development | | ๐ Plotly | Interactive Charts | | ๐ CSV | Data Source |
๐ Project Structure
๐ฆ CareShift-Insights
โโโ ๐ app.py โโโ ๐ requirements.txt โโโ ๐ README.md โ โโโ ๐ sample_data โ โโโ shifts.csv โ โโโ ๐ screenshots โ โโโ ๐ reports โ โโโ ๐ .streamlit โโโ config.toml
๐ธ Preview
| Dashboard | Analytics | |-----------|-----------| | (Add Dashboard Screenshot) | (Add Charts Screenshot) |
๐ Installation
Clone the repository
git clone https://github.com/tasnem-tech/careshift-insights.git
Navigate into the project
cd careshift-insights
Install dependencies
pip install -r requirements.txt
Launch the dashboard
streamlit run app.py
๐ Skills Demonstrated
- ๐ Data Analytics
- ๐ Interactive Dashboards
- ๐ Python Programming
- ๐ผ Pandas
- ๐ Business Intelligence
- ๐ Workforce Analytics
- ๐ KPI Reporting
- ๐ Data Visualisation
๐ Why This Project?
This project demonstrates how operational healthcare data can be transformed into business intelligence.
It showcases:
- โ Workforce analytics
- โ KPI dashboard development
- โ Interactive visualisation
- โ Real-world data processing
- โ Healthcare-focused reporting
๐ฎ Future Roadmap
- ๐ PDF Report Export
- ๐ฅ Multi-Employee Dashboard
- ๐ Monthly & Annual Analytics
- ๐ฐ Payroll Forecasting
- ๐ฑ Mobile Responsive Dashboard
- โ Cloud Deployment
- ๐ Secure Login System
- ๐ค AI Shift Forecasting
๐ฉโ๐ป Author
Tasnem Islam Prome
Data Analytics โข Healthcare Technology โข Python Developer
โญ If you found this project useful, consider giving it a Star!