Skip to content

README.md

Latest commit

 

History

History
143 lines (90 loc) · 4.37 KB

README.md

File metadata and controls

143 lines (90 loc) · 4.37 KB

🚀 Continuous Performance Analytics Dashboard

📊 Overview

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.

✨ Key Features

  • 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.

🖥️ Getting Started

Install Dependencies

pip install streamlit pandas plotly numpy matplotlib wordcloud

Run the App

streamlit run performance_dashboard.py

Upload Data

  • 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.)

📂 Views Available

  • 📊 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.

⚙️ Under the Hood

  • Class ContinuousPerformanceDashboard handles:

    • 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

🛠️ Technologies

  • Streamlit – Interactive UI framework
  • Pandas / NumPy – Data cleaning & calculations
  • Plotly – Interactive charts & visualizations
  • Matplotlib + WordCloud – Word cloud generation
  • Regex, Datetime – Data parsing & cleaning

🚀 Benefits

  • 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.

📌 Future Roadmap

  • 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.

🔗 Live Demo

DEMO

👨‍💻 Credits

Designed & developed by Reda HEDDAD