The implementation of Generative AI using AWS technologies has transformed data management processes for a cannabis cultivation company, exemplifying a successful business-led transformation within the agricultural sector.

AWS Services Utilized:

• Amazon Bedrock: Provided the LLM to build the SQL Agent, enabling simple chat-based querying.

• Amazon ECS Containers: Facilitated scalable and efficient processing of metadata within a containerized environment.

• Databricks hosted through AWS.

Business Transformation:

• Traditional Approach: Apogees’s previous method of querying databases required knowledge of SQL, requiring significant time and effort to organize and retrieve information. This approach led to inefficiencies and limited their ability to scale operations.

• Generative AI Transformation: By transitioning to an AWS-based Generative AI approach, Apogee achieved a significant improvement in efficiency. The SQL Agent powered by Amazon Bedrock provided advanced, automated querying capabilities, reducing the time required to retrieve relevant information. This allowed querying to scale their operations and improve client satisfaction.

Quantitative Business Metrics

The adoption of Large Language Models (LLMs) integrated with the company’s data warehousing systems has dramatically improved efficiency in data handling and decision-making processes:

– Reduction in Data Retrieval Time: The shift from traditional SQL queries to NLP-driven queries has reduced data retrieval time, enabling quicker response to operational needs.

– Increase in Decision-Making Speed: The ability to use natural language for querying has accelerated decision-making processes, as non-technical staff can now access and analyze data without intermediary technical assistance.

– Cost Savings: Automating query processes has decreased the need for additional SQL training for staff, resulting in a reduction in training costs and a 20% decrease in manpower costs related to data management.

Generative AI Adoption and AWS-Based Deployment

The company’s transition to a Generative AI approach involved deploying LLMs that enable NLP for querying within their AWS-based production environment. This implementation leverages AWS services such as Amazon Bedrock for building and deploying the AI models.