AI-Generated Hints
Table of contents
Pre-defined hint instructions
Our solution leverages the power of Artificial Intelligence to offer Hints - they are suggestions to what you can ask your selected data source. These recommendations are generated exclusively from your database schema, strictly considering table and column names, while ensuring that no actual data from your database is used or compromised.
Hints can generate a myriad of insights to various types of users, currently including:
- General insights: Broad views and interpretations of your database.
- Business insights: Delivers valuable guides specific to enterprise operations.
- Marketing insights: Offers helpful hints relevant to marketing strategies and campaigns.
- Developer insights: Provides useful tips designed for developer endeavors.
- SQL Learner insights: Gives useful pointers for those learning SQL.
- Custom hints: Enables you to formulate specific instructions. See below.
Custom hint instructions
Custom hint instruction enables you to give more precise instructions for what AI should investigate. It can be a broad instruction or a particular analytic approach. Examples for business analysis are:
- Identify low profitability products
- Identify new business opportunities
- Data insights for a SWOT analysis
- Identifying new business opportunities and low profitability area
You can also be more specific an mention specific tables and more.
Inspiration for instructions
Inspiration for what you can ask, how to phrase it and terminology:
Example
The "Identifying new business opportunities and low profitability area" generates the following hints:
- What are the top-selling film categories?
- Which film categories are not performing well in terms of sales?
- Which cities have the highest and lowest number of customers?
- What is the average rental rate per film category?
- What is the average payment amount per customer?
- Which films have the highest and lowest rental rates?
- What is the total sales per store?
- Which stores have the highest and lowest total sales?
- What is the average sales by film category per store?
- Which actors' films have the highest and lowest sales?
- What is the distribution of customers across different countries?
- What is the average rental duration per film category?
- What is the correlation between film rating and sales?
- What is the correlation between film length and sales?
- What is the profitability of each film category?
- Which staff members have the highest and lowest sales?
- What is the average number of rentals per customer?
- What is the average number of rentals per store?
- What is the correlation between the number of rentals and total sales?
- What is the correlation between the release year of the film and its sales?