Business Situation
- A leading engineering, procurement, and construction (EPC) client was facing a lack of an integrated system for organizing unstructured data from internal platforms such as SharePoint and OneDrive, which resulted in inefficiencies in proposal preparation.
- As a result, responding to requests for proposals (RFPs) was time-consuming, limiting their ability to scale operations effectively and eroding employee time.
SGA Approach
- Consolidated fragmented data from internal and external sources into a medallion architecture using Microsoft Fabric
- Leveraged Microsoft Graph APIs to organize data from structured and unstructured sources across platforms like SharePoint and OneDrive
- Prepared data for multimodal large language models (LLMs) to enable AI-driven solutions
- Deployed an AI-powered assistant using OpenAI and Azure AI Studio to support project teams in analyzing RFP requirements and preparing proposals efficiently
- Enabled our client to transform its approach to data integration and proposal preparation by leveraging advanced Azure technologies and AI-driven solutions
Key Takeaways
- Efficiency gains in response time
- Reduced RFP response time by 75%
- Centralized KPI metrics in a gold-layer lakehouse improved project management reporting
- Streamlined access to data from varied sources saved significant time for project teams
- Reduced data retrieval times across functions in the organization
