What's New
Release 3.2
Release 3.1
Release 3.0
Release 2.4.1
Release 2.4
Free Cloud Trial
Release 2.3
Release 2.2
Release 2.1
Release 2.0
Release 1.8
Release 1.7
Release 1.6
Release 1.5
Tellius Home
Search (Natural Language)
Search in Tellius
Guide Me
How to Search
Business View List / Columns
Query
Search Result
Discover Insights
Interactions
Chart Operations
Add to Vizpad
Table View
Switch Chart type
Change Chart Config
Apply Filters
Change Formatting
View Raw Data
Download/ Export
Embed URL
Best-fit visual
Add to Vizpad
Adding the chart to a Vizpad
Search Query Inspector
Teach Tellius
History
Guided Search
Deep Dive
Search Synonyms
Maps in Search
Percentage Queries
Time Period Queries
Additional Filters
Pagination
List View In Search Results
Embed Search
Personalized Search
Search Cheat Sheet
Assistant (Conversations)
Conversations in Tellius
Guide Me
How to have Conversations w/ your Data
Tellius Assistant
Explore (Vizpads)
Dashboards in Tellius
Vizpad Creation
Create Interactive Content
Create Visualization Charts
List of Charts
Common Chart Types
Line Chart
Bar Chart
Pie Chart
Area Chart
Combo Chart
Treemaps
Bubble Chart
Histogram
Heat-Map Charts
Scatter Chart
Other Charts
Cohort Chart
For each chart
Create Visualization Charts
Global Filters
Embedded Filters
Other Content
Creating Interactive Content
Vizpad level Interactions
Viz level Interactions
Vizpad Consumption
Embedding Viz & Vizpads
Feed (Track Metrics)
Discover (Genius Insights)
Discoveries
What are discoveries
Type of Discoveries in Tellius
Create Discoveries
Edit Discoveries
Kick-off Key Drivers
Key Driver Insights
Components of Key Drivers
What are Key Drivers
Edit Key Driver Insights
Segment Drivers
Trend Drivers
Trend Insights (Why Insights)
Comparison Insights
Components of Comparison Insights
Create Comparison Insight
What are Comparison Insights
Edit Comparison Insights
Others Actions
Impact Calculation for Top Contributors
Predict (Machine Learning)
Machine Learning
AutoML
How to create AutoML models
Leaderboard
Prediction
Others
What is AutoML
Point-n-Click Predict
Data (Connect, Transform, Model)
Connectors
Connector Setup
Options for each connector
Edit Connector
Live Connect
Data Import
Cache
Direct Business View
JDBC connector for PrestoDB
Snowflake
List of Connectors by Type
Tables Connections
Custom SQL
Schedule Connector Refresh
Share Connections
Datasets
Load Datasets
Configure Datasets (Measure/Dimensions)
Transform Datasets
Create Business View
Share Datasets
Copy Datasets
Data Prep
Datasets
Data Profiling / Statistics
Transformations
Dataset Transform
Aggregate Transforms
Calculated Columns
SQL Transform
Python Transform
Create Hierarchies
Filter Data
Column Transforms
Column Metadata
Column type
Feature type
Aggregation
Data type
Special Types
Synonym
Rename Column
Filter Column
Delete Column
Other Functions
Dataset Information
Dataset Preview
Edit / Publish Datasets
Data Pipeline (Visual)
Alerts
Export Dataset
Data Fusion
Schedule Refresh
Business Views
Create Business View
Create Business View
Datasets Preview & List
Add datasets to Model
Joins
Column selection
Column configuration
Primary Date
Geo-tagging state/country/city
Save to Fast Query Engine
Publish
Business View
What is Data Model
BV Visual Representation (Preview)
BV Data Sample
Learnings (from Teach Me)
Custom Calculations (Report-level Calc)
Predictions on BV
BV Refresh
Export/ Download Business View
Share Business View
Projects (Organize Content)
Help & Support
Help & Support
Guided Tours
Product Videos
Articles & Docs
FAQ
Provide Feedback
Chat with Tellius
Support Process
Getting Started Videos
Getting Started
Tellius Connect
Tellius Data Overview Video
Connecting to Flat Files Video
Connecting to Data Sources Video
Data Refresh and Scheduling Video
Live Connections Video
Tellius Prep
Getting Started with Tellius Prep Video
Transformations, Indicators, Signatures, Aggregations and Filters Video
SQL and Python Video
Working with Dates Video
Data Fusion Video
Report Level Calculations Video
Business View Video
Business Mapping Video
Writeback to DB
Natural Language Search
Getting Started with Search Video
How-To Search Video
Customizing Search Results Video
Search Interactions Video
Help Tellius Learn
Explore - Vizpads
Getting Started with Vizpads Video
Creating Vizpads Video
Creating and Configuring Visualizations Video
Viz-Level Interactions Video
Vizpad-Level Interactions Video
Auto Insights
Getting Started with Auto Insights Video
Discovery Insights Video
Segment Insights Video
Trend Insights Video
Comparison Insights Video
Iterate on Insights Video
Tellius Feed Video
Predict - ML Modeling
Getting Started with Predict Video
AutoML Configuration Video
AutoML Leaderboard Video
Point-n-Click Regression Video
Point-n-Click Classification Video
Point-n-Click Clustering Video
Point-n-Click Time Series Video
Point-n-Click PythonML Video
Explainable AI Video
PredictAPI Video
Apply ML Model Video
ML Refresh and Schedule Video
Admin
System Health
Notifications
Embedding & White label
Admin
Admin Settings
Manage Users
Team (Users)
Details & Role
Create a new user
Edit user details
Assigning the user data to another user
Restricting the dataset for a user
Deleting a user
Teammates (Groups)
Authentication & Authorization
Application & Advanced Settings
Settings
Setup & Configuration
Installation Guide
- All Categories
- Search (Natural Language)
- Guide Me
- Art of Possible
- Art of Possible v/s Natural Search
Art of Possible v/s Natural Search
Updated
by Hardik Chheda
In the case of machine intelligence, getting the right answers for questions is quite challenging.
Tellius, being supporting both AI and ML, not just understand the questions asked in a query form, a natural human language, or even in spoken English language, but also give the deep insights from the data source.
While asking the questions, you must be specific in what information you want to know. This can help Tellius retrieve the best results from the data source.
This article helps you in knowing the right question that you can ask Tellius.
Basic Questions
Let's look at a list of basic questions to ask Tellius. These are the simple questions that can be used as a starting point before going in-depth in your analysis.
- show total Profit
- show average Profit (in Sales Analytics)
- show count Profit for California
- show Category
- show total Category
- show Profit and Sales
- show Sales and Revenue by Category
- show sum Profit by Country
- show total Profit and Sales by SubCategory by Country
Looking at the various questions you can ask, you'll notice the way Tellius processes questions: it handles specific questions well. The more specific you are, the better data you receive.
Intermediate/Advanced Questions
These questions could be basic but with a little more specifications, such as time range, date, resolution, filter, compare to or contains.
FILTERS
The following questions retrieve the information based on the specified filter conditions:
- show average Profit by Country for Furniture
- show total Sales by ProductName for Texas
- show maximum Revenue for State = Texas and State = California
- show sum Profit by SubCategory for France for Furniture
DATES/TIME RANGE
The following questions retrieve the information in a specific date and time range:
- show minimum Users for last 2 months
- show top 3 Revenue by Region this year
- show bottom 9 Profit by Country and State for last 6 years
RESOLUTION
- show sum Profit weekly
- show average ShippingCost by Market monthly
- show total Revenue monthly for Quantity > 2
- show total Sales daily for Quantity = 4
- show Sales and Profit quarterly
- show sum Sales and sum Profit by Country daily
- show Sales and Profit by Category monthly
CONTAINS
The following questions retrieve information based on the fields containing specific information:
- show total Discount by Region for Safeway for Country contains C
- show sum Profit by SubCategory for Category contains Technology
- show average Sales by Products for SubCategory contains Book
COMPARE TO
The following questions retrieve information by comparing different values in fields:
- show sum Profit by Country for Technology compared to Furniture
- show average Sales compared to average Revenue
- show sum Sales for Consumer compared to Corporate
- show total Sales by Category for Ohio compared to Texas
FILTER, RESOLUTION, TIME RANGE, & COMPARE TO
The following questions retrieve information based on multiple conditions:
- show sum Profit by Country for Technology compared to Furniture monthly for last 4 years
- show sum Sales quarterly for Consumer compared to Corporate
- show sum Quantity quarterly for West compared to East for last 7 years
TREND, GROWTH, SEGMENTS
The following questions retrieve the statistical information, like trends, growth, and segmentation. Specific keywords trend, growth, and segments are used in the question:
- show trend of average sales monthly for this year
- show growth of sales yearly
- show growth of Sales by Products monthly
- show trend of Sales by Category yearly
- show trend of average Sales weekly for California compared to Ohio
- show trend of average quantity and average sales daily for last 2 years
- show segments average sales and average revenue by category
- Show segments between Profit and Sales by SubCategory for Category contains Technolog
TOP / BOTTOM
The following questions retrieve the high performing and low performing fields based on the specified conditions. The specific keywords top, and bottom are used in the question:
- show bottom 5 Cost by Category for last 3 years
- show top 3 Revenue by Region this year
- show bottom 5 Cost by Category
- show top 10 Sales by Category and Country
PERCENTAGES
The following questions retrieve the profit details in terms of percentage. The specific keyword Profit is used in the question:
- What's ****the percentage Profit for Technology compared to Furniture
- What is the percentage Profit by Category
- Give me the percentage Profit for Technology compared to Furniture for all Category
TIME BASED
The following questions retrieve the profit details for a particular time range. The specific keyword Profit is used in the question:
- show me the total Profit for 2013 compared ****to 2014
- show ****the total Profit for Jan 2013 compared ****to Feb 2013