Outsourcing Dashboard

Managing workforce data for 950 outsourcing employees

📌 Project Overview

Developed a centralized dashboard to manage and monitor outsourcing workforce data, enabling efficient tracking of 950 employees across multiple functions and operational areas.

🎯 Objective

Centralize outsourcing workforce data
Monitor employee distribution across functions
Track workforce status and allocation
Improve operational visibility

🛠 Tools & Technologies

Google Sheets Apps Script Dashboard Data Management

📊 Dataset

Employee name & ID
Vendor / outsourcing provider
Function & department
Work location / area
Employment status
Shift / working schedule

⚙️ Process

Collected workforce data from multiple sources
Structured dataset in Google Sheets
Automated data updates using Apps Script
Built dashboard for workforce monitoring
Created filters for vendor, function, and location

🚀 Business Impact

Improved visibility of 950 outsourcing employees
Reduced manual workforce tracking effort
Enabled faster workforce allocation decisions
Enhanced operational efficiency and reporting