ChatBots that draw charts

1. My Favourite Feature
2. YouTube Clip
3. How it works

One of our clients, BrainyRMS, helps hotels optimise their pricing on a daily basis.

We've built a chatbot for them that can answer complex questions about a hotel's financial performance.

My Favourite Feature

My favourite feature is that it can draw charts and email them to you.

Here's an example of what that looks like in the chatbot:

YouTube Clip

Here's a YouTube clip showing off what it can do. Have a look!

How it works

And here's how it works:

1. Behind the scenes the chatbot has an understanding of the data schema of the database powering the application
2. When the bot gets a question questions, we ask ChatGPT to formulate an SQL query that could return the answer
3. We then run the query and give ChatGPT the results
4. If it is a time series, we ask ChatGPT to populate a JSON schema template that acts as the configuration for the chart
5. We render the chart and attach it as an image to ChatGPT's response

And that's how you can go straight from a natural language question to a chart giving you the answer.