The Continuous Performance Analytics Dashboard is a Streamlit-powered web application for tracking, analyzing, and visualizing employee performance over time.
Unlike static weekly/monthly snapshots, this dashboard lets you continuously upload performance reports (CSV files) to build a comprehensive timeline with employee journeys, team insights, and long-term rankings.
It transforms raw CSV inputs into KPIs, interactive charts, trend analyses, and heatmaps, empowering managers and teams to make informed, data-driven decisions.
-
Continuous Data Upload
- Upload CSV reports anytime to extend the timeline.
- Tracks both team-wide and individual employee histories.
-
Smart Data Cleaning & Mapping
- Flexible column recognition (works with different naming conventions).
- Fills missing values and standardizes productivity scores.
- Auto-creates unique employee identifiers.
-
Performance KPIs
-
Total, average, and role-specific metrics:
- π¬ Video Editors β Videos Created
- π¨ Designers β Designs Created
- π Account Managers β Scripts Produced, Posts Published, Client Meetings
- π₯ Filmmakers β Projects Worked
- π₯ Team Leaders β Meetings, Weekly Reviews
-
Productivity scores with performance badges (π Excellent, β¨ Good, π Average, β‘ Needs Focus).
-
-
Visual Analytics
- π Timeline Analysis β Track team size, outputs, and productivity over multiple reports.
- π€ Individual Journeys β Historical output, productivity growth, issues, and comments per employee.
- π₯ Heatmap β Compare employee productivity across all reports.
- π Long-term Rankings β Identify top performers, consistency levels, and improvement trends.
-
Insights & Feedback
- Automatic extraction of issues and suggestions from reports.
- Trend insights highlighting recent performance changes.
- Spotlight cards for top performers and team growth.
pip install streamlit pandas plotly numpy matplotlib wordcloudstreamlit run performance_dashboard.py- Upload one or more weekly CSV reports in the sidebar.
- Each new file extends the continuous timeline automatically.
Required columns (flexible naming supported):
Name,Role,Week Start Date,Week End Date- Role-specific metrics (e.g., Videos Created, Designs Created, Scripts Produced, etc.)
- π Overview β All-time KPIs and comparison of first vs latest report.
- π Timeline Analysis β Trends in output, productivity, and team growth.
- π€ Individual Journey β Employee-specific performance timelines and feedback history.
- π₯ Heatmap β Visual team-wide performance distribution.
- π Rankings β Long-term top performers and comprehensive scores.
-
Class
ContinuousPerformanceDashboardhandles:- Data cleaning & column mapping
- Timeline management (multi-file uploads)
- KPI calculations & trend metrics
- Interactive Plotly charts & heatmaps
- Individual employee history rendering
- Long-term rankings with consistency and improvement scoring
- Streamlit β Interactive UI framework
- Pandas / NumPy β Data cleaning & calculations
- Plotly β Interactive charts & visualizations
- Matplotlib + WordCloud β Word cloud generation
- Regex, Datetime β Data parsing & cleaning
- Continuous tracking of performance across multiple weeks.
- Rich employee timelines with personal improvement insights.
- Visual analytics for spotting trends and team growth.
- Ranking system for long-term recognition.
- Flexible CSV handling for real-world data variety.
- Export insights as PDF reports.
- Compare performance across multiple months/quarters.
- Integration with Google Sheets / APIs for real-time data.
- Secure user authentication for team-based access.
Designed & developed by Reda HEDDAD