Product Features Overview
Olytix Core includes a comprehensive suite of advanced features designed to make data analysis more accessible, efficient, and collaborative. These features build on the core semantic layer to provide intelligent assistance, operational excellence, and enterprise-grade governance.
Feature Categories
Intelligent Query Assistant
The Query Assistant provides a natural language interface for data exploration. Users can ask questions in plain English and receive optimized semantic queries.
Key Capabilities:
- Intent Detection - Automatically understands what type of analysis you want (aggregation, comparison, trends, rankings)
- Entity Extraction - Identifies measures, dimensions, filters, and time periods from natural language
- Smart Autocomplete - Suggests completions based on your semantic model
- Conversational Refinement - Ask follow-up questions to refine your query
- Query Explanation - Get plain-English explanations of what the query does
Learn more about Query Assistant →
Anomaly Detection
Proactively monitor your metrics for unexpected changes with statistical anomaly detection.
Key Capabilities:
- Multiple Detection Algorithms - Z-Score, IQR (Interquartile Range), and MAD (Median Absolute Deviation)
- Severity Scoring - Automatically assess the severity of detected anomalies
- Business Impact Assessment - Understand the business impact of anomalies
- Root Cause Analysis - Drill down to identify potential causes
- Correlation Analysis - Find related metrics affected by the same issue
- Alert Management - Group, route, and deliver alerts through multiple channels
Learn more about Anomaly Detection →
Data Profiling
Understand your data deeply with automated profiling and quality scoring.
Key Capabilities:
- Statistical Profiling - Compute statistics for numeric, string, and temporal data
- Distribution Analysis - Generate histograms and frequency distributions
- Quality Scoring - Assess data quality with completeness, validity, and consistency metrics
- Insight Detection - Automatically detect patterns, outliers, and data issues
- Smart Sampling - Profile large datasets efficiently with intelligent sampling
Learn more about Data Profiling →
Collaborative Workspaces
Enable team collaboration with shared workspaces for queries and analysis.
Key Capabilities:
- Team Workspaces - Create shared spaces for teams to collaborate
- Query Library - Save, organize, and discover queries
- Version Control - Track changes to queries with full version history
- Comments & Discussions - Collaborate through comments on queries
- Sharing & Permissions - Share queries with specific users or via public links
- Export Capabilities - Export queries and results in multiple formats
Query Cost Optimization
Control data warehouse spend with cost prediction and guardrails.
Key Capabilities:
- Cost Prediction - Estimate query costs before execution
- Pre-Aggregation Savings - See potential savings from using pre-aggregations
- Query Guardrails - Set limits on cost, time, and data scanned
- Budget Tracking - Monitor spending per user, team, or project
- Optimization Recommendations - Get actionable suggestions to reduce costs
Learn more about Query Optimization →
Query Explanation
Understand how your queries execute with visual execution plans.
Key Capabilities:
- Logical Plan - See the abstract execution plan
- Physical Plan - View warehouse-specific execution details
- Pre-Aggregation Analysis - Understand if and why pre-aggregations are used
- Cost Breakdown - Detailed cost estimates by operation
- Visual Formats - ASCII, Mermaid, and DOT diagram exports
- Plan Comparison - Compare two query plans side-by-side
Learn more about Query Explanation →
Data Governance
Maintain data quality and compliance with enterprise governance features.
Key Capabilities:
- Certification Workflow - Establish trust through formal certification (Draft → Review → Certified)
- Business Glossary - Maintain authoritative definitions for business terms
- Ownership Model - Assign data owners, stewards, and technical owners
- Audit Logging - Track all access and changes to data assets
- Compliance Reports - Generate reports for regulatory requirements
Learn more about Data Governance →
Pre-Aggregations
Accelerate queries with materialized rollups that reduce costs by up to 99%.
Key Capabilities:
- Automatic Query Matching - Queries automatically use pre-aggregations when available
- Flexible Refresh - Scheduled, on-demand, or incremental refresh options
- Partitioning - Partition large pre-aggregations for efficient updates
- Build Monitoring - Track build status, success rates, and performance
- Cost Savings Tracking - Monitor how much pre-aggregations save
Learn more about Pre-Aggregations →
Feature Matrix
| Feature | Primary Users | Use Case | Automation |
|---|---|---|---|
| Query Assistant | Analysts, Business Users | Ad-hoc analysis | Query generation |
| Anomaly Detection | Data Engineers, Analysts | Monitoring & Alerting | Detection & Alerts |
| Data Profiling | Data Engineers | Data Discovery | Profile generation |
| Workspaces | All Teams | Collaboration | Notifications |
| Query Optimization | Analysts, Admins | Cost Control | Guardrails |
| Query Explanation | Analysts, Engineers | Debugging | Plan analysis |
| Data Governance | Stewards, Compliance | Trust & Compliance | Certification |
| Pre-Aggregations | Engineers, Admins | Performance | Scheduled builds |
Getting Started
Each feature can be used independently or together for a comprehensive analytics experience:
- Start with Profiling - Understand your data before building queries
- Use Query Assistant - Ask questions naturally and learn the semantic model
- Set up Governance - Establish ownership and certify key metrics
- Create Pre-Aggregations - Accelerate common query patterns
- Configure Cost Guardrails - Prevent expensive queries
- Enable Anomaly Detection - Monitor critical metrics proactively
- Create Workspaces - Collaborate with your team on analysis
API Support
All features are accessible via REST API, enabling integration with your existing tools and workflows:
| Feature | API Prefix |
|---|---|
| Query Assistant | /api/v1/assistant/* |
| Anomaly Detection | /api/v1/anomaly/* |
| Data Profiling | /api/v1/profiling/* |
| Workspaces | /api/v1/workspaces/* |
| Query Optimization | /api/v1/optimization/* |
| Query Explanation | /api/v1/explain/* |
| Data Governance | /api/v1/governance/* |
| Pre-Aggregations | /api/v1/preaggregations/* |
Next Steps
- Query Assistant Guide - Natural language querying
- Anomaly Detection Guide - Proactive monitoring
- Data Profiling Guide - Data understanding
- Workspaces Guide - Team collaboration
- Query Optimization Guide - Cost control
- Query Explanation Guide - Debugging queries
- Data Governance Guide - Trust and compliance
- Pre-Aggregations Guide - Query acceleration