Amity Solutions partnered with Lotus’s to introduce a Natural Language Query (NLQ) platform integrated with a chatbot interface, making it easy for non-technical users to retrieve insights just by asking questions in Thai or English in plain language.
<big-nr>15 s<big-nr>
<cs-number-text>Unlock insights faster an average of only 15 seconds<cs-number-text>
<big-nr>30 K<big-nr>
<cs-number-text>30,000+ messages/ month<cs-number-text>
<big-nr>800<big-nr>
<cs-number-text>800+ unique users/ month<cs-number-text>
In the fast-paced world of retail, store managers are under constant pressure to make quick decisions based on real-time performance. Lotus’s, one of Thailand’s largest retailers, recognized that despite having access to abundant data, actionable insights remained out of reach for many frontline teams. The company sought a way to empower its 3,000+ store managers to make smarter decisions from the palm of their hand.
Amity Solutions partnered with Lotus’s to introduce a Natural Language Query (NLQ) platform integrated with a chatbot interface, making it easy for non-technical users to retrieve insights just by asking questions in Thai or English in plain language like "Which SKUs are underperforming this week?". No dashboards, no delay, just instant answers.
With Amity’s NLQ-powered solution, Lotus’s has redefined how insights are accessed and acted upon at the store level. Rather than navigating multiple systems or reports, store teams now engage directly with their data using natural questions, reducing dependency on head office and speeding up reaction time to on-ground events.
The chatbot interface, integrated with both desktop and mobile platforms, ensures that data is always available on the go. Whether it’s identifying underperforming SKUs or validating promotional effectiveness, store leaders are now equipped to make decisions instantly and independently.
With a backend powered by scalable infrastructure, our solution, EkoAI, provides answers within 5 seconds to 1 minute, enabling real-time analysis of store-level operations via mobile or desktop. Insights that once took hours are now just a question away.
Whether checking on sales anomalies, stock provisions, or weekly known loss reports, managers can act faster, increasing store-level efficiency, agility, and performance.
This chart illustrates the increasing usage of an AI-powered system by tracking two key metrics over time (from September 2024 to April 2025)
The data clearly demonstrates an upward trend in both system engagement (message volume) and user base (unique users), showcasing increased adoption and utilization of the AI capabilities across the organization.
To go beyond traditional query-based insights, Amity introduced a To-Do List (TDL) feature, a daily AI-generated briefing tailored for each store. It highlights anomalies, performance gaps, and high-priority actions across:
Store managers start their day at 8:00 AM with the TDL, which now replaces the need to open multiple BI tools or wait for IT reports.
<cs-quote>“TDL gives me insights I’ve never seen before. It helps me focus right away. I can spot abnormal sales, understand stock issues, and even see margin gaps, all before morning rounds are over.”<cs-quote>
<text-size-regular>— Store Manager, Lotus’s<text-size-regular>
Behind the scenes, the entire data and analytics engine is built on Databricks, ensuring speed, scalability, and robustness across thousands of locations. Amity Solutions implemented a Row-Level Security (RLS) model within the Databricks platform, ensuring that each store manager only accesses the data relevant to their store, preserving both privacy and operational integrity.
This architecture supports real-time data pipelines, daily AI task generation, and secure user-specific querying, all managed on a unified lakehouse platform.
The result is a seamless balance between enterprise-scale governance and on-the-ground usability.
Amity Solutions currently powers over 3,000 stores across Thailand. The AI chatbot receives 1,000+ messages daily on average, serving as the primary interface for retail intelligence, one that fits into store managers’ routines and devices.
By making data available instantly and in plain language. Amity has democratized data across every level of the Lotus’s organization. From frontline decision-making to regional strategy, the insights delivered have shortened response times, increased focus, and empowered every store to perform at its best.
The collaboration between Lotus’s and Amity Solutions marks a new chapter in modern retail operations, where every store manager has access to AI-powered insights, and every decision is backed by data delivered in real time.
With proven success across thousands of locations, this solution has redefined how Lotus’s teams work, making data not just accessible but actionable, personalized, and embedded into their daily workflow.
As Lotus’s continues to lead in digital transformation, the NLQ, TDL, and Databricks-powered infrastructure stand as a testament to what’s possible when technology is built for the people who use it most, delivering clarity, speed, security, and confidence at the frontlines of retail.
.webp)
