Client Overview: A marketing agency with a diverse team working on multiple projects simultaneously.
Challenge: The client had difficulty monitoring employee productivity and project timelines, leading to delayed deliverables and inefficiencies.
Solution: I created a productivity tracking spreadsheet in Excel, featuring task allocation, time tracking, and progress reporting. The spreadsheet included automated alerts for approaching deadlines and underperformance.
Results:
- Quantitative: Increased project on-time delivery rate by 30% and improved overall team productivity by 20%.
- Qualitative: Provided better visibility into team performance, fostering accountability and more efficient project management.