About Senpai
Senpai is an AI-powered data analyst designed to help users interact with databases effortlessly. Currently, Senpai is trained on the AdventureWorks database, allowing you to ask questions and retrieve insights instantly-all without needing SQL expertise.
About AdventureWorks Database
AdventureWorks is a fictional multinational manufacturing company used as a sample database by Microsoft. It represents a bicycle and outdoor gear business, covering sales, products, customers, and financial data-making it an ideal dataset for real-world analytics and business intelligence.
With Senpai, you can seamlessly query AdventureWorks, analyze trends, and explore data-driven insights just by asking.
Example Questions
- What is the total internet sales amount for each product category in the year 2013?
- How many customers are there in each country, and what is the average yearly income of customers in each country?
- Which employee has the highest total reseller sales amount in the year 2013, and what is that amount?
- What is the total discount amount given for each English promotion type in the first quarter of 2012?
- Which department group has the highest total revenue in the Budget scenario, and what is that revenue amount?
- What is the distribution of customers by marital status and gender in the United States?
- What is the month-over-month growth rate of total internet sales amount for each month in 2013?
- What is the average price for each product subcategory from internet sales?
- Which products have a list price above the average list price of all products, and what are their current list prices?
- What is the total number of employees in each department, and what is their average base rate?
- Which customers have the highest number of orders from internet sales, and how many orders have they placed?
- List how many customers exist in each gender, marital status and commute distance group, showing their average annual income, but only include those with more than two children.
- Show the total revenue, tax, and freight charges from reseller orders, grouped by business type, only for those who have their first order after 2010, and separate the results by each calendar year.
- Find each employee who is a reseller, include their basic pay rate and pay frequency, and sum up their total sales from the year 2013.
- Show me the top 10 customers who have made purchases exceeding $500 in total from internet sales, and what is their average total purchase amount?
- What is the average of the daily average time per issue for each shift in the call centre?