Maximising Business Revenue Using Vanna.AI
Imagine you are a business owner, and lately, revenue has been lower than usual, and you would want to understand, WHY!!
You cannot afford to wait for your team’s analysis, but personally are unable to write SQL code to get the data.
Introducing Vanna, “Your AI Business Intelligence Assistant”. It can answer the questions you ask with data and visuals, all without you writing a single line of SQL. It is clear, comprehensive, and frictionless.
We are going to illustrate the power of Vanna in a few questions that can help you quickly pinpoint major opportunities for Revenue in your business.
Let’s start with a few questions ->
Just ask, “Hey Vanna! Find me the average revenue per user ? “
And there you have it. Vanna understood your data, wrote some code and put forth a clean and crisp answer to your question.
You have the ARPU at 3030$ as per Fig 1.1, you have a faint memory of the past, the ARPU used to be $4000, this seems out of place!
Are you’re curious and want to know more on why the revenue has dropped?
A quick and obvious follow up question may be to find the percentage of users who have extremely low revenue and those who have an acceptable amount of revenue.
This is a common pattern — where one question naturally leads to the next question.
Just ask, “Hey Vanna! What is the distribution of average revenue per user ?”
Vanna has generated this really cool histogram of average revenue per user for us. It would have taken a while to write this SQL manually!
The data in Fig 2.1, shows the distribution of average revenue per user in different buckets. The bucket with the most users falls between 500–1000, followed by 1000–1500 and 1500–2000 buckets. The highest bucket is between 10500–11000, but it has the lowest number of users.
In other words, we have found the problem. A lot of customers spend less than $1500. But why?
Your instinct says — that these user won’t have our premium tech support.
Just ask, “Hey Vanna! What % of users with less than 1500, and revenue greater than 4000 have premium tech support respectively ?”
Vanna automatically generates this really complicated SQL statement, which would have taken a significant amount of time to write, for an analyst.
It also leads to this insightful chart (Fig 3.2), which shows us that a very small percentage of the low-spending users have access to premium tech support.
Finally, your final question might be the geographical epicentre of the problem statement.
Just ask, “What is the percentage of users with premium tech support in each of the top 10 cities with the most customers ?”
There’s your Data-Driven Insight, despite Los Angeles and San Diego being our biggest markets, they have a very small percentage of users subscribed to premium tech support.
Summarising -
Vanna possesses exceptional power to become your data-driven co-pilot, helping you make decisions by answering the most important questions, in a clear, comprehensive and frictionless way.
By cutting out the need to manually write long and lengthy queries and analyzing it, Vanna democratizes and enhances access to data-driven insights. Insights made accessible, that’s Vanna.
Connect your Snowflake data warehouse today!
If you have issues, just hit us on Slack and we’ll get back quickly.
