Implementing Agile Task Management System: Leveraging Web Development and Power BI for Enhanced Decision-Making

Developing a Task management system can benefit organizations in several ways which offers a comprehensive solution that enhances productivity, improves collaboration, provides visibility, supports Agile practices, ensures accountability, and allows for seamless integration and scalability. This helps organizations manage their tasks and projects more efficiently, ultimately leading to better outcomes and increased success. The Agile Task Management system can be developed by combining both the front-end and back-end along with a database for storing and organizing the company project details like the status, project timeline, and project team details like their mail IDs and the particular projects they belong to. The task management web application can be developed in various languages and frameworks for managing and aggregating projects with specific employees. This research study focuses on two main areas: developing a task management web application and creating a dashboard using Power BI for in-depth analysis of the organization’s project dataset. Power BI plays a crucial role in data analytics by integrating data from multiple sources, enabling interactive exploration, and facilitating collaborative decision-making through its powerful visualization and reporting tools. The discussion includes using HTML, JavaScript, Ajax, and Bootstrap for the front end, PHP for the backend, and MySQL for the database to create a comprehensive Task Management web application. Additionally, it covers the development of a simple task management system with a Python Flask application using SQL Alchemy and PyQt5 for GUI creation with an SQLite database. Additionally, the system is designed to handle complete project-related datasets by incorporating Power BI Desktop to create interactive dashboards for visualizing project data which is a separate part of the task management system.