Innovation Owner
Mr. CHATCHAWAN KWANMUANG
Student
Details
This project develops a work tracking system using Python to integrate Excel data into SQL Server, featuring LINE notifications and Power BI reporting to enhance progress tracking and performance evaluation.
This project focuses on developing a work tracking system for team members. Python is used to extract data from Excel files and import it into a SQL Server database for systematic data management. The system includes a function to notify task status via LINE and displays reports via Power BI, allowing supervisors to track progress and evaluate team members' performance efficiently. Additionally, the system helps promote work and time management skills for team members.
Objective
The objectives are to help employees prioritize tasks, manage workloads and time more effectively, and facilitate the analysis of team performance, task volume, and task types.
- To help employees prioritize tasks more effectively.
- To help employees manage their workload more effectively.
- To help employees manage their time more effectively.
- To assist in analyzing team performance, including the volume and types of tasks performed.