Our user interface is designed for clarity and ease of use, integrating interactive Power BI dashboards within Power Apps to help project managers track workload distribution effortlessly. With structured layouts, real-time data updates, and intuitive filtering, users can quickly identify productivity trends and workload imbalances.

Based on feedback from Chanel’s Creative Department, we refined the interface to enhance usability, ensuring seamless navigation and tablet accessibility for on-the-go insights.

Overall, we rate our UI/UX as Very Good.

Our solution successfully automates report generation by extracting tasks and projects data from Chanel’s Microsoft project management software using Power Automate. This data is processed and visualized in Power BI, generating interactive dashboards embedded within Power Apps.

Functionally, the system provides real-time insights into workload distribution, productivity trends, and resource allocation, allowing project managers to make data-driven decisions with minimal manual effort.

Overall, we rate our Functionality as Very Good.

Stability was a key consideration in our development process. By leveraging Power Automate and Power BI’s robust infrastructure, we ensured that data extraction, processing, and visualization ran smoothly with minimal downtime. We implemented error handling for data retrieval failures and optimized report generation to prevent performance bottlenecks.

However, occasional delays can occur when syncing large datasets. Moving forward, we aim to refine data processing efficiency and improve scalability to support a broader range of teams.

Overall, we rate our Stability as Good.

We optimized the data extraction and processing steps using Power Automate, ensuring minimal delays in gathering and visualizing data. By leveraging Power BI's built-in performance features, we were able to deliver fast-loading and interactive dashboards.

However, as the number of tasks in Microsoft Planner increases, the efficiency of our Power Automate flows can be impacted, leading to longer processing times for data extraction. This is not a huge issue as we have advised Chanel to only refresh data during non-working hours when nobody is viewing their dashboard.

Overall, we rate our Efficiency as Good.

Our system is fully compatible with any browser and operating system, allowing users to access it online from various devices. To enhance accessibility further, we are considering publishing the app within Microsoft Teams, enabling easier and more seamless access for users within Chanel's Creative Department.

This integration would streamline the user experience and provide a centralized platform for project managers to monitor and manage task data more efficiently.

Overall, we rate our Compatibility as Very Good.

Our system is designed with maintainability in mind, with each component of the solution, such as the Power Automate flows and Power BI dashboards, clearly modularized. This approach makes it easier to identify and resolve any issues that arise without affecting the overall functionality.

We have provided detailed documentation that outlines the step-by-step process for rebuilding the system. This documentation enables Chanel's team to replicate the solution within their own ecosystem. This approach makes it easier to maintain and adapt the platform over time while ensuring smooth transitions for ongoing support.

Overall, we rate our Maintainability as Very Good.

We used a combination of tools to keep the team aligned and ensure efficient progress. Each week, we organized tasks in an Excel sheet, which helped us stay on top of what needed to be done. Weekly meetings allowed us to share updates and assign new tasks, while a Gantt chart helped manage our timeline.

Despite the delays in getting access to our Power BI license, we successfully developed the dashboard without setbacks, ensuring all features and functionalities were fully implemented as planned.

Overall, we rate our Project Management as Good.