Aito Demo - Grocery Store ML
Interactive demonstration of Aito's predictive database capabilities through a grocery store e-commerce example. Explore recommendations, predictions, analytics, and model quality monitoring.
Database: aito-demo
Product Recommendations
Personalized product suggestions using ML
Welcome to Aito
Aito Predictive Database Demo
This workbook showcases Aito's ML capabilities using a grocery store dataset with 42 products, 70 users, and 733 shopping visits. Each query below runs live against the Aito API.
Personalized Recommendations
Aito's _recommend endpoint finds items that maximize purchase likelihood for each user. The result below loads automatically - try changing the user ID to see how recommendations differ.
Recommend Products for larry
Interactive recommend — results displayed as table.
Recommend for veronica
Interactive recommend — results displayed as table.
Recommend for alice
Interactive recommend — results displayed as table.
Invoice Processing
Automated document classification and routing
Invoice Automation
Automated Invoice Processing
Aito can automatically classify invoices and route them to the right people.
Use cases:
- GL Code Assignment - Predict the correct general ledger code
- Processor Assignment - Route to the right team member
- Explainable AI - Understand why predictions were made
The $why operator shows which fields influenced the prediction.
Predict GL Code
Interactive predict — results displayed as table.
Predict with Explanation ($why)
Interactive predict — results displayed as table.
Predict Invoice Processor
Interactive predict — results displayed as table.
Product Analytics
Product purchase statistics, demographics, and market basket analysis
Product Insights
Product Analytics
Analyze individual product performance using purchase data, user demographics, and market basket analysis.
The queries below analyze Pirkka banana (2000818700008) - try changing the product ID to explore other products.
Purchase Statistics
Interactive aggregate — results displayed as table.
Who Buys This Product? (Demographics)
Interactive relate — results displayed as table.
Market Basket - Bought Together
Interactive relate — results displayed as table.
Search Terms Leading to Purchase
Interactive query — results displayed as table.
Weekly Purchase Trends
Interactive query — results displayed as table.
Get Started
Try Aito with your own data
Try Aito with Your Own Data
Want to try this with your own data?
Everything you've seen above - recommendations, predictions, explainability, analytics - works on any structured dataset. Upload a CSV and start querying in minutes.
Data Exploration
Browse and understand the grocery store data
Explore the Data
Data Exploration
Browse the underlying tables. Click Run to execute each query, then modify them to explore further.
Browse Products
Interactive query — results displayed as table.
Browse Users
Interactive query — results displayed as table.
Browse Shopping Visits
Interactive query — results displayed as table.
Browse Invoices
Interactive query — results displayed as table.
Model Quality
Evaluate prediction accuracy and monitor model performance
Quality Monitoring
Model Quality Evaluation
Aito's _evaluate endpoint measures prediction accuracy using cross-validation.
Key metrics:
- Accuracy - Percentage of correct predictions
- Test Samples - Number of samples tested
- Mean Rank - Average position of correct answer
Monitor your models to ensure they maintain accuracy over time.
GL Code Prediction Accuracy
Interactive evaluate — results displayed as table.
GL Code with More Features
Interactive evaluate — results displayed as table.
Recommendation Accuracy
Interactive evaluate — results displayed as table.
Next Steps
Get started with Aito
Get Started with Aito
Ready to build with Aito?
You've seen recommendations, predictions with explainability, analytics, and model quality evaluation - all powered by a single predictive database.
Sign up free at aito.ai and start querying your own data in minutes.
Resources: