Client Background

Our client, a leading IT Products and Solutions Provider from Canada are specialists in cutting-edge IT software. They approached us with a visionary project of developing a Proposal Tracker Tool. This tool was aimed to revolutionise proposal management, showcasing the client’s commitment to innovation. They planned to deploy it across various O365 tenants, transforming it into a versatile product accessible to users across domains. This move emphasised their dedication to adaptability and scalability, positioning them as industry leaders.

As we embarked on developing the Proposal Tracker Tool, our focus was on delivering a product that not only met but exceeded the client’s expectations, setting a new standard in O365-based for proposal management solutions.

Project Description

While revolutionising proposal management, the client evolved from an Excel-based tool to a robust Microsoft SharePoint online solution. 

Innovative Proposal Management: The client, recognizing the need for an efficient proposal tracking system, developed a sophisticated tool initially based on Excel. This spreadsheet solution included tables, macros, and formulas but faced challenges—lacking robustness, prone to errors, and offering a less user-friendly interface.

Transition to MS SharePoint Online Solution: Acknowledging the limitations of the Excel-based approach, the client made a strategic decision to elevate the proposal management system. The focus shifted to crafting a SharePoint solution, providing a more robust and user-friendly online interface. This transition ensured an error-resistant proposal tracking experience for the client within their O365 environment.

Enhanced Efficiency: The move to SharePoint signified a commitment to enhancing efficiency and eliminating the drawbacks associated with the previous Excel-centric system. The client’s forward-thinking approach underscores their dedication to leveraging technology for optimal proposal management.

This strategic transition enhanced efficiency of work, eliminated errors, and prioritized a user-friendly online interface within O365.

Detailed Analysis

Our process began with a meticulous analysis, assessing current tools and needs. We strategically opted for Microsoft SharePoint Online, ensuring scalability. With a robust provisioning engine and automated workspace creation, we worked towards optimal efficiency.

Thorough Analysis: A comprehensive analysis and evaluation was conducted, scrutinising the existing spreadsheet, assessing use cases, and identifying licence requirements to inform the solution.

Strategic Framework Selection: After careful consideration, SharePoint was chosen as the framework for the proposal management solution, ensuring scalability, integration, and a seamless user experience.

Provisioning Engine Development: A robust provisioning engine was developed, enabling deployment to any SharePoint tenant with ease. Execution of a few PowerShell scripts streamlined the implementation process.

Automated Workspace Creation: The system incorporated an innovative approach with Power Automate Flow and PnP Provisioning Engine, automating the creation of a dedicated proposal workspace site for each entry in the Proposal Tracker list. This dynamic feature enhanced the workflow in the organization and collaboration throughout the proposal lifecycle.

Services Provided

We offer a comprehensive suite of services tailored to meet diverse business needs. 

Product Design Consulting 

Technical Feasibility Report

Scoping Sessions

Digital Transformation

Application Development

Quality Assurance

Support

Innovative Technology Stack

SharePoint: At the core of our solution, SharePoint provided a robust and scalable framework, facilitating seamless collaboration and information management.

Power Automate: Leveraging automation, Power Automate streamlined workflows, enhanced efficiency, and ensured smooth information flow across the system.

Azure Runbook: Our solution integrated Azure Runbook, adding a layer of automation to optimise processes and improve overall system performance.

Office 365: Harnessing the power of Office 365, our solution ensured a cohesive and integrated digital workplace, fostering productivity and collaboration.

PowerShell: Execution of PowerShell scripts played a pivotal role, enabling efficient deployment, configuration, and management of the solution within SharePoint and Office 365 environments.

This meticulously curated technology stack reflected our commitment to leveraging state-of-the-art tools, ensuring a dynamic and future-ready proposal management system. Through the synergy of these technologies, we delivered a solution which met the evolving demands of modern business environments.

Conclusion

Our collaboration with the leading IT Products and Solutions Provider from Canada resulted in a transformative SharePoint-based Proposal Tracker Solution. By meticulously analysing existing challenges and implementing an innovative technology stack, we not only met but exceeded the client’s expectations. This shift showcased their dedication to innovation, adaptability, and scalability. The enhanced efficiency, error reduction, and user-friendly interface within O365 positioned our solution as a new standard for proposal management. Our commitment to leveraging cutting-edge technologies underscored our ability to deliver dynamic and future-ready solutions tailored to meet the evolving demands of modern business environments.