01 Oct 2024

Democratising data analysis with Toqan

 

Our AI team has developed a specialised AI agent for data analysis to make data easily accessible for everyone within a company through a simple chat interface. Learn more about what’s involved in building an AI solution like this.

Companies in sectors like food delivery, retail, and payments generate vast amounts of data. And if employees need insights into this data, a data analyst colleague would usually provide these. But good analysts can be expensive and difficult to find, and as their time is limited, they must focus on the most important tasks. This makes it harder for many companies to get fast data insights, slowing down decision-making.

To make data easily accessible to everyone within a company, our AI team has developed Toqan Data Analyst, an AI agent specialised in data analysis. This agent helps employees get answers to questions about data more quickly, without needing any technical skills. Through a simple chat interface, they can ask Toqan questions like “How many couriers have received a 5-star review in the last 30 days in the city of London, broken down per vehicle type?”. Toqan turns their questions into SQL queries to search databases, pulls the data, and turn this into answers in simple language. It can visualise data for them, too.

High degree of accuracy

Developing an AI solution that can get data insights quickly and accurately based on plain-language questions is quite an achievement. It needs to be able to turn plain-language questions into SQL queries – a process called text-to-SQL – with a high degree of accuracy.

Before landing on an agent as the best solution, the team looked at using large-language models (LLMs) for text-to-SQL. But they quickly found that LLMs can’t generate SQL queries with enough accuracy in real-world situations with complex data. Even though some models reached 85 to 90% accuracy, this percentage is not high enough for people working with large datasets of transactional, supply chain, or even financial data. LLMs fall short in real-life situations because they lack context about the organisation and its database structure or the person asking the question, the data they need to work with is of low quality, or people haven’t entered a strong prompt.

An AI agent is great at solving these problems, so the team focused their attention there. Broadly speaking, agents make decisions and take actions on their own following users’ general instructions. They have a powerful LLM at their core that creates a multi-step action plan. In addition to this, agents have access to tools to carry out the action plan step by step, remember past interactions and behaviour, and spot and correct any mistakes they may run into. They perform particularly well in specific tasks such as data analysis.

Our Toqan Data Analyst agent has more context, asks people to clarify requests if needed, mentions any assumptions it has made in the process, and indicates when it can’t find an answer to minimise false positives. Ultimately, it gives people more accurate answers to questions about business data, so they can make faster decisions.

Read more

If you’d like to read more about AI agents and the AgentOps landscape, click here.

About Prosus

Prosus is a global consumer internet group and one of the largest technology investors in the world.

Operating and investing globally in markets with long-term growth potential, Prosus builds leading consumer internet companies that empower people and enrich communities.

The group is focused on building meaningful businesses in the online classifieds, food delivery, payments and fintech, and education technology sectors.

Through the Prosus Ventures team, the group invests in new technology growth opportunities within logistics, fintech, health, blockchain, social and ecommerce platforms, agriculture and more.

The team actively backs exceptional entrepreneurs who are using technology to improve people’s everyday lives.

Each month, more than 2 billion customers across the globe use the products and services of companies that Prosus has invested in, acquired or built. To find out more, please visit www.prosus.com