Project Abstract
Within a large organisation like Chanel, there are significant challenges in tracking and assessing their most valuable resource — their employees. At present, there is no software available that can automatically quantify the volume of work completed or received, making it difficult to measure contributions and collaboration. This lack of visibility also makes it challenging to identify workload imbalances and optimize human capital effectively.
Our solution is an Automated Report Generating System, designed specifically to leverage Chanel’s existing data on tasks and projects. This software automates generation of detailed reports, providing both team-wide and individual insights in real-time. By analysing key data points and producing visual summaries, it offers a comprehensive overview of the contributions at various levels within the organisation. The key advantage of this solution is its ability to eliminate the need for time-consuming manual effort in tracking and compiling data.
Our software allows leaders to make informed and strategic decisions on resource allocation and task prioritisation. By having instant access to data on who is working on what and how efficiently tasks are being completed, decision-makers can better balance workloads and identify potential bottlenecks. This empowers the team to maintain a high level of creativity and productivity, while also reducing the administrative burden associated with manual tracking.
Tools
Our solution leverages these four Microsoft tools to bring this vision to life.

Microsoft Power Automate
Extracts data from Chanel's existing Microsoft Planner and stores them into SharePoint List

SharePoint Lists
A database that stores task data pulled from Microsoft Planner

Microsoft Power BI
Generates reports dashboards (various charts and graphs) from data stored in SharePoint List

Microsoft Power Apps
The user interface, allowing users to interact with team and individual reports.
Video
Project Timeline
We created a gantt chart to track our project development
Meet The Team
Polina Fedchenko
Team LeadSecond year CS student at UCL

Santtosh Sivaram
Team MemberSecond year CS student at UCL

Felicia Ong
Team MemberSecond year CS student at UCL

Grace Lee Sue Ern
Team MemberSecond year CS student at UCL


